Database instance Crashes with ORA-29770 (Doc ID 2292690.1)

Last updated on AUGUST 07, 2017

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

Alert logs shows

Mon Feb 02 18:49:51 2015
LMS5 (ospid: 82744) has not called a wait for 1 secs.
Errors in file
/u01/akshukla/gehc/log/diag/rdbms/gehc/node1/trace/node1_lmhb_82758.trc
(incident=147081):
ORA-29770: global enqueue process LMS5 (OSID 82744) is hung for more than 70
seconds
Incident details in:
/u01/akshukla/gehc/log/diag/rdbms/gehc/node1/incident/incdir_147081/node1_lm
hb_82758_i147081.trc
ERROR: Some process(s) is not making progress.
LMHB (ospid: 82758) 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: 82758): terminating the instance due to error 29770
Mon Feb 02 19:49:52 2015
System state dump requested by (instance=1, osid=82758 (LMHB)),
summary=[abnormal instance termination].
System State dumped to trace file
/u01/akshukla/gehc/log/diag/rdbms/gehc/node1/trace/node1_diag_82671_20150222
194952.trc
Mon Feb 02 19:49:59 2015
Instance terminated by LMHB, pid = 82758
Mon Feb 02 19:58:07 2015
-------------------------------------------
Sun Feb 23 07:41:02 2015
LMS0 (ospid: 107472) has not called a wait for 3 secs.
LMS1 (ospid: 107476) has not called a wait for 21 secs.
Errors in file
/u01/akshukla/gehc/log/diag/rdbms/gehc/node2/trace/node2_lmhb_107512.trc
(incident=201):
ORA-29770: global enqueue process LMS0 (OSID 107472) is hung for more than 70
seconds
Incident details in:
/u01/akshukla/gehc/log/diag/rdbms/gehc/node2/incident/incdir_201/node2_lmhb_
107512_i201.trc
Errors in file
/u01/akshukla/gehc/log/diag/rdbms/gehc/node2/trace/node2_lmhb_107512.trc
(incident=202):
ORA-29770: global enqueue process LMS1 (OSID 107476) is hung for more than 70
seconds
Incident details in:
/u01/akshukla/gehc/log/diag/rdbms/gehc/node2/incident/incdir_202/node2_lmhb_
107512_i202.trc
Sun Feb 23 07:41:06 2015
Sweep [inc][202]: completed
Sweep [inc][201]: completed
Sweep [inc2][201]: completed
ERROR: Some process(s) is not making progress.
LMHB (ospid: 107512) 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: 107512): terminating the instance due to error 29770
Sun Feb 23 07:41:07 2015
System state dump requested by (instance=2, osid=107512 (LMHB)),
summary=[abnormal instance termination].
System State dumped to trace file
/u01/akshukla/gehc/log/diag/rdbms/gehc/node2/trace/node2_diag_107425_2015022
3074107.trc
--------------------------------------------
Short stack:
Short stack dump:
ksedsts()+244<-ksdxfstk()+58<-ksdxcb()+918<-sspuser()+224<-__sighandler()<-wri
te()+16<-sdbgrfwf_write_file()+64<-dbgtfdFileWrite()+632<-dbgtfdFileAccessCbk(
)+360<-dbgtfPutStr()+595<-dbktPri()+149<-ksdwrf()+559<-ksdwrfn()+187<-kcldlei(
)+907<-kcldle()+29<-kcbw_dump_granule_les()+114<-kmgsdpgl()+106<-kmgsdpg()+66<
-kclexpand()+723<-kclexpandlock()+2996<-kjbmpocr()+25125<-kjmxmpm()+864<-kjmpb
msg()+6271<-kjmsm()+19618<-ksbrdp()+1072<-opirip()+1462<-opidrv()+622<-sou2o()
+145<-opimai_real()+270<-ssthrdmain()+412<-main()+236<-__libc_start_main()+244

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