Tag: adr

Database, Errors and Bugs

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

More“ORA-06512 ORA-48168 ORA-12012 for ADR Job Raising Errors”

Database, Shell Scripts

ADRCI Retention Policy and Ad-Hoc Purge Script for all Bases

 , , , , ,

As you know, since 11g we have a Automatic Diagnostic Repository (ADR). To better manage it, we also have a Command-line Interface, called ADRCI.
ADR contains all diagnostic information for database (logs, traces, incidents, problems, etc).

adr1

ADR Structure

More“ADRCI Retention Policy and Ad-Hoc Purge Script for all Bases”