RAC Database Is Not Starting Up on either node

(Doc ID 2350320.1)

Last updated on FEBRUARY 05, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1.0 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 PROD -i PROD2

PRCR-1013 : Failed to start resource ora.prod.db
PRCR-1064 : Failed to start resource ora.prod.db on node production2
CRS-5017: The resource action "ora.prod.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 "/u01/app/oracle/diag/crs/production2/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 PROD2 was killed that was locking a package that needed to be recompiled. This session is marked as killed but has not terminated.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms