Oracle 18c RAC 环境，节点2数据库实例启动失败，报错如下：http://www.cndba.cn/dave/article/3150

[oracle@www.cndba.cn dbs]$ sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 - Production on Sun Nov 18 03:16:39 2018
Version 18.4.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/18.3.0/db_1/dbs/initcndba2.ora'
SQL> create pfile from spfile;
create pfile from spfile
*
ERROR at line 1:
ORA-01565: error in identifying file '?=/dbs/spfile@.ora'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7

SQL> create pfile from spfile='+DATA/CNDBA/PARAMETERFILE/spfile.278.986019415';
create pfile from spfile='+DATA/CNDBA/PARAMETERFILE/spfile.278.986019415'
*
ERROR at line 1:
ORA-01565: error in identifying file
'+DATA/CNDBA/PARAMETERFILE/spfile.278.986019415'
ORA-17503: ksfdopn:10 Failed to open file
+DATA/CNDBA/PARAMETERFILE/spfile.278.986019415
ORA-12547: TNS:lost contact
ORA-12547: TNS:lost contact

从这里看是不能识别到spfile，但实际上，spfile的配置并没有问题，在节点1查看：

[grid@www.cndba.cn .patch_storage]$ srvctl config database -d cndba -all
Database unique name: cndba
Database name: cndba
Oracle home: /u01/app/oracle/product/18.3.0/db_1
Oracle user: oracle
Spfile: +DATA/CNDBA/PARAMETERFILE/spfile.278.986019415
Password file: +DATA/CNDBA/PASSWORD/pwdcndba.257.986017503
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: 
Disk Groups: DATA
Mount point paths: 
Services: cndba_taf,pdb_taf
Type: RAC
Start concurrency: 
Stop concurrency: 
Database is enabled
Database is individually enabled on nodes: 
Database is individually disabled on nodes: 
OSDBA group: dba
OSOPER group: oper
Database instances: cndba1,cndba2
Configured nodes: rac1,rac2
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services: 
Database is administrator managed
[grid@www.cndba.cn .patch_storage]$

SQL> show parameter spfile

NAME                     TYPE            VALUE
------------------------------------ ---------------------- ------------------------------
spfile                     string            +DATA/CNDBA/PARAMETERFILE/spfi
                                le.278.986019415
SQL>

实际上是因为之前执行Patchauto过程中报权限不足，所有修改了GI HOME的权限，

---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /u01/app/18.3.0/grid, host: rac2.
Command failed:  /u01/app/18.3.0/grid/OPatch/opatchauto  apply /u01/28659165 -oh /u01/app/18.3.0/grid -target_type cluster -binary -invPtrLoc /u01/app/18.3.0/grid/oraInst.loc -jre /u01/app/18.3.0/grid/OPatch/jre -persistresult /u01/app/18.3.0/grid/OPatch/auto/dbsessioninfo/sessionresult_rac2_crs.ser -analyzedresult /u01/app/18.3.0/grid/OPatch/auto/dbsessioninfo/sessionresult_analyze_rac2_crs.ser
Command failure output: 
==Following patches FAILED in apply:

Patch: /u01/28659165/28547619
Log: /u01/app/18.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-11-17_14-46-37PM_1.log
Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: ApplySession failed in system modification phase... 'ApplySession::apply failed: mv: cannot move ‘/u01/app/18.3.0/grid/lib/libasmclntsh18.so’ to ‘/u01/app/18.3.0/grid/lib/libasmclntsh18.so.bak’: Permission denied
make: *** [update_patchrep] Error 1
' 

After fixing the cause of failure Run opatchauto resume

]
OPATCHAUTO-68061: The orchestration engine failed.
OPATCHAUTO-68061: The orchestration engine failed with return code 1
OPATCHAUTO-68061: Check the log for more details.
OPatchAuto failed.

然后直接修改了GI HOME的目录权限： http://www.cndba.cn/dave/article/3150http://www.cndba.cn/dave/article/3150http://www.cndba.cn/dave/article/3150

[root@www.cndba.cn grid]# chown -R grid:oinstall /u01/app/18.3.0/grid

之后数据库实例就无法正常启动。

这里最终的原因也就是bin/oracle权限引起，解决方法就是分别用GI和DB用户修改bin/oracle权限到6751即可： http://www.cndba.cn/dave/article/3150

[grid@www.cndba.cn bin]$ pwd
/u01/app/18.3.0/grid/bin
[grid@www.cndba.cn bin]$ chmod 6751 oracle
[oracle@www.cndba.cn ~]$ cd $ORACLE_HOME/bin
[oracle@www.cndba.cn bin]$ chmod 6751 oracle

然后就可以正常启动了：http://www.cndba.cn/dave/article/3150

SQL> startup
ORACLE instance started.

Total System Global Area 2768239832 bytes
Fixed Size            8899800 bytes
Variable Size          754974720 bytes
Database Buffers     1879048192 bytes
Redo Buffers            7876608 bytes
In-Memory Area          117440512 bytes
Database mounted.
Database opened.
SQL>

版权声明：本文为博主原创文章，未经博主允许不得转载。