ORACLE alert path

Before ORACLE 11G, check alert file path: show parameter background_dump_dest;

Example:

SQL> show parameter background_dump_dest;

 

NAME                                                 TYPE        VALUE

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

background_dump_dest                 string      /u01/app/oracle/admin/orcl6410g/bdump

 

After ORACLE 11G, check alert file path:

1. show parameter diagnostic_dest;

2. select name,value from v$diag_info;