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的权限被更改
SRVCTL Fails to Start Instance with ORA-17503 ORA-27303 But sqlplus Startup is Fine [ID 1322959.1] | |||||
| |||||
修改时间 23-JAN-2012 类型 PROBLEM 状态 PUBLISHED |
In this Document
Symptoms
Cause
Solution
References
Applies to:
Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later [Release: 11.2 and later ]Information in this document applies to any platform.
Symptoms
RAC Instance can be started using sqlplus but fails when using srvctl:Case I:
PRCR-1079 : Failed to start resource ora.cad.db
CRS-5017: The resource action "ora.cad.db start" encountered the following error:
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+RAC/cad/spfilecad.ora'
ORA-17503: ksfdopn:2 Failed to open file +RAC/cad/spfilecad.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 = 1002 (oinstall), current egid = 1001 (dba)
CRS-2674: Start of 'ora.cad.db' on 'racnode2' failed
CRS-2632: There are no more servers to try to place resource 'ora.cad.db' on that would satisfy its placement policy
Case II
PRCR-1079 : Failed to start resource ora.nar.db
CRS-5017: The resource action "ora.nar.db start" encountered the following error:
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+NAR_DG/nar/spfilenar.ora'
ORA-17503: ksfdopn:2 Failed to open file +NAR_DG/nar/spfilenar.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 = 59800 (oinstall), current egid = 59802 (asmadmin)
. For details refer to "(:CLSN00107:)" in "/oracle/GRID/11203/log/dog1104/agent/crsd/oraagent_oracle/oraagent_oracle.log".
CRS-2674: Start of 'ora.nar.db' on 'racnode1' failed
Cause
For Case I, the issue is caused wrong group (dba) is chosen for "ASM Database Administrator","ASM Instance Administration Operator" and "ASM Instance Administrator"group during installing grid infrastructure, while the ASM disks are owned by oinstall group.
This same issue is documented in
Bug 9786198 - SRVCTL START DATABASE ORA-0178 FAILURE IN PROCESSING SYSTEM PARAMETERS
For Case II, the issue is caused by setuid and setgid bit missing for oracle binary under GRID_HOME, eg:
-rwxr-x--x oracle oinstall 166648778 Dec 7 15:26 oracle
Solution
For case I,Either reinstall Grid Infrastructure, select correct group for ASM Instance Administrator - ASMADMIN (oinstall in this case which is the ASM disk owning group)
or
stop srvctl modify oracle binary group from oinstall to dba by renaming $GRID_HOME/bin/setasmgid to $GRID_HOME/bin/setasmgid.orig. Restore the group ownership of oracle binary to oinstall and startup instance using srvctl.
For case II,
Add setuid and setgid bit for oracle binary under $GRID_HOME/bin:
The oracle binary for both GRID_HOME/bin and RDBMS ORACLE_HOME/bin should have 6755 permission, eg: -rwsr-s--x
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24849178/viewspace-750074/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24849178/viewspace-750074/