Alert Log, Trace Files and ADR

Oracle DBA Certification 12 min min read Updated: Nov 16, 2026 Beginner
Alert Log, Trace Files and ADR
Beginner Topic 6 of 6

Where Oracle Writes Its Diary

The alert log is a text file where Oracle records important events: startup, shutdown, errors, log switches, parameter changes. When something goes wrong, it is the first place a DBA looks.

The ADR

All diagnostic files are kept in the Automatic Diagnostic Repository (ADR), a folder tree controlled by the parameter diagnostic_dest.

sql SELECT name, value FROM v$diag_info;
Row in V$DIAG_INFOMeaning
ADR BaseRoot folder of diagnostics
Diag TraceFolder with alert log and trace files
Diag AlertAlert log in XML format
Default Trace FileTrace file of your own session

Read the Alert Log

bash # find the folder first with V$DIAG_INFO, then: tail -100 alert_FREE.log # watch it live tail -f alert_FREE.log
sql -- or read it from SQL SELECT originating_timestamp, message_text FROM v$diag_alert_ext WHERE originating_timestamp > SYSDATE - 1 AND message_text LIKE '%ORA-%' ORDER BY originating_timestamp;

Understand ORA- Errors

ErrorMeaningUsual fix
ORA-01017Invalid username or passwordCheck credentials
ORA-12541No listenerStart the listener, check host and port
ORA-01555Snapshot too oldIncrease undo retention, tune long queries
ORA-01653Cannot extend table: tablespace fullAdd space to the tablespace
ORA-00060Deadlock detectedFix application locking order
ORA-04031Cannot allocate shared memoryCheck shared pool size and SQL without bind variables
ORA-00600Internal errorCollect trace and open a support request
Tip: Search the exact ORA- number, for example with the oerr ora 1555 command on Linux, which prints the cause and action text.

ADRCI: The Command-Line Tool

bash adrci adrci> show homes adrci> set home diag/rdbms/free/FREE adrci> show alert -tail 50 adrci> show problem adrci> show incident

Clean Old Files

Trace files grow over time. ADR purges old files automatically, and you can also do it manually:

bash adrci> purge -age 10080 -type trace adrci> purge -age 10080 -type alert
Units: The -age value is in minutes. 10080 minutes is 7 days.

Conclusion

Check the alert log first for any problem. Use V$DIAG_INFO to find files and ADRCI to read and clean them.

Quick Summary: Alert log = Oracle's diary. V$DIAG_INFO shows the folders. ADRCI is the tool.

Get Newsletter

Subscibe to our newsletter and we will notify you about the newest updates on Edugators