Getting Error In Alert Log ORA-51108: Unable To Access Diagnostic Repository

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;

Leave a Comment

Your email address will not be published.