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’;

VALUE
——————————————————————————–
/u01/app/oracle/diag/rdbms/orcl/orcl/trace

[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

Advertisements

Leave a comment

Filed under Oracle

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