Oracle ORA-31671: Worker process DW08 had an unhandled exception.

expdp (Export datapump) fail with following errors (shown in symptoms) in Oracle RDBMS 10.2.0.3.

Applies to:

Oracle RDBMS 10.1 to 10.2

Symptoms:

#– found following errors on expdb logs –#

Starting “MYUSER”.”MYUSER_JOB”: MYUSER/******** DIRECTORY=EXP_EG711 LOGFILE=myuser_dmp.log DUMPFILE=myuser%U.dmp JOB_NAME=myuser_job CONTENT=all FILESIZE=20G PARALLEL=16

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

ORA-39029: worker 8 with process name “DW08” prematurely terminated

ORA-31671: Worker process DW08 had an unhandled exception.

ORA-12801: error signaled in parallel query server P000, instance mynode03:MYDB3 (3)

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 1342

ORA-06512: at line 2

Job “WM7IS”.”MYUSER_JOB” stopped due to fatal error at 00:35:10

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

#– Also found followings errors on bdump trace file –#

kupprdp: Error 12801 detected in worker process DW08, worker id=8.

OPIRIP: Uncaught error 447. Error stack:

ORA-00447: fatal error in background process

ORA-31671: Worker process DW08 had an unhandled exception.

ORA-12801: error signaled in parallel query server P000, instance mynode0303:MYDB3 (3)

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 1342

ORA-06512: at line 2

Cause:

BUG 5472417 EXPDP ON RAC ABORTS DUE TO ORA-12801 (ERROR SIGNALED IN PARALLEL QUERY SERVER)

Bug is fixed in 11.1.0.6 or above

Solution:

Use either one of the solution / workaround,

1) Use PARALLEL=1 (default)

2) Run expdb when only one instance is started.

3) Apply one-off patch ( Patch: 5472417 )

4) Upgrade to 11.1.0.6 or higher version

Tagged Under : , , , , , , ,

Make a Comment