My Oracle Support Banner

LMS Processes Failed With ORA-600 [Kclexpandlock_1] on Index Only table. (Doc ID 1178684.1)

Last updated on OCTOBER 01, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 10.2.0.4 [Release 10.2]
Information in this document applies to any platform.
NOTE: In the images and/or the document content below, the user information and data used represents fictitious data.
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Symptoms

This problem was observed on Oracle 10.2.0.4.3.
It occurred on a two node RAC database.

Following a platform migration one of two RAC instances failed with below error in the alert log:

...
ORA-00600: internal error code, arguments: [kclexpandlock_1], [449794], [], [], [], [], [], []
...
LMSu: terminating instance due to error 484
ORA-00484: LMS* process terminated with error
Termination issued to instance processes. Waiting for the processes to exit
Instance terminated by LMSu, pid = <PID>
...


The call stack in the trace file includes functions like:

... kcbassertb1 kclexpandlock kjbmpocr kjmxmpm kjmpmsgi kjmsm ksbrdp opirip opidrv sou2o opimai_real main


Referenced object 449794 is an index (PK_INDEX_NAME) and is an IOT object:

 

Changes

The error is more likely to occur after a lot of DML on IOT tables. It is also more likely after performing a shrink operation on IOT tables.

Cause

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
Symptoms
Changes
Cause
Solution
References


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