Knowledge Base

Location of alert.log file

The alert.log file contain messages related to the startup and running of a specific database.

The name of the alert.log file is:


on Windows, or


On Unix/Linux

The alert.log file normally is in the $ORACLE_BASE/<ORACLE_SID>/bdump location, or since Oracle 11g in the database specific location in the diagnostic_dest.

If the database is running, you can issue following select to be able to identify the location of the background_dump_dest:

SQL> select value from v$parameter where name='background_dump_dest';


To find the location of the diagnostic_dest, one can use the following select:

SQL> select value from v$parameter where name='diagnostic_dest';


In order to know the current ORACLE_SID, you can use following select:

SQL> select name from v$database;


In our example, because we are on Linux, the name of the alert.log file will be:

If the alert.log file is not in any of these locations, or the parameters are not set, the alert.log file will be in your %ORACLE_HOME/rdbms/trace directory.

Leave a Reply

You must be logged in to post a comment.

Oracle Gold Partner DbMotive is an Oracle Silver Partner