Member-only story
Getting Error In Alert Log ORA-51108: Unable To Access Diagnostic Repository
Jan 4, 2022
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;
