RAC有个节点启动报错,
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info
其中alert日志中报错:
Tue Sep 23 18:17:11 2014
ASMB started with pid=32, OS id=2449
ORA-00210: ???????????
ORA-00202: ????: ''+FRA/db11/controlfile/current.256.824234035''
ORA-17503: ksfdopn: 2 ?????? +FRA/db11/controlfile/current.256.824234035
ORA-15001: ??? "FRA" ????????
ORA-15055: ????? ASM ??
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 13: Permission denied
Additional information: 6848518
Additional information: 10
ORA-00210: ???????????
ORA-00202: ????: ''+DATA1/db11/controlfile/current.256.824234035''
ORA-17503: ksfdopn: 2 ?????? +DATA1/db11/controlfile/current.256.824234035
ORA-15001: ??? "DATA1" ????????
ORA-15055: ????? ASM ??
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 13: Permission denied
Additional information: 6848518
Additional information: 10
Starting background process ASMB
Tue Sep 23 18:17:11 2014
原因是由于这个节点上oracle文件权限问题
1.用grid用户进入ORACLE_HOME/bin下:
执行:
chmod 6751 oracle
2.用oracle用户进入ORACLE_HOME/bin下:
执行:
chmod 6751 oracle
节点启动,问题解决.虚拟机
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info
其中alert日志中报错:
Tue Sep 23 18:17:11 2014
ASMB started with pid=32, OS id=2449
ORA-00210: ???????????
ORA-00202: ????: ''+FRA/db11/controlfile/current.256.824234035''
ORA-17503: ksfdopn: 2 ?????? +FRA/db11/controlfile/current.256.824234035
ORA-15001: ??? "FRA" ????????
ORA-15055: ????? ASM ??
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 13: Permission denied
Additional information: 6848518
Additional information: 10
ORA-00210: ???????????
ORA-00202: ????: ''+DATA1/db11/controlfile/current.256.824234035''
ORA-17503: ksfdopn: 2 ?????? +DATA1/db11/controlfile/current.256.824234035
ORA-15001: ??? "DATA1" ????????
ORA-15055: ????? ASM ??
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 13: Permission denied
Additional information: 6848518
Additional information: 10
Starting background process ASMB
Tue Sep 23 18:17:11 2014
原因是由于这个节点上oracle文件权限问题
1.用grid用户进入ORACLE_HOME/bin下:
执行:
chmod 6751 oracle
2.用oracle用户进入ORACLE_HOME/bin下:
执行:
chmod 6751 oracle
节点启动,问题解决.虚拟机