Tuesday, 22 July 2014

ORA-39029: worker 1 with process name "DW01" prematurely terminated



DataPump export is performed using COMPRESSION option. When attempting the import into target database the following errors occur:

Master table "ATLAS_TEMP"."SYS_IMPORT_TABLE_18" successfully loaded/unloaded
Starting "ATLAS_TEMP"."SYS_IMPORT_TABLE_18":  atlas_temp/******** dumpfile=pmbuvsnl_ind_atlas_09Apr2014.dmp logfile=pmbuvsnl_ind_atlas_09Apr2014_imp.log content=data_only version=11.1.0 tables=PMBUVSNL_IND_AGRI_NG.mbl_six,PMBUVSNL_IND_AGRI_NG.dn_six directory=atlas_apr14 remap_schema=PMBUVSNL_IND_AGRI_NG:atlas_temp remap_tablespace=PMBUVSNL_IND_AGRI:ATLAS_TS remap_tablespace=PMBUVSNL_IND_AGRI_IDX:ATLAS_TS table_exists_action=append 
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

ORA-39014: One or more workers have prematurely exited.

ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.

ORA-39014: One or more workers have prematurely exited.

ORA-39029: worker 2 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.
Job "ATLAS_TEMP"."SYS_IMPORT_TABLE_18" stopped due to fatal error at 15:23:01
  • The alert log file confirms: ORA-07445 occured:
Errors in file /u01/app/oracle/admin/TC/bdump/tc_dw01_4583456.trc:
ORA-07445: exception encountered: core dump [kdblcbo+02c0] [SIGSEGV] ..

  • It turned out, that the affected table was compressed:
SQL> select compression from dba_tables where owner='ATLAS_TEMP' and table_name='MBL_SIX';

COMPRESS
--------
ENABLED

Cause:-


Importing a compressed table with Impdp using direct path method generates ORA-7445 [kdblcbo]. Direct path is the default method that Data Pump uses for loading and unloading data.

Solution:-


Issue will be fixed in RDBMS Release 11.2.
  • Alter the table to use NOCOMRESS option 
alter table atlas_temp.mbl_six nocompress;
ACCESS_METHOD=EXTERNAL_TABLE
  • Import the table again it will successfully imported.
Master table "ATLAS_TEMP"."SYS_IMPORT_TABLE_19" successfully loaded/unloaded
Starting "ATLAS_TEMP"."SYS_IMPORT_TABLE_19":  atlas_temp/******** dumpfile=pmbuvsnl_ind_atlas_09Apr2014.dmp logfile=pmbuvsnl_ind_atlas_09Apr2014_imp.log content=data_only version=11.1.0 tables=PMBUVSNL_IND_AGRI_NG.mbl_six,PMBUVSNL_IND_AGRI_NG.dn_six directory=atlas_apr14 remap_schema=PMBUVSNL_IND_AGRI_NG:atlas_temp remap_tablespace=PMBUVSNL_IND_AGRI:ATLAS_TS remap_tablespace=PMBUVSNL_IND_AGRI_IDX:ATLAS_TS table_exists_action=append 
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "ATLAS_TEMP"."MBL_SIX":"P_09APR2014"        470.1 MB  953364 rows
. . imported "ATLAS_TEMP"."DN_SIX":"P_09APR2014"         300.0 MB  908503 rows
Job "ATLAS_TEMP"."SYS_IMPORT_TABLE_19" successfully completed at 15:39:28

No comments:

Post a Comment