Oracle11g中trace文件和日志文件的路径发生了变化在$ORACLE_BASE/diag建立了一些分类目录，用来保存各种日志：
[oracle@rac1 trace]$ cd $ORACLE_BASE
[oracle@rac1 oracle]$ cd diag
[oracle@rac1 diag]$ pwd
/u01/app/oracle/diag
[oracle@rac1 diag]$ ls
asm clients crs diagtool lsnrctl netcman ofm rdbms tnslsnr
[oracle@rac1 diag]$
其中rdbms保存了用户trace文件，alertSID.ORA、后台进程日志等。
可以通过v$diag_info查询这些信息：
SQL> select * from v$diag_info;
INST_ID NAME VALUE
---------- ---------------------------------------- ------------------------------------------------------------------
1 Diag Enabled TRUE
1 ADR Base /u01/app/oracle
1 ADR Home /u01/app/oracle/diag/rdbms/orcl/orcl1
1 Diag Trace /u01/app/oracle/diag/rdbms/orcl/orcl1/trace
1 Diag Alert /u01/app/oracle/diag/rdbms/orcl/orcl1/alert
1 Diag Incident /u01/app/oracle/diag/rdbms/orcl/orcl1/incident
1 Diag Cdump /u01/app/oracle/diag/rdbms/orcl/orcl1/cdump
1 Health Monitor /u01/app/oracle/diag/rdbms/orcl/orcl1/hm
1 Default Trace File /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_22010.trc
1 Active Problem Count 1
1 Active Incident Count 33
11 rows selected.
SQL>
[@more@]来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7839206/viewspace-1007390/ ，如需转载，请注明出处，否则将追究法律责任。
