My Oracle Support Banner

DataPump Export (EXPDP) Finishes With Errors ORA-28 ORA-31671 (Doc ID 1503488.1)

Last updated on JULY 26, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 18-Dec-2014***

Symptoms

On 11.2.0.3 version, when attempting to perform an export using DataPump on a RAC configuration, this intermittently fails with errors like below:

ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-00028: your session has been killed
ORA-00028: your session has been killed
ORA-06512: at "SYS.KUPF$FILE", líne 8003
ORA-06512: at líne 1
ORA-06512: at "SYS.KUPD$DATA_INT", líne 18
ORA-06512: at "SYS.KUPD$DATA", líne 3301
ORA-06512: at "SYS.KUPW$WORKER", líne 15332
ORA-06512: at "SYS.KUPW$WORKER", líne 3145
ORA-06512: at "SYS.KUPW$WORKER", líne 9711
ORA-06512: at "SYS.KUPW$WORKER", líne 1775
ORA-06512: at líne 2
Job "SYS". "SYS_EXPORT_FULL_01" has stopped due to a fatal error at 2:32:57 PM


The alert log file shows entries like:

Sun Sep 16 14:32:14 2012
DW00 terminating with fatal err=28, pid=53, wid=1, job SYS.
opidrv aborting process DW00 ospid (30015500) as a result of ORA-28


Nobody has killed the session.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.