12c Data Pump Export Fails With ORA-39126: Worker Unexpected Fatal Error In KUPW$WORKER.FETCH_XML_OBJECTS [] ORA-1403 and ORA-6512 Errors (Doc ID 2136399.1)

Last updated on MAY 10, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.0.2 version, Data Pump Export.

You are attempting to perform an full or schema based export (EXPDP), and shortly after the estimate, the job fails with the following errors:

Estimate in progress using BLOCKS method...
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS []
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 11254

 

Changes

 Upgrade to 12.1.0.2 and change of PLSQL_OPTIMIZE_LEVEL from the default setting of 2.

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