2010-08-31
ORA-39126: Worker unexpected fatal error in KUPW$WORKER
現象
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
トラックバック - http://d.hatena.ne.jp/yohei-a/20100831/1283227400
リンク元
- 47 http://www.google.co.jp/search?sourceid=navclient&hl=ja&ie=UTF-8&rlz=1T4GGLL_jaJP331JP331&q=遠隔 サービス 起動 Windows
- 29 http://www.google.co.jp/search?hl=ja&lr=lang_ja&tbs=lr:lang_1ja&q=oracle+merge+一意制約&aq=f&aqi=g1&aql=&oq=&gs_rfai=
- 12 http://d.hatena.ne.jp/notify-NotifyUser_POST_NG_CATEGORY?aHR0cDovL2QuaGF0ZW5hLm5lLmpwL3lvaGVpLWEvMjAxMDAzMjkvMTI2OTg0NzIwMg==
- 9 http://www.google.com/search?hl=ja&lr=lang_ja&ie=UTF-8&oe=UTF-8&q=solaris+tab+補完&num=50
- 8 http://www.google.co.jp/search?hl=ja&rls=com.microsoft:ja:IE-SearchBox&rlz=1I7GGLJ_ja&q=LINUX+shell 古いログを消去&aq=f&aqi=&aql=&oq=&gs_rfai=
- 6 http://www.google.co.jp/search?hl=ja&client=firefox-a&rls=org.mozilla:ja:official&q=pro*c+コメント&aq=f&aqi=&aql=&oq=&gs_rfai=
- 6 http://www.google.co.jp/search?sourceid=navclient&aq=t&hl=ja&ie=UTF-8&rlz=1T4GGLJ_jaJP344JP345&q=solaris+バージョン
- 5 http://www.google.co.jp/search?hl=ja&lr=lang_ja&client=firefox-a&rls=org.mozilla:ja:official&tbs=lr:lang_1ja&q=RAC+spfile&aq=f&aqi=g1&aql=&oq=&gs_rfai=
- 5 http://www.google.co.jp/search?hl=ja&q=sar+メモリ&lr=&aq=f&aqi=g3g-cr3g-mr4&aql=&oq=&gs_rfai=
- 4 http://bugzero.shooti.jp/sitehead/http://d.hatena.ne.jp/yohei-a/20100827/1282884562
