DataPump Export (EXPDP) Fails With Errors ORA-31671 ORA-12801 ORA-31626 When Parallel Parameter Is Used In RAC (Doc ID 438608.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.3 [Release 10.1 to 10.2]
Information in this document applies to any platform.
***Checked for relevance on 22-Oct-2013***

Symptoms

DataPump export (expdp) fails with the following errors when PARALLEL parameter is used in RAC environment:

ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 2 with process name "DW05" prematurely terminated
ORA-31671: Worker process DW05 had an unhandled exception.
ORA-12801: error signaled in parallel query server P000, instance <>(2)
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-31626: job does not exist
ORA-06512: at "SYS.ORACLE_DATAPUMP", line 19
ORA-06512: at "SYS.KUPW$WORKER", line 1345
ORA-06512: at line 2
Job "SYSTEM"."<>" stopped due to fatal error at 20:02:18
ORA-39014: One or more workers have prematurely exited.

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