Location of log files in Oracle 11g

Log Location

• Foreground process traces: $ADR_HOME/trace
• Background process traces : $ADR_HOME/trace
• Alert Log data : $ADR_HOME/alert and trace
• Core dumps: $ADR_HOME/cdump
• Incident dumps : $ADR_HOME/incident/incdir_n

• ADR_ROOT or ADR_BASE is set to $DIAGNOSTIC_DEST initialization parameter. If this parameter is not set, the database sets $DIAGNOSTIC_DEST to $ORACLE_BASE if this variable is set. Else it sets it to $ORACLE_HOME/log

• ADR_HOME for database is set to ADR_ROOT/diag/rdbms/DB_NAME/ORACLE_SID

• You can find out the location of all ADR variables by following sql query
• sql > select * from V$DIAG_INFO ;