oracle 10g 核心日志的位置默认位于admin/bdump 下alter_sid.ora,但是oracle11g呢?看了一下admin下面只有adump dpdump没有bdump
查询文档发现
-
SQL> select value from v$diag_info where name ='Diag Alert';
-
-
-
select value from v$diag_info where name ='Diag Trace';
-
VALUE
-
--------------------------------------------------------------------------------
-
/opt/u01/app/oracle/diag/rdbms/cwt/cwt/alert
其实就是在diag/rdbms/sid下面的
-
/opt/u01/app/oracle/diag/rdbms/cwt/cwt/alert 这个文件只有xml
-
[oracle@rhel6-5 ~]$ sqlplus "/as sysdba"
-
-
SQL*Plus: Release 11.2.0.4.0 Production on Wed May 21 21:12:51 2014
-
-
Copyright (c) 1982, 2013, Oracle. All rights reserved.
-
-
-
Connected to:
-
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
-
With the Partitioning, OLAP, Data Mining and Real Application Testing options
-
-
SQL> select value from v$diag_info where name ='Diag Trace';
-
-
VALUE
-
--------------------------------------------------------------------------------
-
/opt/u01/app/oracle/diag/rdbms/cwt/cwt/trace
/opt/u01/app/oracle/diag/rdbms/cwt/cwt/trace 这个目录下面就是原来的bdump目录。
阅读(4660) | 评论(0) | 转发(0) |