Alert Log file location in Oracle

I will explain Alert Log file locations in Oracle in this post.

 Alert log file is most important log file for Oracle DBAs, because this file includes chronological log of messages and errors of Oracle database like startup, shutdown, log switches, partition add , session kill and etc.

 

You can learn the Alert log file location of Oracle instance using the following query.

SQL> select value from GV$DIAG_INFO WHERE name='Diag Trace';

VALUE
------------------------------------------------------------------

/u01/app/oracle/diag/rdbms/msdb/msdb2/trace
/u01/app/oracle/diag/rdbms/msdb/msdb1/trace

SQL>

 

My database is cluster and it has 2 nodes, so you saw two location for 2 instances.