解决Oracle 数据泵的导出（expdp）失败， ORA-00600 [kotTrns:transient] ORA-39014 ORA-39029 ORA-31671 ORA-29913 错误

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 ： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com

适用于

oracle数据库-标准版-12.1.0.2和更高的版本

本文档使用于任何平台

症状

1、数据泵导出文件报下面错误：

. . exported “SYSTEM”.”SCHEDULER_JOB_ARGS” 0 KB 0 rows

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 ODCIEXTTABLEPOPULATE callout

ORA-00600: internal error code, arguments: [kotTrns:transient], [], [], [], [], [], [], [], [], [], [], []

2、警告日志文件和跟踪文件报下面的错误，并且在跟踪文件里可能会显示错误的SQL语句：

ORA-00600: internal error code, arguments: [kotTrns:transient], [], [], [], [], [], [], [], [], [], [], []

—– Current SQL Statement for this session (sql_id=7pgw6s8c8bhj8) —–

CREATE TABLE “ET$000706EA0001”  

 ( “OWNER”,

“PROGRAM_NAME”,

“ARGUMENT_NAME”,

“ARGUMENT_POSITION”,

“ARGUMENT_TYPE”,

“METADATA_ATTRIBUTE”,

“DEFAULT_VALUE”,

“OUT_ARGUMENT”,

“DEFAULT_ANYDATA_VALUE”  

 ) ORGANIZATION EXTERNAL   

( TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY “EXPORT_DIR” ACCESS PARAMETERS ( DEBUG = (0 , 0) DATAPUMP INTERNAL TABLE “SYSTEM”.”SCHEDULER_PROGRAM_ARGS” JOB

( “VAPPASA”,”SYS_EXPORT_FULL_01″,46) WORKERID 1 PARALLEL 1 VERSION ‘12.1.0.2.0’ ENCRYPTPASSWORDISNULL COMPRESSION DISABLED ENCRYPTION DISABLED ) LOCATION (‘bogus.dat’) ) PARALLEL 1 REJECT LIMIT UNLIMITED   

AS SELECT /*+ PARALLEL(KU$,1) */ “OWNER”, “PROGRAM_NAME”, “ARGUMENT_NAME”, “ARGUMENT_POSITION”, “ARGUMENT_TYPE”, “METADATA_ATTRIBUTE”, “DEFAULT_VALUE”, “OUT_ARGUMENT”, SYS_ET_IMAGE_TO_BLOB(SYS_OP_ITR(“DEFAULT_ANYDATA_VALUE”,1))   

FROM “SYSTEM”.”SCHEDULER_PROGRAM_ARGS” KU$

—– PL/SQL Call Stack —–  

object line object  

handle number name

0x65cae210 2015 package body SYS.KUPD$DATA

0x65cae210 3141 package body SYS.KUPD$DATA

0x65cae210 3684 package body SYS.KUPD$DATA

0x68b60a38 19307 package body SYS.KUPW$WORKER

0x68b60a38 3651 package body SYS.KUPW$WORKER

0x68b60a38 12049 package body SYS.KUPW$WORKER

0x68b60a38 2081 package body SYS.KUPW$WORKER

0x695b8048 2 anonymous block

3、发生故障的函数和调用堆栈类似于：

…. ksfdmp dbgexPhaseII dbgexProcessError dbgeExecuteForError dbgePostErrorKGE dbkePostKGE_kgsf kgeadse kgerinv_internal kgerinv kgesinv kgesin kotTrns kadadTr kolo_dispatch kokecbeitr rpiswu2 kokeOpqTransform2 kokeeitr evaopn2 …..

原因

未公开的Bug 16179296 XTDB EXPORT:

运行数据泵遇到：ORA 600 [KOTTRNS:TRANSIENT]是产生这个问题的原因，并且关闭，不是一个Bug

似乎是一个在导出system.scheduler_program_args视图的ANYDATA列到外部表的问题。

解决方案

删除由DMSYS拥有的程序参数和删除DMSYS schema将解决这个问题。

Use the following workaround to solve the issue:

Delete the program arguments owned by DMSYS

SQL> delete from SYSTEM.SCHEDULER_PROGRAM_ARGS where owner=’DMSYS’; SQL> commit;