Oracle11galert file changes

The log file of Oracle11g (somewhat changed) starts from Oracle11g. Oracle provides Alert logs in two formats: XML and traditional text. The new log location is

Oracle 11g log files (somewhat changed) Start from Oracle 11g. Oracle provides Alert logs in two formats: XML and traditional text. The new log location is

Oracle 11g log files (somewhat changed)

Starting from Oracle 11g, Oracle provides Alert logs in XML and traditional text formats.

The new log location is determined by the Automatic Diagnostic Repository (ADR. You can use the new initialization parameter DIAGNOSTIC_DEST to control the location of the adr base. If the location of the initialization parameter is not set and the ORACLE_BASE environment variable is set, ORACLE_HOME/log is DIAGNOSTIC_DEST if ORACLE_BASE is not set.

The location of the Alert Log File parent directory is:

ADR_BASE/diag/product_type {eg: rdbms}/product_id {eg: 11g}/instance_id

This directory contains subdirectories such as alert, trace, and bdump. Is the specific location of the Log. Alert is an XML file:

You can use the following command in the v $ diag_info View:

Select * from v $ diag_info where name = 'diag Alert ';

Select * from v $ diag_info where name = 'diag Trace ';

Select * from v $ diag_info;

For example:

SQL> select value from v $ diag_info where;

VALUE

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

/U01/oracle/app/diag/rdbms/orcl/alert

SQL> select value from v $ diag_info where;

VALUE

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

/U01/oracle/app/diag/rdbms/orcl/trace

SQL> select value from v $ parameter where;

VALUE

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

/U01/oracle/app/diag/rdbms/orcl/trace

SQL> show parameter DIAGNOSTIC_DEST;

NAME TYPE VALUE

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

Diagnostic_dest string/u01/oracle/app