My Oracle Support Banner

ORA-29770 Error On LMS Process Which Is Hanging And Terminates The Instance With ORA-04031 (Doc ID 2114608.1)

Last updated on FEBRUARY 18, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.


The following error(s) occurred in the alert log and Instance is terminated.

  What :
  Errors are seen including :

LMS0 (ospid: 3685) waits for event 'latch: redo allocation' for 0 secs.
LMS0 (ospid: 3685) waits for latch 'redo allocation' for 0 secs.
Errors in file /<diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<sid>_ctwr_5160.trc  (incident=794155):
ORA-04031: unable to allocate 253542496 bytes of shared memory ("large pool","unknown object","large pool","CTWR dba buffer")
Incident details in: /<diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_794155/<sid>_ctwr_5160_i794155.trc

USER (ospid: 16180) is blocking LMS0 (ospid: 3685) in a wait
LMHB (ospid: 3695) kills USER (ospid: 16180).
Please check LMHB trace file for more detail.
Errors in file /<diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<sid>_lmhb_3695.trc  (incident=793858):
ORA-29770: global enqueue process LMS1 (OSID 3689) is hung for more than 70 seconds
Incident details in: /<diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_

  Call Stack:

skdstdst ksedst ksm_4031_dump ksmasg
kghnospc kghalo ksmc_large_pool_all krcpasb oc krcprsz krcpact ksbabs krcpabs ksbrdp opirip
opidrv sou2o opimai_real ssthrdmain main libc_start_main


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.