Oracle 18c RAC 环境，节点2数据库实例启动失败，报错如下：https://www.cndba.cn/cndba/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查看：https://www.cndba.cn/cndba/dave/article/3150
[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的权限，
https://www.cndba.cn/cndba/dave/article/3150https://www.cndba.cn/cndba/dave/article/3150
---------------------------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的目录权限：
https://www.cndba.cn/cndba/dave/article/3150
[root@www.cndba.cn grid]# chown -R grid:oinstall /u01/app/18.3.0/grid
之后数据库实例就无法正常启动。https://www.cndba.cn/cndba/dave/article/3150https://www.cndba.cn/cndba/dave/article/3150
https://www.cndba.cn/cndba/dave/article/3150
https://www.cndba.cn/cndba/dave/article/3150
这里最终的原因也就是bin/oracle权限引起，解决方法就是分别用GI和DB用户修改bin/oracle权限到6751即可： https://www.cndba.cn/cndba/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
然后就可以正常启动了：
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>
版权声明：本文为博主原创文章，未经博主允许不得转载。
