Oracle 11g Alert log File Location Problem

The alert log Changes after Oracle reaches 11 GB. The oracle database provides the Alert log in two formats: XML and traditional text.

The new log location is determined by the Automatic Diagnostic Repository (ADR) storage directory. You can control the location of the ADR base by using the letter initialization parameter DIAGNOSTIC_DEST.

SQL> show parameter diagnostic_dest;

NAME TYPE VALUE

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

Diagnostic_dest string/u01/sys_software/oracle

SQL>

If the location of the initialization parameter is not set and the ORACLE_BASE environment variable is set, $ oracle_home/log is the directory of DIAGNOSTIC_DEST.

The location of the Alert log File parent directory is:

$ ORACLE_BASE/diag/product_type/product_id/instance_id

The directory contains subdirectories such as alter, trace, and cdump.

Location of the Alert log XML file

SQL> select value from v $ diag_info where name = 'diag Alert ';

VALUE

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

/U01/sys_software/oracle/diag/rdbms/hbcadb/hbcadb1/alert

SQL>

Location of the Alert log text file

SQL> select value from v $ diag_info where name = 'diag Trace ';

VALUE

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

/U01/sys_software/oracle/diag/rdbms/hbcadb/hbcadb1/trace

SQL>

SQL>

--- The End