Error :
ORA-12012: error on auto execute of job “SYS”.”DRA_REEVALUATE_OPEN_FAILURES”
ORA-51108: unable to access diagnostic repository – retry command
ORA-48223: Interrupt Requested – Fetch Aborted – Return Code [51111] [HM_FINDING]
ORA-48223: Interrupt Requested – Fetch Aborted – Return Code [51111] [HM_FINDING]
ORA-06512: at “SYS.DBMS_IR”, line 522
The errors reoccur daily.
The Recovery Advisor job is interrupted unexpectedly during the RDBMS maintenance window
Either:
1/ disable the associated job via the command below:
exec dbms_scheduler.disable(‘DRA_REEVALUATE_OPEN_FAILURES’);
OR
2/ rebuild the HM INFO data set of the ADR using the commands below:
exec dbms_hm.drop_schema;
exec dbms_hm.create_schema;