Home » RDBMS Server » Server Utilities » impdp ORA-39029 (aix 6.1 oracle:10.2.0.4)
impdp ORA-39029 [message #553024] Tue, 01 May 2012 01:26 Go to next message
lerry
Messages: 16
Registered: December 2011
Junior Member
impdp system/manager1 directory=dmpdir parfile=impdp_smp.txt

$cat impdp_smp.txt
dumpfile=full_0501_1.dmp,full_0501_2.dmp,full_0501_3.dmp,full_0501_4.dmp
schemas=smp
exclude=table:"in ('SFCS_SN_SITE_STATISTICS','KP_KEYPART_RUNCARD','CELL_SORT_INFO_BY_CUSTOMER',
'WIP_RUNCARD','KP_KEYPART_FLEX','SFCS_SN_SITE_STATISTICS _MV') "
remap_tablespace=USERS:APP_TB,SYSTEM:APP_TB
logfile=impdp_smp.log
parallel=4

impdp error:
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.

Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" stopped due to fatal error at 12:26:24

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

please help me How to solve this problem

thank you

[Updated on: Tue, 01 May 2012 01:38] by Moderator

Report message to a moderator

Re: impdp ORA-39029 [message #553027 is a reply to message #553024] Tue, 01 May 2012 01:40 Go to previous messageGo to next message
Michel Cadot
Messages: 66796
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have a trace file for dw01 process in user_dump_dest or background_dump_dest director, have a look at it.
Also have a look at impdp log file.

Regards
Michel

[Updated on: Tue, 01 May 2012 01:40]

Report message to a moderator

Re: impdp ORA-39029 [message #553028 is a reply to message #553027] Tue, 01 May 2012 01:43 Go to previous messageGo to next message
lerry
Messages: 16
Registered: December 2011
Junior Member
hi,i look at the dw01 trace ,but there are no error in the trace
Re: impdp ORA-39029 [message #553029 is a reply to message #553028] Tue, 01 May 2012 01:47 Go to previous messageGo to next message
Michel Cadot
Messages: 66796
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post the log file.

Regards
Michel
Re: impdp ORA-39029 [message #553030 is a reply to message #553029] Tue, 01 May 2012 02:04 Go to previous messageGo to next message
lerry_wu
Messages: 12
Registered: December 2011
Junior Member
there no error in the alert.log

Re: impdp ORA-39029 [message #553031 is a reply to message #553030] Tue, 01 May 2012 02:09 Go to previous messageGo to next message
lerry_wu
Messages: 12
Registered: December 2011
Junior Member
i cann't find what causes the process DW01 died unexpectedly
Re: impdp ORA-39029 [message #553032 is a reply to message #553031] Tue, 01 May 2012 02:21 Go to previous messageGo to next message
Michel Cadot
Messages: 66796
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
logfile=impdp_smp.log


I meant this log file.

Regards
Michel
Re: impdp ORA-39029 [message #553046 is a reply to message #553032] Tue, 01 May 2012 06:30 Go to previous messageGo to next message
lerry
Messages: 16
Registered: December 2011
Junior Member
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
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.
Job "SYSTEM"."SYS_IMPORT_SCHEMA_03" stopped due to fatal error at 15:11:44
ORA-39014: One or more workers have prematurely exited.
Re: impdp ORA-39029 [message #553049 is a reply to message #553046] Tue, 01 May 2012 06:38 Go to previous messageGo to next message
Michel Cadot
Messages: 66796
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And the dw01 trace file (if any)?

Regards
Michel
Re: impdp ORA-39029 [message #553050 is a reply to message #553049] Tue, 01 May 2012 06:45 Go to previous messageGo to next message
lerry
Messages: 16
Registered: December 2011
Junior Member
in the dw01 trace ,all of like this
[kdl_trim]: newlen: 0
[kdl_trim]: newlen: 0
[kdl_trim]: newlen: 0
*** 2012-05-01 13:40:02.399
[kdl_trim]: newlen: 0
[kdl_trim]: newlen: 0
*** 2012-05-01 13:41:51.766
[kdl_trim]: newlen: 0
[kdl_trim]: newlen: 0
*** 2012-05-01 13:43:57.170
[kdl_trim]: newlen: 0
[kdl_trim]: newlen: 0
*** 2012-05-01 13:45:47.782
[kdl_trim]: newlen: 0
[kdl_trim]: newlen: 0
*** 2012-05-01 13:47:54.663
[kdl_trim]: newlen: 0
[kdl_trim]: newlen: 0

i'm thinking,there are 4 dumpfile and i set parallel=4
but if too many parallel processes


Re: impdp ORA-39029 [message #553061 is a reply to message #553050] Tue, 01 May 2012 08:27 Go to previous message
Michel Cadot
Messages: 66796
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Anyway, either some one kills dw01 either there is a bug.
Retry your import (maybe with less parallelism), if it does not work open a SR to Oracle.

Regards
Michel
Previous Topic: import d.dmp file
Next Topic: How to get the proper value in external table
Goto Forum:
  


Current Time: Fri Jan 24 10:37:25 CST 2020