Find the Oracle Alert Log

Posted by ITsiti — July 21, 2013 in ORACLE — Leave a reply

Different version of Oracle will have different locations of alert log. So, easy way to locate the Oracle alert log is by executing below command.

SQL> show parameter background

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
background_core_dump                 string      partial
background_dump_dest                 string      /oracle/SID/saptrace/diag/rdbm
                                                 s/sid/SID/trace

Look for background_dump_dest parameter value and you can get the Oracle alert log in there!

alert log location