诗檀软件专业数据库修复团队
适用于
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;