Oracle [abcu]dump位置設定

11g 以前:
*.audit_file_dest='/路徑/adump'
*.background_dump_dest='/路徑/bdump'
*.core_dump_dest='/路徑/cdump'
*.user_dump_dest='/路徑/udump'

11g可參考:(轉載自此)

Alert log changes in 11g

Oracle now writes two alert logs, the traditional alert log in plain text plus a new XML formatted alert.log which is named as log.xml.

Prior to Oracle 11g, the alert log resided in $ORACLE_HOME/admin/$ORACLE_SID/bdump directory, but it now resides in the $ORACLE_BASE/diag/$ORACLE_SID directory. 

Fortunately, you can re-set it to the 10g and previous location by specifying the BDUMP location for the diagnostic_dest parameter. 

But best of all, you no longer require server access to see your alert log since it is now accessible via standard SQL using the new v$diag_info view:

select name, value from v$diag_info.

For complete details, see MOSC Note:438148.1 - "Finding alert.log file in 11g".

NOTE: Rampant author Laurent Schneider has some additional insight into creating an Oracle Automatic Diagnostic Repository (ADR).