RAC: Second Instance Fails to Start With Error ORA-1102
(Doc ID 1579765.1)
Last updated on JUNE 18, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
Second RAC instance fails to start with error ORA-1102
- srvctl start output
srvctl start database -d <DB_NAME> -o mount
PRCR-1079 : Failed to start resource ora.<DB_NAME>.db
CRS-5017: The resource action "ora.<DB_NAME>.db start" encountered the following error:
ORA-01102: cannot mount database in EXCLUSIVE mode
. For details refer to "(:CLSN00107:)" in "<GRID_HOME>/log/<HOSTNAME>/agent/crsd/oraagent_oracle/oraagent_oracle.log".
CRS-2674: Start of 'ora.<DB_NAME>.db' on '<HOSTNAME>' failed
CRS-2632: There are no more servers to try to place resource 'ora.<DB_NAME>.db' on that would satisfy its placement policy
- sqlplus startup output
Connected to an idle instance.
SQL> startup mount
ORA-01102: cannot mount database in EXCLUSIVE mode
- instance alert.log
....
....
Fri Aug 23 18:09:31 2013
MARK started with pid=44, OS id=19025
NOTE: MARK has subscribed
USER (ospid: 18692): terminating the instance due to error 1102
Instance terminated by USER, pid = 18692
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 |