ORA-01078: failure in processing system parameters

gdutllf2006發表於2014-03-06

環境:RAC11.2.0.3+Redhat6.1
節點啟動的時候遇到如下錯誤
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/posrac/spfileposrac.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/posrac/spfileposrac.ora
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 13: Permission denied
. For details refer to "(:CLSN00107:)" in "/u01/app/11.2.0/grid/log/posrac2/agent/crsd/oraagent_oracle/oraagent_oracle.log".
CRS-2674: Start of 'ora.posrac.db' on 'posrac2' failed


追查了半天,原來是主機組同事做安全檢查的時候把$ORACLE_HOME/bin/oracle的許可權修改了
正常的許可權應該如下:
[oracle@orabak bin]$ ll oracle
-rwsr-s--x 1 oracle oinstall 232399131 Dec 11  2012 oracle?

對生產環境的敬畏之心嚴重不夠,流程也規範.

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10248702/viewspace-1102511/,如需轉載,請註明出處,否則將追究法律責任。

相關文章