LCK0 (ospid: 24887) waits for latch 'channel operations parent latch' for 96 secs. (Doc ID 2220618.1)

Last updated on JANUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Instance crashes with the following in alert.log

Mon Aug 29 14:05:13 2016
LCK0 (ospid: 24887) waits for latch 'channel operations parent latch' for 96 secs.
Errors in file /u01/app/oracle/global/diag/rdbms/pouk5das/POUK5DAS6/trace/POUK5DAS6_lmhb_24780.trc (incident=592304):
ORA-29770: global enqueue process LCK0 (OSID 24887) is hung for more than 70 seconds
Incident details in: /u01/app/oracle/global/diag/rdbms/pouk5das/POUK5DAS6/incident/incdir_592304/POUK5DAS6_lmhb_24780_i592304.trc
ERROR: Some process(s) is not making progress.
LMHB (ospid: 24780) is terminating the instance.
Please check LMHB trace file for more details.
Please also check the CPU load, I/O load and other system properties for anomalous behavior
ERROR: Some process(s) is not making progress.
LMHB (ospid: 24780): terminating the instance due to error 29770

 

LCK0 call stack

ksl_get_shared_latch ksrconsume ksxrconsume_one ksxrrcvreply ksxrpollremote

 

LMHB trace

LCK0 (ospid: 24887) waits for latch 'channel operations parent latch'.
PMON (ospid: 24710) is not waiting for any latch.
===[ Process State in Latch Chain ]===
Process LCK0 (ospid: 24887): latch state and session wait history
..............
150 (4, 1472479513, 1)
148 (3, 1472479513, 3)
waiter count=37
gotten 1058909774 times wait, failed first 13338042 sleeps 6764419
gotten 49 times nowait, failed: 25036
possible holder pid = 2 ospid=24710 <--------------------------------------- PMON holds latch

*** 2016-08-29 14:05:13.925
Process diagnostic dump for oracle@uklpdpdas06a (PMON), OS id=24710,
pid: 2, proc_ser: 1, sid: 473, sess_ser: 1
-------------------------------------------------------------------------------
os thread scheduling delay history: (sampling every 1.000000 secs)
0.000000 secs at [ 14:05:12 ]
NOTE: scheduling delay has not been sampled for 0.990860 secs 0.000000 secs from [ 14:05:09 - 14:05:13 ], 5 sec avg
0.000000 secs from [ 14:04:14 - 14:05:13 ], 1 min avg
0.000000 secs from [ 14:00:14 - 14:05:13 ], 5 min avg
loadavg : 4.53 4.56 4.75
Memory (Avail / Total) = 261467.83M / 775371.43M
Swap (Avail / Total) = 16415.99M / 16415.99M
F S UID PID PPID C PRI NI ADDR SZ WCHAN STIME TTY TIME CMD
0 R oracle 24710 1 0 80 0 - 64517 ? Jul02 ? 01:18:16 ora_pmon_POUK5DAS6
Short stack dump:
ksedsts()+465<-ksdxfstk()+32<-ksdxcb()+1927<-sspuser()+112<-__sighandler()<-ksrchdelete_pub()+1108<-ksrchdelete()+410<-kssxdl()+489<-kssdel()+644<-kssdch()+6849<-ksudlp()+283<-kssxdl()+489<-kssdel()+644<-ksuxdl()+398<-ksuxda_del_proc()+166<-ksucln_dpc_cleanup()+259<-ksucln_dpc_dfs()+248<-ksucln_dpc_main()+1188<-ksucln_dpc()+29<-ksucln()+1250<-ksbrdp()+1045<-opirip()+623<-opidrv()+603<-sou2o()+103<-opimai_real()+250<-ssthrdmain()+265<-main()+201<-__libc_start_main()+253

 

 

 

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