My Oracle Support Banner

RAC Database Is Not Starting Up on either node (Doc ID 2350320.1)

Last updated on AUGUST 04, 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

To view full details, 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 a vibrant support community of peers and Oracle experts.