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:
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 :(
Post a Comment