原环境:
Redhat Linux 6,Oracle 11.2.0.4 RAC,2个节点
安装完最新的GI PSU后,发现数据库无法启动,见下:
SQL> startup
ORA-01565: error in identifying file ‘+DATA/gd573/spfilegd573.ora’
ORA-17503: ksfdopn:2 Failed to open file +DATA/gd573/spfilegd573.ora
ORA-15001: diskgroup “DATA” does not exist or is not mounted
ORA-15040: diskgroup is incomplete
通过检查,确认集群服务和ASM均运行正常,此问题之前遇到过,是因为
ORACLEHOME/bin/oracle文件权限发生了变化。[oracle@qjdb1 ]
ls -l /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle
-rwsr-s–x. 1 oracle oinstall 239789597 Feb 9 17:27 /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle
在集群的所有节点上执行如下命令修改:
[root@qjdb1 ~]# chown oracle:asmadmin /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle
[root@qjdb1 ~]# chmod 6751 /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle