How to Find the Alert Log Location in Oracle Database

 Introduction

The Oracle alert log is one of the most important files for DBAs. It records major database events, startup/shutdown messages, errors, and background process information. Knowing where to find it is essential for troubleshooting.

1. Using SQL

Run this query:

SHOW PARAMETER background_dump_dest;

👉 In older versions, this parameter shows the location of the alert log.

2. Using ADRCI (for 11g and later)

Run:

adrci

Then inside ADRCI:

show alert

👉 This directly displays the alert log.

3. Default Location Example

On Linux, the alert log is usually found under:

$ORACLE_BASE/diag/rdbms/<DB_NAME>/<SID>/trace/alert_<SID>.log

Conclusion

The alert log is your first stop when troubleshooting Oracle issues. Whether using SQL, ADRCI, or direct file navigation, always monitor this file for errors and warnings.