Monthly Archives: November 2014

Oracle database – location of alert log

You can run the below sql command to find the alert log location of your database instance:

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


[oracle@oracle trace]$ ls
alert_orcl.log       orcl_arc2_6924.trc  orcl_cjq0_4073.trc  orcl_dbw0_4004.trc   orcl_j001_3624.trc

or run the below sql command:

SQL> show parameter background_dump_dest

NAME                                 TYPE        VALUE
———————————— ———– ——————————
background_dump_dest                 string      /u01/app/oracle/diag/rdbms/orcl/orcl/trace


Leave a comment

Filed under Oracle