Oracle11gR2RAC 追踪文件出力位置不同

今天遇到一个问题，在一个新安装的Oracle database 11.2.0.1RAC环境中，ADR管理机能使用的参数设定之后发现下面的问题
diagnostic_dest=/oracle/test 01/db

1#机与2#机的追踪文件保存路径不同
1#机：
/oracle/test01/db/diag/clients/user_test01/host_XXXXXXX/trace 2#机： /oracle/test01/db/diag/clients/user_test01/host_XXXXXXX/trace.
2#机的路径比1#号多了一个点。 但它里面可以记录文件，看来是oracle的一个错误。
后来在MOS上找到了下面的文章，看来新的东西还是不稳定。 Bug 10080987: ADRCI CREATE AN INCORRECT DIRECTORY OUTPUT PATH IN TRACE FILEPROBLEM:
--------
PROBLEM:
--------
ADRCI is pointing at incorrect directory path of the trace file.

Why is ADRCI pointing at incorrect directory path of the trace file
instead of a correct physical directory path?

/home1/ora11107/app/ora11107/diag/rdbms/ora11107/ora11107/trace/ora_6886_18293
8117920.trc
---
path of
/home1/ora11107/app/ora11107/diag/diagtool/user_ora11107/host_4287450133_11/tr
ace.

DIAGNOSTIC ANALYSIS:
--------------------
I investigated this issue using testcase.

/home1/ora11107/app/ora11107/diag/diagtool/user_ora11107/host_4287450133_11/tr
ace
path
/home1/ora11107/app/ora11107/diag/diagtool/user_ora11107/host_4287450133_11/tr
ace
/home1/ora11107/app/ora11107/diag/rdbms/ora11107/ora11107/trace/ora_6886_18293
8
---
/home1/ora11107/app/ora11107/diag/rdbms/o
/home1/ora11107/app/ora

WORKAROUND:
-----------
none

RELATED BUGS:
-------------

REPRODUCIBILITY:
----------------
100% (both In-house and Ct' site)
Rep?     Platform               RDBMS Ver.
-------  ---------------------  ----------
Y(100%)  226 Linux x86-64       11.1.0.7
Y(100%)  226 Linux x86-64       11.2.0.1

TEST CASE:
----------
1.Setting both TRACE_LEVEL_CLIENT and ADR_BASE parameter in sqlnet.ora

2. Run adrci command named "show base -product client"
adrci
show base -product client

只好按着MOS的要求将数据库升级到11.2.0.3，才解决这个问题。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26552866/viewspace-721848/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26552866/viewspace-721848/