Oracle 11g Alert Log File Location Problem

I played Oracle 11g. It was a bit problematic. I wanted to check the log and found it for half a day. The original 11g Alert Log was changed, starting from Oracle 11g, oracle Database provides alert logs in two formats: XML and traditional text.

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.

SQL> show parameter diagnostic_dest

Name type value

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

Diagnostic_dest string D:/APP/Administrator

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.

Some log lists in this directory:

D:/APP/Administrator/diag> dir

2010/05/21 21:00 <dir> ASM

2010/05/27 16: 55 <dir> clients

2010/05/21 21:00 <dir> CRS

2010/05/21 21:00 <dir> diagtool

2010/05/21 21:00 <dir> LSNRCTL

2010/05/21 21:00 <dir> netcman

2010/05/21 21:00 <dir> ofm

2010/06/07 13:56 <dir> RDBMS

2010/05/21 21:00 <dir> tnslsnr

0 files, 0 bytes

21,367,534,592 available bytes in 11 Directories

The location of the Alert Log File parent directory is:

Adr_base/diag/product_type/product_id/instance_id

This directory contains subdirectories such as alert, trace, and bdump.

Alert Log XML file location:

SQL> select value from V $ diag_info where name = 'diag alert ';

Value

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

D:/APP/Administrator/diag/rdbms/mynewccs/Alert

Alert Log text file location:

SQL> select value from V $ diag_info where name = 'diag trace ';

Value

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

D:/APP/Administrator/diag/rdbms/mynewccs/Trace

------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
Online Resources: http://tianlesoftware.download.csdn.net
Video: http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Dba1 group: 62697716 (full); dba2 group: 62697977