11g Fault Diagnosability Infrastructure

The 11g Fault Diagnosability Infrastructure is designed to help prevent, detect, and resolve problems such as database bugs and various forms of corruption.

But first things first, where is this information held in flat files.

The following parameters have been deprecated; USER_DUMP_DEST, CORE_DUMP_DEST, BACKGROUND_DUMP_DEST took make way for the DIAGNOSTIC_DEST parameter.

By default DIAGNOSTIC_DEST is set to the $ORACLE_BASE directory.

From the DIAGNOSTIC_DEST directory we can drill down.

DIAGNOSTIC_DEST($ORACLE_BASE)
\diag
\rdbms
\DBName
\SID
\Alert (XML alert log)
\cdump (Core dumps)
\Incident (Incident detail dirs)
\Trace (trace files + text alert log)
\(others)

The v$diag_info shows the locations of the various Automatic Diagnostic Repository.

SQL> select name, value from v$diag_info;

NAME VALUE
----------------------- -----------------------------------------------------------
Diag Enabled TRUE
ADR Base /u01/app/oracle
ADR Home /u01/app/oracle/diag/rdbms/prac11g/prac11g
Diag Trace /u01/app/oracle/diag/rdbms/prac11g/prac11g/trace
Diag Alert /u01/app/oracle/diag/rdbms/prac11g/prac11g/alert
Diag Incident /u01/app/oracle/diag/rdbms/prac11g/prac11g/incident
Diag Cdump /u01/app/oracle/diag/rdbms/prac11g/prac11g/cdump
Health Monitor /u01/app/oracle/diag/rdbms/prac11g/prac11g/hm
Default Trace File /u01/app/oracle/diag/rdbms/prac11g/prac11g/trace/prac11g_ora_7667.trc
Active Problem Count 0
Active Incident Count 0

11 rows selected.

******************************************
keywords:
******************************************
rdbms version:
******************************************