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
Everything Changes
2 weeks ago