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.
| Row in V$DIAG_INFO | Meaning |
|---|---|
| ADR Base | Root folder of diagnostics |
| Diag Trace | Folder with alert log and trace files |
| Diag Alert | Alert log in XML format |
| Default Trace File | Trace file of your own session |
Read the Alert Log
Understand ORA- Errors
| Error | Meaning | Usual fix |
|---|---|---|
| ORA-01017 | Invalid username or password | Check credentials |
| ORA-12541 | No listener | Start the listener, check host and port |
| ORA-01555 | Snapshot too old | Increase undo retention, tune long queries |
| ORA-01653 | Cannot extend table: tablespace full | Add space to the tablespace |
| ORA-00060 | Deadlock detected | Fix application locking order |
| ORA-04031 | Cannot allocate shared memory | Check shared pool size and SQL without bind variables |
| ORA-00600 | Internal error | Collect trace and open a support request |
oerr ora 1555 command on Linux, which prints the cause and action text.
ADRCI: The Command-Line Tool
Clean Old Files
Trace files grow over time. ADR purges old files automatically, and you can also do it manually:
-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.

