Database Startup Fails With ORA-15077,ORA-29701 as it Can not Access Grid Infrastructure Home
(Doc ID 2044489.1)
Last updated on JULY 30, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Database fails to start while ASM is up and running:
$ asmcmd -p
ASMCMD [+] > lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 4194304 163832 140592 0 140592 0 N DATA_T1/
MOUNTED EXTERN N 512 4096 4194304 40956 37220 0 37220 0 N RECO_T1/
ASMCMD [+] > lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 4194304 163832 140592 0 140592 0 N DATA_T1/
MOUNTED EXTERN N 512 4096 4194304 40956 37220 0 37220 0 N RECO_T1/
sqlplus output
Redo Buffers 139759616 bytes
ORA-00205: error in identifying control file, check alert log for more info
ORA-00205: error in identifying control file, check alert log for more info
alert.log
Fri Aug 14 21:34:12 2015
ASMB started with pid=16, OS id=14948
Errors in file /u01/app/oracle/diag/rdbms/<database>/<database>/trace/<database>_asmb_14948.trc:
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Synchronization Service
Fri Aug 14 21:34:12 2015
MMON started with pid=17, OS id=14952
Fri Aug 14 21:34:12 2015
MMNL started with pid=16, OS id=14956
ORACLE_BASE from environment = /u01/app/oracle
Fri Aug 14 21:34:12 2015
ALTER DATABASE MOUNT
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+RECO_T1/<database>/controlfile/current.257.886653187'
ORA-17503: ksfdopn:2 Failed to open file +RECO_T1/<database>/controlfile/current.257.886653187
ORA-15001: diskgroup "RECO_T1" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Synchronization Service
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+DATA_T1/<database>/controlfile/current.256.886653187'
ORA-17503: ksfdopn:2 Failed to open file +DATA_T1/<database>/controlfile/current.256.886653187
ORA-15001: diskgroup "DATA_T1" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Synchronization Service
ORA-205 signalled during: ALTER DATABASE MOUNT...
ASMB started with pid=16, OS id=14948
Errors in file /u01/app/oracle/diag/rdbms/<database>/<database>/trace/<database>_asmb_14948.trc:
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Synchronization Service
Fri Aug 14 21:34:12 2015
MMON started with pid=17, OS id=14952
Fri Aug 14 21:34:12 2015
MMNL started with pid=16, OS id=14956
ORACLE_BASE from environment = /u01/app/oracle
Fri Aug 14 21:34:12 2015
ALTER DATABASE MOUNT
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+RECO_T1/<database>/controlfile/current.257.886653187'
ORA-17503: ksfdopn:2 Failed to open file +RECO_T1/<database>/controlfile/current.257.886653187
ORA-15001: diskgroup "RECO_T1" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Synchronization Service
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+DATA_T1/<database>/controlfile/current.256.886653187'
ORA-17503: ksfdopn:2 Failed to open file +DATA_T1/<database>/controlfile/current.256.886653187
ORA-15001: diskgroup "DATA_T1" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Synchronization Service
ORA-205 signalled during: ALTER DATABASE MOUNT...
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 |
Cause |
Solution |