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 JANUARY 16, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation 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
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:
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 |