My Oracle Support Banner

Data Pump Job Fails with UDI-31623 ORA-31623 ORA-06512 and the Alert Log Shows ORA-600[ktbdchk1: bad dscn] Errors (Doc ID 2644355.1)

Last updated on MARCH 04, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.2.0.1 [Release 11.2 to 12.2]
Information in this document applies to any platform.

Symptoms

Data Pump Export (expdp) / Import (impdp) fails with the following errors:

UDI-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3326
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551
ORA-06512: at line 1

with the following associated error in the alert log:

ORA-00600: internal error code, arguments: [ktbdchk1: bad dscn], [], [], [], [], [], [], [], [], [], [], []

 

The Call Stack Trace in the associated incident trace file shows:

ktbValidateDependentScn <- ktbgcl1 <- kdisnew <- kdisnewle <- kdisle <- kdiins0
 <- kdiinsp <- kauxsin <- qesltcLoadIndexList <- qesltcLoadIndexes
  <- qerltcNoKdtBufferedInsRowCBK <- qerltcSingleRowLoad <- qerltcFetch <- insexe
   <- opiexe <- opiall0 <- opikpr <- opiodr <- rpidrus <- skgmstack <- rpiswu2 <- kprball <- kqldcou
    <- kglswrt <- kglsfls <- kqlsfls <- ctcfs_flush_subsets <- ctcdrv <- opiexe <- opiosq0
     <- opipls <- opiodr <- rpidrus <- skgmstack <- rpiswu2 <- rpidrv <- psddr0 <- psdnal <- pevm_EXIM
      <- pfrinstr_EXIM <- pfrrun_no_tool

 

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
References


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