Impdp experience ORA-39029, ORA-31671, ORA-06512, impdpora-39029
[Oracle @ rac1 ~] $ Impdp \ '/as sysdba \' directory = expdp dumpfile = wxlun0402.dmp logfile = wxlun0402.impdplog REMAP_TABLESPACE = wxlun: wxlun_DATA REMAP_SCHEMA = wxlun: wxlun0402
Import: Release 11.2.0.3.0-Production on Thu Apr 2 10:46:29 2015
Copyright (c) 1982,201 1, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Master table "SYS". "SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS ". "created": "/******** as sysdba" directory = expdp dumpfile = wxlun0402.dmp logfile = pairemap_tablespace = wxlun: wxlun_DATA REMAP_SCHEMA = wxlun: wxlun0402
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER: "wxlun0402" already exists ------ USER created, error ignored
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
--- The following error is reported ---
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-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, struct, struct, property, struct, in_progress, struct, struct, creation_level, category 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 3 with process name "DW00" prematurely 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, struct, struct, property, struct, in_progress, struct, struct, creation_level, category 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 5 with process name "DW00" prematurely terminated
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, struct, struct, property, struct, in_progress, struct, struct, creation_level, category 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 7 with process name "DW00" prematurely 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, struct, struct, property, struct, in_progress, struct, struct, creation_level, category 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 terminated
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, struct, struct, property, struct, in_progress, struct, struct, creation_level, category 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: 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, struct, struct, property, struct, in_progress, struct, struct, creation_level, category 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
Import> exit
^
[Oracle @ rac1 ~] $ Logout
Because the error is reported in Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS, the error is related to the statistical information. This is a bug. When impdp is used, EXCLUDE = STATISTICS is added, collect statistics manually after import.
The import is completed as follows:
[Oracle @ rac1 ~] $ Impdp \ '/as sysdba \' directory = expdp dumpfile = wxlun0402.dmp logfile = export REMAP_TABLESPACE = wxlun: wxlun_DATA REMAP_SCHEMA = wxlun: wxlun0402 EXCLUDE = STATISTICS
Import: Release 11.2.0.3.0-Production on Thu Apr 2 12:52:04 2015
Copyright (c) 1982,201 1, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Master table "SYS". "SYS_IMPORT_FULL_02" successfully loaded/unloaded
Starting "SYS ". "partition": "/******** as sysdba" directory = expdp dumpfile = wxlun0402.dmp logfile = partition: wxlun_DATA REMAP_SCHEMA = wxlun: wxlun0402 EXCLUDE = STATISTICS
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER: "wxlun0402" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Job "SYS". "SYS_IMPORT_FULL_02" completed with 1 error (s) at 13:26:19
