EXPDP - ORA-24795 (Illegal ROLLBACK Attempt Made) ORA-02354 ORA-01891 On 10.2.0.4 Expdp Job (Doc ID 1638321.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]
Oracle Database - Personal Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]
Oracle Database - Standard Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]
Enterprise Manager for Oracle Database - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]
Generic Windows

Symptoms

1. When running an export Data pump job on 10.2.0.4 on Windows, the following errors occur:

C:\> expdp system/manager directory=my_dir dumpfile=expdp_f%U.dmp logfile=expdp_f.log full=y parallel=4

Export: Release 10.2.0.4.0 - Production on Fri Mar 21 10:15:39 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_TABLE_01":  system/******** directory=my_dir dumpfile=expdp_f%U.dmp logfile=expdp_f.log full=y parallel=4
Estimate in progress using BLOCKS method...
...
exported "SYSMAN"."MGMT_NOTIFY_QUEUES"               5.539 KB      24 rows
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 4 with process name "DW04" prematurely terminated
ORA-31671: Worker process DW04 had an unhandled exception.
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 1352
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 7073
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 2829
ORA-24795: Illegal ROLLBACK attempt made
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 10915
ORA-02354: error in exporting/importing data
ORA-01891: Datetime/Interval internal error
...
ORA-39029: worker 2 with process name "DW02" prematurely terminated
ORA-31671: Worker process DW02 had an unhandled exception.
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 1352
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 7073
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 2829
ORA-24795: Illegal ROLLBACK attempt made
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 10915
ORA-02354: error in exporting/importing data
ORA-01891: Datetime/Interval internal error
...

2. The errors mainly occur on Oracle10g Release 2 (10.2.0.1 and 10.2.0.2 and 10.2.0.3 and 10.2.0.4) on Microsoft Windows platforms.

3. The errors occur on random tables.

4. Only specific databases are involved, while other databases with the same 10.2.0.x release or even in the same $ORACLE_HOME, can be exported with DataPump without problems.

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