My Oracle Support Banner

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 later
Information 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


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