Google it ....

Wednesday, February 13, 2013

Where is the location of alert log file in oracle?

We often get questions about how to find alert.log file location in oracle, it's easy to find location of alert.log file, below is two different procedures:

Here is video of these procedures - oracle location of alert log file

1) you can find alert.log location with parameter background_dump_dest.
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
This is alert.log file ----> alert_orcl.log  orcl_j001_25686.trm  orcl_ora_20641.trc

or in SQL *PLUS
SQL> show parameter background_dump_dest

2) To find the location of the diagnostic_dest, you 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_.log

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

good luck.

4 comments:

  1. NOTE : This location will be on machine where our DB is running.

    ReplyDelete
  2. Yes sure, this location is always on machine where our db is running

    ReplyDelete
  3. […] Where is the location of alert log file in oracle 11g … – Feb 13, 2013 · 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 …… […]

    ReplyDelete
  4. Log file analysis software can produce analyzes of user behaviour and of resource usage.seo log analyzer

    ReplyDelete