ORA-15083 :: Database startup failure (Doc ID 1644559.1)

Last updated on APRIL 07, 2014

Applies to:

Enterprise Manager for Oracle Database - Version 10.2.0.4 to 11.2.0.2 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

 Database is using ASM as storage and there are mulitple databases running on top of it.

While starting up one of the database failed with below issue,

 

Sun Apr 06 02:26:38 2014
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /oracle/diag/rdbms/pdipre/PDIPRE/trace/PDIPRE_asmb_177008.trc:
ORA-15064: communication failure with ASM instance
ORA-00600: internal error code, arguments: [ORA_NPI_ERROR], [600], [ORA-00600: internal error code, arguments: [kfnsInstanceReg00], [PDIPRE:PDIPRE], [30000], [], [], [], [], [],
[], [], [], []
], [], [], [], [], [], [], [], [], []
Errors in file /oracle/diag/rdbms/pdipre/PDIPRE/trace/PDIPRE_ckpt_176982.trc:
ORA-15083: failed to communicate with ASMB background process
CKPT (ospid: 176982): terminating the instance due to error 15083
Sun Apr 06 02:26:39 2014
System state dump requested by (instance=1, osid=176982 (CKPT)), summary=[abnormal instance termination].
System State dumped to trace file /oracle/diag/rdbms/pdipre/PDIPRE/trace/PDIPRE_diag_176922.trc
Sun Apr 06 02:26:39 2014
ORA-1092 : opitsk aborting process
Sun Apr 06 02:26:40 2014
License high water mark = 1
Dumping diagnostic data in directory=[cdmp_20140406022639], requested by (instance=1, osid=176982 (CKPT)), summary=[abnormal instance termination].
Instance terminated by CKPT, pid = 176982
USER (ospid: 185557): terminating the instance

 

From CKPT trace file,

 

*** ACTION NAME:() 2014-04-06 02:26:35.972

15083: Timeout waiting for ASMB to be ready (state=1)
 ASMB is ALIVE
----- Abridged Call Stack Trace -----
ksedsts()+461<-kfnUWait()+1261<-kfnUStart()+2818<-kfncGroupUse()+490<-kfgCreate()+1198<-kfgUse()+1355<-kfioIdentify()+1484<-ksfd_osmopn()+983<-ksfdopn1()+3036<-ksfdopn()+217<-kcc_identify_file()+123<-kcc_identify()+230<-kccida()+230<-ksbabs()+771<-ksbrdp()+971
<-opirip()+623<-opidrv()+603<-sou2o()+103<-opimai_real()+266<-ssthrdmain()+252<-main()+201<-__libc_start_main()+244<-_start()+36
----- End of Abridged Call Stack Trace -----

 

CKPT was blocking as it was waiting for ASMB to startup .

 

   There are 1 sessions blocked by this session.
   Dumping one waiter:
     inst: 1, sid: 599, ser: 1
     wait event: 'rdbms ipc reply'
       p1: 'from_process'=0x11
       p2: 'timeout'=0x258
       p3: ''=0x0
     row_wait_obj#: 4294967295, block#: 0, row#: 0, file# 0
     min_blocked_time: 0 secs, waiter_cache_ver: 99
   Wait State:
     fixed_waits=0 flags=0x23 boundary=(nil)/-1
   Session Wait History:
       elapsed time of 0.000000 sec since current wait

     [4 samples,                                          02:24:37 - 02:24:40]
       waited for 'ASM background starting', seq_num: 100
         p1: ''=0x0
         p2: ''=0x0
         p3: ''=0x0
         time_waited: 5.000691 sec (sample interval: 3 sec)
   ---------------------------------------------------
   Sampled Session History Summary:
     longest_non_idle_wait: 'ASM background starting'
     [5 samples, 02:24:56 - 02:25:00]
         time_waited: 5.002147 sec (sample interval: 4 sec)
   ---------------------------------------------------

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