After mmon ORA-12751, repeated msg: ORA-38701 ORA-17503 ORA-15064: communication failure with ASM instance (Doc ID 2160369.1)

Last updated on NOVEMBER 02, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms


12.1.0.2 ASM, after the following error:

Wed May 11 08:10:16 2016
NOTE: Deferred communication with ASM instance
NOTE: deferred map free for map id 57075
Wed May 11 08:10:16 2016
Errors in file /u01/app/oracle/diag/rdbms/ex01cdb/EX01CDB4/trace/EX01CDB4_mmon_55739.trc:
ORA-12751: cpu time or run time policy violation
Wed May 11 08:10:57 2016
NOTE: Deferred communication with ASM instance
NOTE: deferred map free for map id 57379
NOTE: deferred map free for map id 57065

Every 30 minutes the following is printed in database alert.log:

Wed May 11 08:35:20 2016
Errors in file /u01/app/oracle/diag/rdbms/ex01cdb/EX01CDB4/trace/EX01CDB4_mmon_55739.trc:
ORA-38701: Flashback database log 12 seq 105 thread 3: "+RECO2_EX01/EX01CDB/FLASHBACK/log_12.3891.906796805"
ORA-17503: ksfdopn:2 Failed to open file +RECO2_EX01/EX01CDB/FLASHBACK/log_12.3891.906796805
ORA-15064: communication failure with ASM instance

OR

NOTE: deferred map free for map id 682884
ORA-01565: Unable to open Spfile +DATA/geagttq/spfilegeagttq.ora.

OR

Errors in file /u01/app/oracle/diag/rdbms/sodsp_env1/sodsp1/trace/sodsp1_mmon_19993.trc:
ORA-01565: error in identifying file '+DATA_1/SODSP_ENV1/PARAMETERFILE/spfile.538.918298083'
ORA-17503: ksfdopn:10 Failed to open file +DATA_1/SODSP_ENV1/PARAMETERFILE/spfile.538.918298083
ORA-15064: communication failure with ASM instance : communication failure with ASM instance

mmon trace:

Runtime exceeded 300 seconds
Time limit violation detected at:
ksedsts()+244<-kspol_12751_dump()+170<-dbgdaExecuteAction()+358<-dbgerRunAction()+108<-dbgerRunActions()+3600<-dbgexPhaseII()+2022<-dbgexProcessError()+2539 <-dbgeExecuteForError()+110<-dbgePostErrorKGE()+1868<-dbkePostKGE_kgsf()+90<-kgeselv()+409<-ksesecl0()+185 <-ksvcheckwait()+795<-ksvsend()+1431<-kfncSlaveSendReal()+922<-kfncSlaveSubmitSlv()+1717<-kfncSlaveSend()+340<-kfncReleaseSlave()+573<-kfnsoReleaseSlave()+1127<-kfnsoDelete()+1677<-kss_del_cb()+257<-kssdel()+239<-kfnReleaseASM()+778<-kccecx()+398<-krfr_get_nab()+962 <-krfbMarkerPointsInLog()+937<-krf_get_max_fb_time()+1727<-krfg_rf_min_fbscn()+536<-krfg_bar_act()+1224<- ksb_run_managed_action()+389<-ksbcti()+1494<-ksbabs()+2357<-kebm_mmon_main()+229<-ksbrdp()+1068<-opirip()+1488<-opidrv()+616<-sou2o()+145<-opimai_real()+270 <-ssthrdmain()+412<-main()+236<-__libc_start_main()+253

Current Wait Stack:
0: waiting for 'KSV master wait'
indicator=0x9, =0x0, =0x0
wait_id=7729836 seq_num=10520 snap_id=1
wait times: snap=0.041261 sec, exc=0.041261 sec, total=0.041261 sec
wait times: max=infinite, heur=0.041261 sec
wait counts: calls=1 os=1
in_wait=1 iflags=0x55a2
Wait State:
fixed_waits=0 flags=0x22 boundary=(nil)/-1

*** 2016-05-11 08:31:28.645
2016-05-11 08:31:28.645114 :kfncSlaveSubmitSlv(): already in a kfnc call;failing op 42 [kfncReleaseSlave]
kssdmp: so address (nil) is not readable.

*** 2016-05-11 08:34:29.068
2016-05-11 08:34:29.068948 :kfncSlaveSubmitSlv(): already in a kfnc call;failing op 42 [kfncReleaseSlave]
kssdmp: so address (nil) is not readable.

*** 2016-05-11 08:35:20.224
2016-05-11 08:35:20.224147 :kfncSlaveSubmitSlv(): already in a kfnc call;failing op 17 [kfncFileIdentify]

 

 

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