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

3) ADRCI