Automatic Diagnostic Repository (ADR)
Oracle Database Release 11g. ADRCI enables:
- Viewing diagnostic data within the Automatic Diagnostic Repository (ADR).
- Viewing Health Monitor reports.
- Packaging of incident and problem information into a zip file for transmission to Oracle Support.
ADR made up of a directory structure like the following.
/u01/app/oracle/diag/rdbms/orcl/orcl/alert
/u01/app/oracle/diag/rdbms/orcl/orcl/cdump
/u01/app/oracle/diag/rdbms/orcl/orcl/hm
/u01/app/oracle/diag/rdbms/orcl/orcl/incident
/u01/app/oracle/diag/rdbms/orcl/orcl/trace
set
linesize 121
col value format a75
SELECT *
FROM gv$diag_info;
col value format a75
SELECT *
FROM gv$diag_info;
We can display various
directories by
V$DIAG_INFO
We can set the ADR location as we wish by
diagnostic_dest
SO, we can set our environment using ADR Command Interpreter (ADRCI)
Also we can see the available
command using HELP
The nice thing is
showing ALERT by ADRCI its easier to read.
SO, if we got an error
in the alert we could see it so easy by following command…
And, if there is any
problem
We can create packages
to send ORACLE SUPPORT, but I don’t have any problem that’s why it didn’t created
any support
TO Show control
WE can also change the
retention…
