Instance crashes as LMS0 (ospid: ) has not moved for nnn sec with huge trace after KCL: A59: no lock elements

(Doc ID 2119642.1)

Last updated on MARCH 20, 2018

Applies to:

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


Instance crashed with the error: LMON (ospid: 25741): terminating the instance due to error 481

LMS process was stuck with high waits for "buffer cache"

There was a big trace file generated by the LMS0 process.

Tue Jan 26 13:22:42 2016
LMON (ospid: 25741): terminating the instance due to error 481
Tue Jan 26 13:22:42 2016
System state dump requested by (instance=1, osid=25741 (LMON)),
summary=[abnormal instance termination].
System State dumped to trace file
Tue Jan 26 13:22:42 2016
opiodr aborting process unknown ospid (16876) as a result of ORA-1092
Tue Jan 26 13:22:47 2016
ORA-1092 : opitsk aborting process
Tue Jan 26 13:22:49 2016
Instance terminated by LMON, pid = 25741 <<<<<<<<

LMHB trace files
*** 2016-01-26 13:22:23.314
LMS0 (ospid: 25747) has not moved for 310 sec (1453843342.1453843032)

Short stack dump:


We see there are more buffers in the buffer cache, than lock elements in LMS trace file:

KCL: A59: no lock elements <<
cache size 57656
le locks 37043



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