Beginning with Release 11g, the alert log file is written as XML formatted and as a text file (like in previous releases). The default location of both these files is the new ADR home (Automatic Diagnostic Respository).
The ADR is set by using the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted, then, the default location of ADR is, 'u01/oracle/product/ora11g/log' depending on your ORACLE_HOME setting.
The location of an ADR home is given by the following path, which starts at the ADR base directory: ADR_BASE/diag/product_type/product_id/instance_id
If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to ORACLE_HOME/log.
Also use the script below to locate you alert file in sqlplus
SQL> select * from v$diag_info;
Within the ADR home directory are subdirectories:alert - The XML formatted alertlog
trace - files and text alert.log file
cdump - core files
The XML formatted alert.log is named as 'log.xml'
The ADR is set by using the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted, then, the default location of ADR is, 'u01/oracle/product/ora11g/log' depending on your ORACLE_HOME setting.
The location of an ADR home is given by the following path, which starts at the ADR base directory: ADR_BASE/diag/product_type/product_id/instance_id
If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to ORACLE_HOME/log.
Also use the script below to locate you alert file in sqlplus
SQL> select * from v$diag_info;
Within the ADR home directory are subdirectories:alert - The XML formatted alertlog
trace - files and text alert.log file
cdump - core files
The XML formatted alert.log is named as 'log.xml'
0 comments:
Post a Comment