最近安装个11g rac，准备学习下。
想看一下log日志，找了半天才找到，原来11g的alert log 做了变动，从 Oracle 11g 开始，oracle以xml和文本两种格式提供Alert 日志。
日志位置由Automatic Diagnostic Repository (ADR) 决定，并提供ADRCI Command-Line Utility 命令行工具
可以通过新的初始化参数 DIAGNOSTIC_DEST 控制 ADR BASE 的位置，注：一个存放数据库诊断日志、跟踪文件的目录，称作ADR base，对应初始化参数DIAGNOSTIC_DEST，如果设置了ORACLE_BASE环境变量， DIAGNOSTIC_DEST等于ORACLE_BASE，如果没有设置ORACLE_BASE，则等与ORACLE_HOME/log
SQL> show parameter dia
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ diagnostic_dest string /u01/app/oracle
SQL> select * from v$diag_info;
INST_ID NAME VALUE ---------- ------------------------- ------------------------------------------------------------------------------------------ 2 Diag Enabled TRUE 2 ADR Base /u01/app/oracle 2 ADR Home /u01/app/oracle/diag/rdbms/sykdb/sykdb2 2 Diag Trace /u01/app/oracle/diag/rdbms/sykdb/sykdb2/trace 2 Diag Alert /u01/app/oracle/diag/rdbms/sykdb/sykdb2/alert 2 Diag Incident /u01/app/oracle/diag/rdbms/sykdb/sykdb2/incident 2 Diag Cdump /u01/app/oracle/diag/rdbms/sykdb/sykdb2/cdump 2 Health Monitor /u01/app/oracle/diag/rdbms/sykdb/sykdb2/hm 2 Default Trace File /u01/app/oracle/diag/rdbms/sykdb/sykdb2/trace/sykdb2_ora_10081.trc 2 Active Problem Count 0 2 Active Incident Count 0
11 rows selected.
SQL>
命令行工具adrci
[oracle@syk1 ~]$ adrci
ADRCI: Release 11.2.0.1.0 - Production on Wed May 2 16:33:23 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/oracle" adrci> help