現象
Data Pump でスキーマ・モードでエクスポートしたら、ORA-39126, ORA-00060, ORA-06512, ORA-39014 が発生する。
Export: Release 10.2.0.4.0 - 64bit Production on Monday, 30 August, 2010 23:34:28 Copyright (c) 2003, 2007, Oracle. All rights reserved. ;;; Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Starting "SYSTEM"."SYS_EXPORT_SCHEMA_17": system/******** directory=dump_dir dumpfile=***** parallel=2 logfile=********.log flashback_time="TO_TIMESTAMP(TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS')" Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UPDATE_TD_BASE_PO_INFO [TABLE_DATA:"****"."****":"****"."****"] UPDATE "SYSTEM"."SYS_EXPORT_SCHEMA_17" mtu SET mtu.base_process_order = NVL((SELECT mts1.process_order FROM "SYSTEM"."SYS_EXPORT_SCHEMA_17" mts1 WHERE mts1.process_order > 0 AND mts1.duplicate = 0 AND mts1.obj ect_schema = mtu.base_object_schema AND mts1.object_name = mtu.base_object_name AND mts1.object_type = mtu.base_object_type), (-1000 - (SELECT MIN(mts2.process_order) FROM "SYSTEM"."SYS_EXPORT_SCHEMA_17" mts2 W HERE mts2.process_order > 0 AND mts2.duplicate = 0 AND mts2.object_schema = mtu.base_object_schema AND mts2.object_name = mtu.base_object_name AND mts2.object_type = mtu.object_type))) WHERE mtu.process_order > 0 AND mtu.duplicate = 0 AND mtu.object_path_seqno = :1 ORA-00060: deadlock detected while waiting for resource ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105 ORA-06512: at "SYS.KUPW$WORKER", line 6351 ----- PL/SQL Call Stack ----- object line object handle number name 0x65e329920 15032 package body SYS.KUPW$WORKER 0x65e329920 6372 package body SYS.KUPW$WORKER 0x65e329920 13924 package body SYS.KUPW$WORKER 0x65e329920 14123 package body SYS.KUPW$WORKER 0x65e329920 9124 package body SYS.KUPW$WORKER 0x65e329920 1936 package body SYS.KUPW$WORKER 0x65e329920 6944 package body SYS.KUPW$WORKER 0x65e329920 1314 package body SYS.KUPW$WORKER 0x65e2f2148 2 anonymous block Job "SYSTEM"."SYS_EXPORT_SCHEMA_17" stopped due to fatal error at 23:35:16 ORA-39014: One or more workers have prematurely exited.
対処
以下参照。
- ID 861964.1
- Bug 6312112
