Friday, February 14, 2014

expdp/impdp fails reports ORA-21780 at the end of export

Recently i had an expdp that reported the following:

ORA-39097: Data Pump job encountered unexpected error -21780
ORA-39065: unexpected master process exception in DISPATCH
ORA-21780: Maximum number of object durations exceeded.

After searching Oracle Support (see below) the issue is not affecting the data and the consistency of the dump file thus data were successfully exported.

The side effect is that it leaves an orphaned data pump job in dba_datapump_jobs.

Check http://agstamy.blogspot.be/2012/10/cleanup-orphaned-datapump-jobs.html of how to clean orphaned data pump jobs.

The issue is raised after changing the PARALELL workers of the running datapump job.

The Oracle Support document states that this happens only if lowering the PARALLEL workers of a running job, but the referenced bug reference and workaround state DO NOT MODIFY PARALLEL while the job is running.

REFERENCES:

Oracle Support Doc ID 1357811.1

Versions Affected : Version 10.1.0.2 to 11.2.0.3

BUG:10198387 - DATA PUMP EXPORT REPORTS ORA-21780 WHEN PARALLELISM (PARALLEL=N) IS MODIFIED

WORKAROUND

Don't change the number of parallel processes while Data Pump Export is running.

FIXED :

11.2.0.4
12.1

1 comment: