ORA-06512 ORA-48168 ORA-12012 for ADR Job Raising Errors
A database is raising stack below on alertlog:
Errors in file /db/u7011/oracle/admin/MYDB/trace/MYDB_j002_22935.trc: ORA-12012: error on auto execute of job "SYS"."DRA_REEVALUATE_OPEN_FAILURES" ORA-48168: the ADR sub-system is not initialized ORA-06512: at "SYS.DBMS_IR", line 522
But database isn’t with ADR enabled:
SQL> select * from V$DIAG_INFO where NAME='Diag Enabled'; INST_ID NAME VALUE ---------- ---------------------------------------------------------------- ------------------------------------------------------- 1 Diag Enabled FALSE
The note ORA-12012 And ORA-48168: ADR Sub-system Is Not Initialized (Doc ID 1601769.1) is indicating to make maintenance involving database shutdown… But I don’t want to.
The note Getting Error In Alert Log ORA-51108: Unable To Access Diagnostic Repository – Retry Command (Doc ID 1586736.1) indicates to recrate Health Monitor Information, through:
SQL> exec dbms_hm.drop_schema; SQL> exec dbms_hm.create_schema;
But It gone wrong:
SQL> exec dbms_hm.drop_schema; BEGIN dbms_hm.drop_schema; END; * ERROR at line 1: ORA-51026: Diag ADR not enabled, can't run check ORA-06512: at "SYS.DBMS_HM", line 261 ORA-06512: at line 1
As I said, the Diag is not Enabled. So, the easiest “workaround” is to just disable the job:
SQL> exec dbms_scheduler.disable('DRA_REEVALUATE_OPEN_FAILURES'); PL/SQL procedure successfully completed.
See ya!
Matheus.