Location of alert log in 11g.

SQL> select * from v$version; 

 BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production PL/SQL Release 11.1.0.7.0 - Production CORE    11.1.0.7.0      Production TNS for Linux: Version 11.1.0.7.0 - Production NLSRTL Version 11.1.0.7.0 - Production  

SQL>  show parameter background 

 NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ background_core_dump                 string      partial background_dump_dest                 string      /u01/app/oracle/diag/rdbms/PROD/PROD/trace SQL> !ls -ltr /u01/app/oracle/diag/rdbms/PROD/PROD/trace/al* -rw-r----- 1 oracle oinstall 78512424 2011-10-03 02:00 /u01/app/oracle/diag/rdbms/PROD/PROD/trace/alert_PROD.log

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

VALUE -------------------------------------------------------------------------------- 

/u01/app/oracle/diag/rdbms/orcl/orcl/trace -bash-3.2$ cd /u01/app/oracle/diag/rdbms/orcl/orcl/trace 

-bash-3.2$ ls alert_orcl.log orcl_j001_25686.trm orcl_ora_20641.trc

SQL> show parameter background_dump_dest;

By default its --> $diagnostic_dest/diag/rdbms/<db_unique_name>/<instance_name>/trace

SQL> desc v$diag_info;


Name                         Null? Type
----------------------------------------- -------- ----------------------------
INST_ID                         NUMBER
NAME                              VARCHAR2(64)
VALUE                              VARCHAR2(512)



SQL> select * from v$diag_info where name='Diag Alert';


INST_ID

1
------------------------------------------------------------------------------
NAME

Diag Alert

---------- ----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------

/u01/app/diag/rdbms/orcl/orcl/alert

----------------------------------------------------------------------------------

on bash comand line:

$ ls /u01/app/diag/rdbms/orcl/orcl/alert

result: log.xml

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

SQL> select value from v$parameter where name='diagnostic_dest'; VALUE -------------------------------------------------------------------------------- /u01/app/oracle

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

SQL> select name from v$database; NAME --------- idea

Alert log file consist alert_<SID_NAME>.log

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