Automatic Diagnostic Repository (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.
Problem
A problem is a critical error in the database. Critical errors include internal errors such as ORA-00600
and other severe errors such as ORA-07445
(operating system exception) or ORA-04031
(out of memory in the shared pool). Problems are tracked in the ADR. Each problem has a problem key and a unique problem ID. (See "Problem Key".)
[oracle@cisdb01 ~]$ adrci -help
Syntax:
adrci [-help] [script=script_filename]
[exec = "one_command [;one_command;...]"]
Options Description (Default)
-----------------------------------------------------------------
script script file name (None)
help help on the command options (None)
exec exec a set of commands (None)
-----------------------------------------------------------------
[oracle@cisdb01 ~]$ adrci EXEC="SHOW HOMES"
ADR Homes:
diag/diagtool/user_oracle/host_3609335305_11
diag/asm/user_oracle/host_3609335305_80
diag/rdbms/prod/PROD1
diag/clients/user_oracle/host_3609335305_80
diag/asmtool/user_oracle/host_3609335305_80
[oracle@cisdb01 ~]$