ORA-29770 Error On LMS Process Which Is Hanging And Terminates The Instance With ORA-04031
Last updated on MAY 23, 2017
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
The following error(s) occurred in the alert log and Instance is terminated.
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_
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
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