oracle11g ADR Location

Transferred from: http://blog.itpub.net/26110315/viewspace-717853/

All diagnostic data, including alert log, is stored under ADR base starting from oracle11g. The location is specified and identified by the initialization parameter diagnostic_dest, and the initialization parameter background_dump_dest,user_dump_dest is deprecated.

Sql> Show Parameter Diagnostic_dest

NAME TYPE VALUE

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

Diagnostic_dest string/opt/oracle11g

Sql> Show Parameter Background_dump_dest

NAME TYPE VALUE

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

Background_dump_dest String/opt/oracle11g/diag/rdbms/orac

L/oracl/trace

Sql> Show Parameter User_dump_dest

NAME TYPE VALUE

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

User_dump_dest String/opt/oracle11g/diag/rdbms/orac

L/oracl/trace

Oracle retains these parameters as long as backwards compatibility is considered, but these parameters are no longer working.

The path to the trace files that Background_dump_dest used to specify and identify the Oracle background process before oracle11g. User_dump_dest the path to the trace files file used to specify and identify the user process.

If the Diagnostic_dest initialization parameter is not set, the ADR base will be set as follows:

1, if the environment variable oracle_base is set, Diagnostic_dest is set to oracle_base specified value.

2, if not set Oracle_base, Diagnostic_dest will be set to Oracle_home/log.

View all the important ADR locations for the current DB instance by querying the dynamic performance view V$diag_info.

Sql> select * from V$diag_info;

inst_id NAME VALUE

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

1 Diag Enabled TRUE

1 ADR base/opt/oracle11g

1 ADR Home/opt/oracle11g/diag/rdbms

/oracl/oracl

1 Diag Trace/opt/oracle11g/diag/rdbms

/oracl/oracl/trace

1 Diag Alert/opt/oracle11g/diag/rdbms

/oracl/oracl/alert

inst_id NAME VALUE

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

1 Diag Incident/opt/oracle11g/diag/rdbms

/oracl/oracl/incident

1 Diag Cdump/opt/oracle11g/diag/rdbms

/oracl/oracl/cdump

1 Health Monitor/opt/oracle11g/diag/rdbms

/oracl/oracl/hm

1 Default Trace F/opt/oracle11g/diag/rdbms

Ile/oracl/oracl/trace/oracl_

inst_id NAME VALUE

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

Ora_2490.trc

1 Active Problem 0

Count

1 Active Incident 0

Count

oracle11g ADR Location