Where is the location of alert log file in oracle 11g ?

Posted: July 28, 2014 in Uncategorized

This is very useful information when you have multiple databases residing on one server.

This site moved to dbacatalog.blogspot.com

We got questions about this, this is very easy to see location of this file.

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

VALUE
--------------------------------------------------------------------------------
/u0/app/oracle/diag/rdbms/orcl/orcl/trace

-bash-3.2$ cd /u0/app/oracle/diag/rdbms/orcl/orcl/trace
-bash-3.2$ ls
alert_orcl.log       orcl_j001_25686.trm  orcl_ora_20641.trc

or in SQL *PLUS

SQL> show parameter background_dump_dest

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

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

VALUE
--------------------------------------------------------------------------------
/u0/app/oracle

To know the current ORACLE_SID, you can use following select:

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
ORCL

Alert log file consist alert_<SID_NAME>.log

Therefore my alert log file is : /u0/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log

good luck.

View original post

Advertisements
Comments
  1. aitor says:

    Sometimes, the database is off and we need to find the alert log.

    in unix/linux environments:
    find / -name alert*log -mtime -1/12

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s