12.2 rac db补丁升级无法mount问题

ALTER DATABASE   MOUNT
2020-07-22T08:47:54.126335+08:00
This instance was first to mount
2020-07-22T08:47:55.845223+08:00
NOTE: ASMB mounting group 2 (DATA)
NOTE: ASM background process initiating disk discovery for grp 2 (reqid:0)
WARNING: group 2 (DATA) has missing disks
ORA-15040: diskgroup is incomplete
WARNING: group 2 is being dismounted.
WARNING: ASMB force dismounting group 2 (DATA) due to missing disks
SUCCESS: diskgroup DATA was dismounted
NOTE: ASMB mounting group 2 (DATA)
NOTE: ASM background process initiating disk discovery for grp 2 (reqid:0)
WARNING: group 2 (DATA) has missing disks
ORA-15040: diskgroup is incomplete
WARNING: group 2 is being dismounted.
WARNING: ASMB force dismounting group 2 (DATA) due to missing disks
SUCCESS: diskgroup DATA was dismounted
2020-07-22T08:47:55.903640+08:00
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+DATA/TZLV2DB0/CONTROLFILE/control02.ctl'
ORA-17503: ksfdopn:2 Failed to open file +DATA/TZLV2DB0/CONTROLFILE/control02.ctl
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15040: diskgroup is incomplete
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+DATA/TZLV2DB0/CONTROLFILE/control01.ctl'
ORA-17503: ksfdopn:2 Failed to open file +DATA/TZLV2DB0/CONTROLFILE/control01.ctl
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15040: diskgroup is incomplete
2020-07-22T08:47:55.950258+08:00
ORA-205 signalled during: ALTER DATABASE   MOUNT...

  

问题原因:/u01/app/oracle/product/12.2.0/db/bin/oracle文件属性发生变化

[oracle@tz-yycs-db02 bin]$ ll oracle
-rwsr-s--x 1 oracle oinstall 409357928 Jul 22 09:24 oracle

  

解决办法:

#chmod 6751 /u01/app/oracle/product/12.2.2.0/db/bin/oracle
#chown oracle:asmadmin /u01/app/oracle/product/12.2.0/db/bin/oracle

  

原文地址:https://www.cnblogs.com/hanglinux/p/13358706.html