Instance Crashed Due to ORA-00600 [KGLUNLOCK-BAD-LOCK]
(Doc ID 2623876.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
The error ORA-00600: internal error code, arguments: [kglUnLock-bad-lock], is seen in alert log file.
----- Current SQL Statement for this session (sql_id=dhuw5nx7k4208) -----
BEGIN
dbms_dst.unload_secondary();
END;
[TOC00005]
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x2b7986b630 2 anonymous block
[TOC00005-END]
[TOC00004-END]
Call Stack Trace -----
kglLockHandle <- kgifnd <- kgiind <- pfri8_inst_spec <- pfri1_inst_spec <- pfrrun
<- plsql_run <- peicnt <- kkxexe <- opiexe <- kpoal8 <- opiodr <- kpoodrc <- rpiswu2 <- kpoodr
<- upirtrc <- kpurcsc <- kpuexec <- OCIStmtExecute <- kuppclnsec <- kuppmsode <- kss_del_cb
<- kssxdl <- kssdel <- kssdch_int <- ksudlp <- kss_del_cb <- kssxdl <- kssdel <- ksuxdl
<- ksucln_dpc_cleanup <- ksucln_dpc_dfs <- ksucln_dpc_main <- ksucln_clean_main
<- ksbrdp <- opirip <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main
--- Session Open Cursors -----
----------------------------------------
[TOC00039]
Cursor#2 state=BOUND curiob=0x7f78c2b60b70
curflg=0x45 fl2=0x8200000 fl3=0x0 par=(nil) ses=0x321336e78
[TOC00040]
----- Dump Cursor sql_id=dhuw5nx7k4208 xsc=0x7f78c2b60b70 cur=0x7f78c3362600 -----
LibraryHandle: Hash=4f220808 LockMode=N PinMode=0 LoadLockMode=0 Status=VALD
ObjectName: Name=BEGIN
dbms_dst.unload_secondary();
END;
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 |
Cause |
Solution |