Tuesday, January 31, 2012

Where is the location of alert log file in oracle 11g ?

I got many question about this. its nothing different from oracle 10g.
just show the value of "background_dump_dest"


example:-


SQL>
SQL>
SQL> select * from v$version ;

BANNER
--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

SQL>
SQL>
SQL> show parameter background_dump_dest

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest string g:\oracle11gr2\app\administrat
or\diag\rdbms\halimdb1g\halimd
b1g\trace
SQL>


so i will get my alert log in this loacation.

g:\oracle11gr2\app\administrator\diag\rdbms\halimdb1g\halimd b1g\trace