Database Technologies‎ > ‎Oracle‎ > ‎

Oracle Database Diagnostic .. ADR, DRA..

Oralce Init Paramter 
Diagnostic_Dest - Points out to the file based repository of the database, where everything is logged.

OS Environment variable ADR_BASE  should be pointed to the same location as in the DIAGNOSTIC_DEST  init parameter.

DRA  is the Component of the Oracle thats update/writes to the ADR
DRA has important part called the Health Monitor/Advisor which regularly monitors the health of the database and
updates via DRA to the ADR any issues it finds

We can view the logs in the ADR via

1) Enterprise management console
2) SQL