RAC Database Is Not Starting Up on either node
(Doc ID 2350320.1)
Last updated on FEBRUARY 21, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1.0 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Cannot start either instance of the database.
Instance 1 startup repeatedly fails with:
Sat Jan 13 14:16:36 2018
IPC Send timeout to 2.0 inc 3 for msg type 16 from opid 276
Sat Jan 13 14:16:36 2018
IPC Send timeout: Terminating pid 276 osid 117715
Sat Jan 13 14:16:41 2018
LMS0 (ospid: 68628) has detected no messaging activity from instance 2
LMS0 (ospid: 68628) issues an IMR to resolve the situation
Please check LMS0 trace file for more detail.
Instance 2 startup fails with:
srvctl start instance -d <DB_NAME> -i <DB_NAME>2
PRCR-1013 : Failed to start resource ora.<DB_NAME>.db
PRCR-1064 : Failed to start resource ora.<DB_NAME>.db on node <NODE_NAME1>
CRS-5017: The resource action "ora.<DB_NAME>.db start" encountered the following error:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3651
Additional information: 1217484423
Process ID: 0
Session ID: 0 Serial number: 0
. For details refer to "(:CLSN00107:)" in "<ORACLE_BASE>/diag/crs/<NODE_NAME1>/crs/trace/crsd_oraagent_oracle.trc".
Trying to start instance 2 via SQLPlUS also fails:
SQL> startup nomount;
ORA-00304: requested INSTANCE_NUMBER is busy
Changes
A session in <DB_NAME>2 was killed that was locking a package that needed to be recompiled. This session is marked as killed but has not terminated.
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 |