ORA-06512 ORA-48168 ORA-12012 for ADR Job Raising Errors

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!

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.