expdp error: 31623 and ORA-12805 in cluster 10.2.0.4

I was getting an error with expdp in our cluster 10.2.0.4 running on Red-Hat

UDE-00008: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at “SYS.DBMS_DATAPUMP”, line 2772
ORA-06512: at “SYS.DBMS_DATAPUMP”, line 3886
ORA-06512: at line 1

ORA-12805: parallel query server died unexpectedly

I found the solution in metalink, it is actually a bug and Oracle recommends to run these scripts, they will rebuild Datapump’s dictionary objects and the last one will recompile the invalid ones:

-

@$ORACLE_HOME/rdbms/admin/catdph.sql

@$ORACLE_HOME/rdbms/admin/prvtdtde.plb

@$ORACLE_HOME/rdbms/admin/catdpb.sql

@$ORACLE_HOME/rdbms/admin/dbmspump.sql

@$ORACLE_HOME/rdbms/admin/utlrp.sql

After I ran all the scripts I had to bounce the database, but at least I have my exports up and running again.
be careful with the utlrp.sql, because if there are other DDLs running you might get deadlocks

Advertisements
This entry was posted in Backup & Recovery, Linux/Unix, Oracle Server and tagged , , , . Bookmark the permalink.

One Response to expdp error: 31623 and ORA-12805 in cluster 10.2.0.4

  1. vijay says:

    Thanks a bunch. Your solution saved the day for me.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s