Impdp experience ORA-39029, ORA-31671, ORA-06512

[Oracle @ rac1 ~] $ Scheme. impdplogREMAP_TABLESPACEwxlun: wxlun_DATAREMAP_SCHEMAwxlun: wxlun0402Import: Release11.2.0.3.0

[Oracle @ rac1 ~] $ Impdp \/as sysdba \ directory = expdp dumpfile = export logfile = export REMAP_TABLESPACE = wxlun: wxlun_DATA REMAP_SCHEMA = wxlun: Release 11.2.0.3.0-Production on Thu Apr 2 10:46:29 2015 Copyrig

[Oracle @ rac1 ~] $ Impdp \ '/as sysdba \' directory = expdp dumpfile = wxlun0402.dmp logfile = wxlun0402.impdplog REMAP_TABLESPACE = wxlun: wxlun_DATA REMAP_SCHEMA = wxlun: wxlun0402Import: 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 ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing optionsMaster table "SYS ". "SYS_IMPORT_FULL_01" successfully loaded/unloadedStarting "SYS ". "SYS_IMPORT_FULL_01": "/******* as sysdba" directory = expdp dumpfile = wxlun0402.dmp logfile = export REMAP_TABLESPACE = wxlun: wxlun_DATA REMAP_SCHEMA = wxlun: wxlun0402Processing object type SCHEMA_EXPORT/USERORA-31684: Object type USER: "wxlun0402" already exists ------ the USER has created, error message: Ignore Processing object type SCHEMA_EXPORT/jsonobject type partition/jsonobject type SCHEMA_EXPORT/jsonobject type partition/PRE_SCHEMA/jsonobject type SCHEMA_EXPORT/TABLE/TABLEProcessing object type SCHEMA_EXPORT/TABLE/INDEX/ INDEXProcessing object type partition/TABLE/CONSTRAINT/CONSTRAINTProcessing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/jsonobject type partition/TABLE/COMMENTProcessing object type partition/TABLE/STATISTICS/TABLE_STATISTICS --- start below error --- ORA-39014: one or more workers have prematurely exited. ORA-39029: worker 1 with process name "DW00" prematurely terminatedORA-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 1838ORA-06512: at line 2ORA-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 statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3ORA-06512: at "SYS. DBMS_SYS_ERROR ", line 95ORA-06512: at" SYS. KUPW $ WORKER ", line 9001 ----- PL/SQL Call Stack ----- object line objecthandle number name0x17c15e530 20462 package body SYS. KUPW $ WORKER0x17c15e530 9028 package body SYS. KUPW $ WORKER0x17c15e530 4185 package body SYS. KUPW $ WORKER0x17c15e530 9725 package body SYS. KUPW $ WORKER0x17c15e530 1775 package body SYS. KUPW $ WORKER0x172f16550 2 anonymous blockORA-39014: One or more workers have prematurely exited. ORA-39029: worker 3 with process name "DW00" prematurely terminatedORA-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 1838ORA-06512: at line 2ORA-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 statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3ORA-06512: at "SYS. DBMS_SYS_ERROR ", line 95ORA-06512: at" SYS. KUPW $ WORKER ", line 9001 ----- PL/SQL Call Stack ----- object line objecthandle number name0x17c15e530 20462 package body SYS. KUPW $ WORKER0x17c15e530 9028 package body SYS. KUPW $ WORKER0x17c15e530 4185 package body SYS. KUPW $ WORKER0x17c15e530 9725 package body SYS. KUPW $ WORKER0x17c15e530 1775 package body SYS. KUPW $ WORKER0x172f16550 2 anonymous blockORA-39014: One or more workers have prematurely exited. ORA-39029: worker 5 with process name "DW00" prematurely terminatedORA-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 1838ORA-06512: at line 2ORA-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 statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3ORA-06512: at "SYS. DBMS_SYS_ERROR ", line 95ORA-06512: at" SYS. KUPW $ WORKER ", line 9001 ----- PL/SQL Call Stack ----- object line objecthandle number name0x17c15e530 20462 package body SYS. KUPW $ WORKER0x17c15e530 9028 package body SYS. KUPW $ WORKER0x17c15e530 4185 package body SYS. KUPW $ WORKER0x17c15e530 9725 package body SYS. KUPW $ WORKER0x17c15e530 1775 package body SYS. KUPW $ WORKER0x172f16550 2 anonymous blockORA-39014: One or more workers have prematurely exited. ORA-39029: worker 7 with process name "DW00" prematurely terminatedORA-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 1838ORA-06512: at line 2ORA-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 statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3ORA-06512: at "SYS. DBMS_SYS_ERROR ", line 95ORA-06512: at" SYS. KUPW $ WORKER ", line 9001 ----- PL/SQL Call Stack ----- object line objecthandle number name0x17c15e530 20462 package body SYS. KUPW $ WORKER0x17c15e530 9028 package body SYS. KUPW $ WORKER0x17c15e530 4185 package body SYS. KUPW $ WORKER0x17c15e530 9725 package body SYS. KUPW $ WORKER0x17c15e530 1775 package body SYS. KUPW $ WORKER0x172f16550 2 anonymous blockORA-39014: One or more workers have prematurely exited. ORA-39029: worker 9 with process name "DW00" prematurely terminatedORA-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 1838ORA-06512: at line 2ORA-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 statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3ORA-06512: at "SYS. DBMS_SYS_ERROR ", line 95ORA-06512: at" SYS. KUPW $ WORKER ", line 9001 ----- PL/SQL Call Stack ----- object line objecthandle number name0x17c15e530 20462 package body SYS. KUPW $ WORKER0x17c15e530 9028 package body SYS. KUPW $ WORKER0x17c15e530 4185 package body SYS. KUPW $ WORKER0x17c15e530 9725 package body SYS. KUPW $ WORKER0x17c15e530 1775 package body SYS. KUPW $ WORKER0x172f16550 2 anonymous blockORA-39014: One or more workers have prematurely exited. ORA-39029: worker 11 with process name "DW00" prematurely terminatedORA-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 1838ORA-06512: at line 2ORA-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 [this article is from the Internet of Hong Kong ( http://www.68idc.cn ) 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 statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3ORA-06512: at "SYS. DBMS_SYS_ERROR ", line 95ORA-06512: at" SYS. KUPW $ WORKER ", line 9001 ----- PL/SQL Call Stack ----- object line objecthandl E number name0x17c15e530 20462 package body SYS. KUPW $ WORKER0x17c15e530 9028 package body SYS. KUPW $ WORKER0x17c15e530 4185 package body SYS. KUPW $ WORKER0x17c15e530 9725 package body SYS. KUPW $ WORKER0x17c15e530 1775 package body SYS. KUPW $ WORKER0x172f16550 2 anonymous blockImport> 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=wxlun0402.impdplog REMAP_TABLESPACE=wxlun:wxlun_DATA REMAP_SCHEMA=wxlun:wxlun0402 EXCLUDE=STATISTICSImport: Release 11.2.0.3.0 - Production on Thu Apr 2 12:52:04 2015Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Data Mining and Real Application Testing optionsMaster table "SYS"."SYS_IMPORT_FULL_02" successfully loaded/unloadedStarting "SYS"."SYS_IMPORT_FULL_02": "/******** AS SYSDBA" directory=expdp dumpfile=wxlun0402.dmp logfile=wxlun0402.impdplog REMAP_TABLESPACEwxlun:wxlun_DATA REMAP_SCHEMA=wxlun:wxlun0402 EXCLUDE=STATISTICSProcessing object type SCHEMA_EXPORT/USERORA-31684: Object type USER:"wxlun0402" already existsProcessing object type SCHEMA_EXPORT/SYSTEM_GRANTProcessing object type SCHEMA_EXPORT/ROLE_GRANTProcessing object type SCHEMA_EXPORT/DEFAULT_ROLEProcessing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMAProcessing object type SCHEMA_EXPORT/TABLE/TABLEProcessing object type SCHEMA_EXPORT/TABLE/INDEX/INDEXProcessing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINTProcessing object type SCHEMA_EXPORT/TABLE/COMMENTJob "SYS"."SYS_IMPORT_FULL_02" completed with 1 error(s) at 13:26:19