My Oracle Support Banner

Datapump Import fails with ORA-39014 ORA-39029 ORA-31671 ORA-29913 ORA-00600 [klxpr_03] and ORA-06512 Errors (Doc ID 2433173.1)

Last updated on JULY 30, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

1.  After the Datapump export has been completed without any issue the import fails with the following errors:

;;;
Import: Release 12.1.0.2.0 - Production on Tue Jul 31 15:12:36 2018

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01": "/<PASSWORD> AS SYSDBA" content=data_only table_exists_action=append DIRECTORY=my_dir DUMPFILE=expdp.dmp LOGFILE=impdp.log parallel=1
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-00600: internal error code, arguments: [klxpr_03], [1], [66777], [0], [3], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SQL", line 1707
ORA-06512: at "SYS.KUPD$DATA", line 2495
ORA-06512: at "SYS.KUPD$DATA", line 3503
ORA-06512: at "SYS.KUPD$DATA", line 3764
ORA-06512: at "SYS.KUPW$WORKER", line 19307
ORA-06512: at "SYS.KUPW$WORKER", line 4989
ORA-06512: at "SYS.KUPW$WORKER", line 12077
ORA-06512: at "SYS.KUPW$WORKER", line 2081
ORA-06512: at line 2
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 2 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-00600: internal error code, arguments: [klxpr_03], [1], [66777], [0], [3], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SQL", line 1707
ORA-06512: at "SYS.KUPD$DATA", line 2495
ORA-06512: at "SYS.KUPD$DATA", line 3503
ORA-06512: at "SYS.KUPD$DATA", line 3764
ORA-06512: at "SYS.KUPW$WORKER", line 19307
ORA-06512: at "SYS.KUPW$WORKER", line 4989
ORA-06512: at "SYS.KUPW$WORKER", line 12077
ORA-06512: at "SYS.KUPW$WORKER", line 2081
ORA-06512: at line 2
Job "SYS"."SYS_IMPORT_FULL_01" stopped due to fatal error at Tue Jul 31 15:31:39 2018 elapsed 0 00:19:02

2.  The alert log might have the following errors

DW00 started with pid=62, OS id=122171, wid=2, job SYSTEM.SYS_IMPORT_FULL_03
Errors in file /<$ORACLE_BASE>/diag/rdbms/<sid>/<dbname>/trace/orcl_dw02_121209.trc (incident=35750):
ORA-00600: internal error code, arguments: [klxpr_03], [1], [66777], [0], [3], [], [], [], [], [], [], []
Incident details in: /<$ORACLE_BASE>/diag/rdbms/<sid>/<dbname>/incident/incdir_35750/orcl_dw02_121209_i35750.trc

3.  The failing functions and the call stack is similar to the following:

..... klxprParseRow qerxtProcessRows qerxtCBFetch kpxsFastFetchStreamDriver
           kpxsFetchStream kpxsFetch qxxqFetchspefcpfa spefmccallstd pextproc pgmcetc_execute_trusted_c
              pgmccc_call_c pciccc_call_c kkxmcexe kgmexcb kkxmswu kgmexwi kgmexec evapls evaopn2 qximeop_fbk
                   qximeop qxxmeop qerxtFetch rwsfcd qerltFetch insdlexe insExecStmtExecIniEngine

 

Changes

 

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.