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

Last updated on MAY 23, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

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 /u01/app/oracle/diag/rdbms/p1amex/p1amex1/trace/p1amex1_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: /u01/app/oracle/diag/rdbms/p1amex/p1amex1/incident/incdir_794155/p1amex1_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 /u01/app/oracle/diag/rdbms/p1amex/p1amex1/trace/p1amex1_lmhb_3695.trc  (incident=793858):
ORA-29770: global enqueue process LMS1 (OSID 3689) is hung for more than 70 seconds
Incident details in: /u01/app/oracle/diag/rdbms/p1amex/p1amex1/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

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