Error ORA-39078 Received During DataPump Parallel Import (Doc ID 790775.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 11.1.0.7 - Release: 10.2 to 11.1
Information in this document applies to any platform.

Symptoms

Following errors are encountered when performing DataPump parallel import:

ORA-39029: worker 3 with process name "DW03" prematurely terminated
ORA-31671: Worker process DW03 had an unhandled exception.
ORA-39078: unable to dequeue message for agent KUPC$A_1_20090313003200 from queue "KUPC$C_1_20090313002622"
ORA-06512: at "SYS.KUPW$WORKER", line 1397
ORA-06512: at line 2

Import command line:

#> impdp system/password schemas=SCOTT parallel=4 DIRECTORY=DUMP_DIR
LOGFILE=IMP.log DUMPFILE=exp_01.dmp,exp_02.dmp,exp_03.dmp,exp_04.dmp

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms