Monday, November 12, 2012

expdp fails with ORA-31626 ORA-31637 ORA-06512 ORA-31635 errors


Error:

 ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 798
ORA-31635: unable to establish job resource synchronization

Workaround:

AQ_TM_PROCESSES process should be 1.

Set  AQ_TM_PROCESSES = 1 parameter and bounce the database will resolve issue.


Issue:

 V$XML_AUDIT_TRAIL Returns No Rows :

Workaround :

This is bug on 11.2.0.2

Refer Metalink ID  (Doc ID 1267954.1) .Have to Apply Patch 9438890 to solve this problem.

1 comment:

Ganesh said...

thanks for solution.

my small doubt here is, what if aq_tm_processes is set to 1.

as I faced the same ora errors mentioned above, and i checked aq_tm_processes parameter.

It is set to 1 only :(