impdp遭遇ORA-39029、ORA-31671、ORA-06512(三)
y terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-04030: out of process memory when trying to allocate 120048 bytes (session heap,kuxLpxAlloc)
ORA-06512: at "SYS.KUPW$WORKER", line 1838
ORA-06512: at line 2
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADATA [SELECT process_order, flags, xml_clob, NVL(dump_fileid, :1), NVL(dump_position, :2), dump_length, dump_allocation, NVL(value_n, 0), grantor, object_row, object_schema, object_long_name, partition_name, subpartition_name, processing_status, processing_state, base_object_type, base_object_schema, base_object_name, base_process_order, property, size_estimate, in_progress, original_object_schema, original_object_name, creation_level, object_int_oid FROM "SYS"."SYS_IMPORT_FULL_01" WHERE process_order between :3 AND :4 AND duplicate = 0 AND processing_state NOT IN (:5, :6, :7) ORDER BY process_order]
ORA-19505: failed to identify file "/u01/oracle/expdp/wxlun0402.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9001
----- PL/SQL Call Stack -----
object line object
handle number name
0x17c15e530 20462 package body SYS.KUPW$WORKER
0x17c15e530 9028 package body SYS.KUPW$WORKER
0x17c15e530 4185 package body SYS.KUPW$WORKER
0x17c15e530 9725 package body SYS.KUPW$WORKER
0x17c15e530 1775 package body SYS.KUPW$WORKER
0x172f16550 2 anonymous block
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 9 with process name "DW00" prematurely terminate
d
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-04030: out of process memory when trying to allocate 16048 bytes (session heap,kuxLpxAlloc)
ORA-06512: at "SYS.KUPW$WORKER", line 1838
ORA-06512: at line 2
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADATA [SELECT process_order, flags, xml_clob, NVL(dump_fileid, :1), NVL(dump_position, :2), dump_length, dump_allocation, NVL(value_n, 0), grantor, object_row, object_schema, object_long_name, partition_name, subpartition_name, processing_status, processing_state, base_object_type, base_object_schema, base_object_name, base_process_order, property, size_estimate, in_progress, original_object_schema, original_object_name, creation_level, object_int_oid FROM "SYS"."SYS_IMPORT_FULL_01" WHERE process_order between :3 AND :4 AND duplicate = 0 AND processing_state NOT IN (:5, :6, :7) ORDER BY process_order]
ORA-19505: failed to identify file "/u01/oracle/expdp/wxlun0402.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9001
----- PL/SQL Call Stack -----
object line object
handle number name
0x17c15e530 20462 package body SYS.KUPW$WORKER
0x17c15e530 9028 package body SYS.KUPW$WORKER
0x17c15e530 4185 package body SYS.KUPW$WORKER
0x17c15e530 9725 package body SYS.KUPW$WORKER
0x17c15e530 1775 package body SYS.KUPW$WORKER
0x172f16550 2 anonymous block
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 11 with process name "DW00" prematurely terminated
ORA-31671