RAC oracle 許可權更改導致 實力啟動失敗

ORA-27303: additional information: startup egid = 501 (oinstall), current egid =

 500 (dba)

Sql>startup nomount;

ORA-01078: failure in processing system parameters

ORA-01565: error in identifying file '+ORA_DATA/MIOA/spfileMIOA.ora'

ORA-17503: ksfdopn:2 Failed to open file +ORA_DATA/MIOA/spfileMIOA.ora

ORA-27140: attach to post/wait facility failed

ORA-27300: OS system dependent operation:invalid_egid failed with status: 1

ORA-27301: OS failure message: Operation not permitted

ORA-27302: failure occurred at: skgpwinit6

ORA-27303: additional information: startup egid = 501 (oinstall), current egid =

 500 (dba)

chmod 6775 $ORACLE_HOME/bin/oracle

chown oracle:oinstall $ORACLE_HOME/bin/oracle

解決方法：

是oracle許可權造成的

檢視$ORACLE_HOME中oracle的許可權

[oracle@etsdb05 ~]$ ls -ltr /orahome/11.2/db_1/bin/oracle
-r-xr-xr-x 1 oracle oinstall 210824688 Sep 21 09:53 /orahome/11.2/db_1/bin/oracle

[oracle@etsdb05 ~]$ chmod 6751 /orahome/11.2/db_1/bin/oracle

[oracle@etsdb05 ~]$ ls -ltr /orahome/11.2/db_1/bin/oracle
-rwsr-s--x 1 oracle oinstall 210824688 Sep 21 09:53 /orahome/11.2/db_1/bin/oracle
[oracle@etsdb05 ~]$ srvctl start instance -d MIOA -i MIOA1
PRCR-1013 : Failed to start resource ora.mioa.db
PRCR-1064 : Failed to start resource ora.mioa.db on node etsdb05
ORA-01078: failure in processing system parameters
CRS-2674: Start of 'ora.mioa.db' on 'etsdb05' failed

[oracle@etsdb05 ~]$ ls -ltr /orahome/11.2/db_1/bin/oracle
-r-sr-s--x 1 oracle dba 210824688 Sep 21 09:53 /orahome/11.2/db_1/bin/oracle

檢視$ORACLE_GRID/bin/oracle的許可權
[oracle@etsdb05 ~]$ ls -ltr /orahome/grid/bin/oracle
-rwxrwxr-x 1 oracle oinstall 184286219 Nov  1 17:16 /orahome/grid/bin/oracle

[oracle@etsdb05 ~]$ chmod 6755 /orahome/grid/bin/oracle

[oracle@etsdb05 ~]$ ls -ltr /orahome/grid/bin/oracle
-rwsr-sr-x 1 oracle oinstall 184286219 Nov  1 17:16 /orahome/grid/bin/oracle

[oracle@etsdb05 ~]$ srvctl  start  instance -d MIOA –I MIOA1  正常

 這次主要還是$ORACLE_GRID/bin/oracle 同$ORACLE_HOME/bin/oracle的許可權被更改