SRVCTL Fails to Start Instance with ORA-17503 ORA-27303 But sqlplus Startup is Fine
(Doc ID 1322959.1)
Last updated on MAY 08, 2023
Applies to:
Oracle Database Cloud Exadata Service - Version N/A and laterOracle Database Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A 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:
$ srvctl start database -d <RAC>
PRCR-1079 : Failed to start resource ora.<RAC>.db
CRS-5017: The resource action "ora.<RAC>.db start" encountered the following error:
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/<RAC>/spfile<RAC>.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/cad/spfile<RAC>.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.<RAC>.db' on '<HOSTNAME1>' failed
CRS-2632: There are no more servers to try to place resource 'ora.<RAC>.db' on that would satisfy its placement policy
PRCR-1079 : Failed to start resource ora.<RAC>.db
CRS-5017: The resource action "ora.<RAC>.db start" encountered the following error:
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/<RAC>/spfile<RAC>.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/cad/spfile<RAC>.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.<RAC>.db' on '<HOSTNAME1>' failed
CRS-2632: There are no more servers to try to place resource 'ora.<RAC>.db' on that would satisfy its placement policy
Case II
$ srvctl start database -d <RAC>
PRCR-1079 : Failed to start resource ora.<RAC>.db
CRS-5017: The resource action "ora.<RAC>.db start" encountered the following error:
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/<RAC>/spfile<RAC>.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/nar/spfile<RAC>.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/<HOSTNAME1>/agent/crsd/oraagent_oracle/oraagent_oracle.log".
CRS-2674: Start of 'ora.<RAC>.db' on '<HOSTNAME1>' failed
PRCR-1079 : Failed to start resource ora.<RAC>.db
CRS-5017: The resource action "ora.<RAC>.db start" encountered the following error:
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/<RAC>/spfile<RAC>.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/nar/spfile<RAC>.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/<HOSTNAME1>/agent/crsd/oraagent_oracle/oraagent_oracle.log".
CRS-2674: Start of 'ora.<RAC>.db' on '<HOSTNAME1>' failed
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |