ora error ORA-39029: worker 2 with process name "DW02" prematurely terminated
FranklinFaces.com
FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals
 Home          Members     Calendar     Who's On

Welcome Guest ( Login | Register )
        



ora error ORA-39029: worker 2 with process... Expand / Collapse
Message
Posted 6/14/2010 11:54:29 AM Post #305
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being
ORA-39029: worker 2 with process name "DW02" prematurely terminated

I got the following error message when using impdp :

ORA-30036: unable to extend segment by 4 in undo tablespace 'UNDOTBS01'
ORA-39171: Job is experiencing a resumable wait.
ORA-30036: unable to extend segment by 4 in undo tablespace 'UNDOTBS01'
ORA-39171: Job is experiencing a resumable wait.
ORA-30036: unable to extend segment by 4 in undo tablespace 'UNDOTBS01'
ORA-39171: Job is experiencing a resumable wait.
ORA-30036: unable to extend segment by 4 in undo tablespace 'UNDOTBS01'
ORA-39171: Job is experiencing a resumable wait.
ORA-30036: unable to extend segment by 4 in undo tablespace 'UNDOTBS01'
ORA-39171: Job is experiencing a resumable wait.
ORA-30036: unable to extend segment by 4 in undo tablespace 'UNDOTBS01'
ORA-39171: Job is experiencing a resumable wait.
ORA-30036: unable to extend segment by 4 in undo tablespace 'UNDOTBS01'
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 2 with process name "DW02" prematurely terminated
ORA-31672: Worker process DW02 died unexpectedly.
Job "SYS"."SYS_IMPORT_SCHEMA_03" stopped due to fatal error at 16:30:38
ORA-39014: One or more workers have prematurely exited.

This was pretty clear cut.   My undo tablespace needed tuning.


I updated my undo_retention and set it to 900 :

alter system set undo_retention=900 scope=both;

I added another undo datafile and then kicked off the import again and it went through fine.

« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: silencer

Permissions Expand / Collapse

All times are GMT -5:00, Time now is 9:35am

Powered By InstantForum.NET v4.1.4 © 2012
Execution: 0.068. 7 queries. Compression Disabled.
Contextual Links