ADR command line interpreter(ADRCI)
ADRCI enables you to:
- View diagnostic data within the Automatic Diagnostic Repository (ADR).
- View Health Monitor reports.
- Package incident and problem information into a zip file for transmission to Oracle Support.
Diagnostic data includes incident and problem descriptions, trace files, dumps, health monitor reports, alert log entries, and more.
Directory Structure
defaults to $ORACLE_BASE
- /ora01/oracle/diag
· asm/db/instance/….
· tnslsnr/host/listener_name/….
· Rdbms/db/instance/……
Parameters which controls the location of alert log entries, trace dumps, incident, problems, dumps and more
· ASM – diagnostic_dest
· listener.ora - ADR_BASE_LISTENER
· sqlnet.ora - ADR_BASE
· database
o diagnostic_dest
o audit_file_dest defaults to $ORACLE_BASE/admin/adump
o DATA_PUMP_DIR defaults to $ORACLE_BASE/admin/dpdump
Database Directory structure
/ora01/oracle/diag
/rdbms
/demo
/demo
Alert - Location of XML alert log file
cdump – Location of core dump
hm - Health Monitor
incident - Diag Incident
incpkg
ir
lck
metadata
metadata_dgif
metadata_pv
stage
sweep
trace - Default Trace File
Check directory structure in a database
sqlplus / as SYSDBA
show parameter diagnostic_dest
show parameter audit_file_dest
select * from dba_directories;
sql> SELECT name,value FROM v$diag_info
NAME VALUE
------------------------------ --------------------------------------------------
Diag Enabled TRUE
ADR Base /ora01/oracle
ADR Home /ora01/oracle/diag/rdbms/demo/demo
Diag Trace /ora01/oracle/diag/rdbms/demo/demo/trace
Diag Alert /ora01/oracle/diag/rdbms/demo/demo/alert
Diag Incident /ora01/oracle/diag/rdbms/demo/demo/incident
Diag Cdump /ora01/oracle/diag/rdbms/demo/demo/cdump
Health Monitor /ora01/oracle/diag/rdbms/demo/demo/hm
Default Trace File /ora01/oracle/diag/rdbms/demo/demo/trace/
Active Problem Count 0
Active Incident Count 0
Useful links
