Database Instance Down: NOTE: Deferred communication with ASM instance
926599Mar 27 2012 — edited Jul 18 2012Hi,
This morning, my database instance was down. I was able to start it back up with no problems but I need to find out why it came down. In the alert log I see the below entries. I have searched for this error but I cannot find anything that explains what happened and what I can do to prevent this from happening again.
Any help on this would be greatly appreciated. Thanks.
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
OS: Linux x86_64: CentOS release 5.6
alert_DB1.log
==============================================
ORA-01041: internal error. hostdef extension doesn't exist
ORA-03113: end-of-file on communication channel
Process ID:
Session ID: 2 Serial number: 5421
NOTE: deferred map free for map id 4151
Tue Mar 27 06:56:21 2012
NOTE: Deferred communication with ASM instance
Errors in file /opt/oracle/diag/rdbms/DB1/DB1/trace/DB1_w008_9715.trc:
ORA-01041: internal error. hostdef extension doesn't exist
ORA-03113: end-of-file on communication channel
Process ID:
Session ID: 10 Serial number: 10569
NOTE: deferred map free for map id 4150
Tue Mar 27 06:56:42 2012
NOTE: ASMB terminating
Errors in file /opt/oracle/diag/rdbms/DB1/DB1/trace/DB1_asmb_6804.trc:
ORA-15064: communication failure with ASM instance
ORA-03113: end-of-file on communication channel
==============================================
DB1_asmb_6804.trc
==============================================
*** 2012-03-27 06:56:42.596
NOTE: ASMB terminating
ORA-15064: communication failure with ASM instance
ORA-03113: end-of-file on communication channel
Process ID:
Session ID: 138 Serial number: 39
*** 2012-03-27 06:56:44.971
error 15064 detected in background process
ORA-15064: communication failure with ASM instance
ORA-03113: end-of-file on communication channel
Process ID:
Session ID: 138 Serial number: 39
kjzduptcctx: Notifying DIAG for crash event
----- Abridged Call Stack Trace -----
ksedsts()+461<-kjzdssdmp()+267<-kjzduptcctx()+232<-kjzdicrshnfy()+53<-ksuitm()+1325<-ksbrdp()+3344<-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 -----
*** 2012-03-27 06:57:33.955
ASMB (ospid: 6804): terminating the instance due to error 15064
*** 2012-03-27 06:57:39.229
ksuitm: waiting up to [5] seconds before killing DIAG(6764)
==============================================