11g中ADR管理下的監聽trace文件路徑問題

這些文件是什麼？打開一個，發現都是監聽sqlpuls登錄的信息，即trace文件：

那麼為什麼這個trace文件在這個路徑中？

經@Yong Huang提醒，原來這個問題和11g的ADR設置有關，下面是ADR的官方介紹：

The Automatic Diagnostic Repository (ADR) is a file-based repository for database
diagnostic data such as traces, dumps, the alert log, health monitor reports, and more.
It has a unified directory structure across multiple instances and multiple products.
Beginning with release 11g, the database, Oracle Automatic Storage Management (Oracle
ASM), and other Oracle products or components store all diagnostic data in the ADR. Each
instance of each product stores diagnostic data underneath its own ADR home directory
(see “ADR Home”). For example, in an Oracle Real Application Clusters (Oracle RAC)
environment with shared storage and Oracle ASM, each database instance and each Oracle
ASM instance has a home directory within the ADR. The ADR’s unified directory structure
enables customers and Oracle Support to correlate and analyze diagnostic data across
multiple instances and multiple products.

自動診斷庫(ADR)是一個基於文件的數據庫診斷數據存儲庫，保存了trace、dump、alert log、health監控報告等等。對於多個實例和多個產品，都有一個統一的目錄結構。11g開始，像Oracle ASM還有其他的Oracle產品或組件的診斷數據都會存儲在ADR中。每個產品實例都在他自己的ADR根目錄下存儲診斷數據。ADR統一目錄結構能讓客戶和Oracle支持將不同實例和不同產品的診斷數據關聯起來進行分析。

MOS上的這篇文章說明了sqlnet.ora配置後，trace文件如何存放的問題：

NET Client Traces Generated In $ADR_BASE/oradiag_/diag/clients/ Directory (文檔 ID 1545533.1)

大義就是如果配置了

ADR_BASE=ADR base location

則trace文件會自動存儲在如下路徑中：

$ADR_BASE/oradiag_OS user/diag/clients/..

否則就會存儲在：

$ADR_BASE/diag/clients/...