Architecture Oracle Automatic Diagnostic Repository (ADR) and ADRCI (ADR Command Interpreter)

General Information
Server Directory Structure
Client Directory Structure
Client Structure (OEL)	/home/oracle/oradiag_oracle/diag/clients/user_oracle/host_2309071977_76/ [oracle@perrito2 host_2309071977_76]$ ls alert cdump incident incpkg lck metadata stage sweep trace Note: "When client side OCI or NET have an incident, an ADR directory is created in the user's home and the incident and dumps are located within. The root is named oradiag_<username>. So finding this directory structure indicates some failure on the client side. The reason the ADR is created in the user's home directory and not in the Client Oracle home: permissions. I was puzzled that my db server host had this directory even though I've never installed the Client there. Dev explained that "Every DB interaction uses OCI (SQLPLUS, etc.) from a client side." Thus you use it during install, for example, often without knowing it.
Queries	set linesize 121 col value format a75 SELECT * FROM gv$diag_info;
Change the ADR Repository  Location	-- database ALTER SYSTEM SET diagnostic_dest = <new location>; -- listener Add the parameter ADR_BASE_listener=<location> to the listener.ora file
ADRCI Comands
Purpose	The ADR Command Interpreter (ADRCI) is a command-line tool that you use to manage Oracle Database diagnostic data. ADRCI is a command-line tool that is part of the fault diagnosability infrastructure introduced in 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. Diagnostic data includes incident and problem descriptions, trace files, dumps, health monitor reports, alert log entries, and more. ADRCI has a rich command set, and can be used in interactive mode or within scripts. In addition, ADRCI can execute scripts of ADRCI commands in the same way that SQL*Plus executes scripts of SQL and PL/SQL commands. ADR data is secured by operating system permissions on the ADR directories, hence there is no need to log in to ADRCI.
CREATE REPORT	create report <report_type> <report_id>
	SELECT run_id, name, check_name, run_mode, status, error_number FROM gv$hm_run; adrci> set homepath diag\rdbms\orabase\orabase adrci> create report hm_run HM_RUN_1 adrci> show report hm_run hm_run_1
ECHO	echo <ON | OFF>
	ardci> echo on ardci> echo off
EXIT	exit
	$ ardrci adrci> exit
HELP	help
	adrci> help
HOST	host
	$ ardrci adrci> host Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. -- then exits back to the command prompt
IPS CREATE PACKAGE INCIDENT	ips create package incident <incident_number> [CORRELATE <BASIC | TYPICAL | ALL>]
	adrci> ips create package incident 2
IPS CREATE PACKAGE PROBLEM	ips create package problem <problem_id> [CORRELATE <BASIC | TYPICAL | ALL>]
	adrci> ips create package problem ?
IPS CREATE PACKAGE PROBLEMKEY	ips create package problemkey <'problem_key'> [CORRELATE <BASIC | TYPICAL | ALL>] ips create package problemkey <"problem_key"> [CORRELATE <BASIC | TYPICAL | ALL>]
	adrci> ips create package problemkey '?' adrci> ips create package problemkey "?"
IPS CREATE PACKAGE SECONDS	ips create package seconds <sec> [CORRELATE <BASIC | TYPICAL | ALL>]
	adrci> ips create package seconds 600 CORRELATE ALL
IPS CREATE PACKAGE TIME	ips create package time <'start_timestamp'> TO <'end_timestamp'> [CORRELATE <BASIC | TYPICAL | ALL>]
	adrci> ips create package time '2008-01-01 00:00:00 -08:00' to '2008-01-02 23.59.59 -08:00'
IPS GENERATE PACKAGE	ips generate package
	adrci> ips generate package
IPS SHOW	ips show incidents package pkg_id
	adrci> show homes adrci> set home diag\rdbms\orabase\orabase adrci> ips show incident
IPS UNPACK	ips unpack file file_name [into path]
	adrci> ips unpack file /home/oracle/ORA603_20060906165316_COM_1.zip into /tmp/newadr
PURGE	purge [[-i {id1 | start_id end_id}] [-age mins] [-type {ALERT | INCIDENT | TRACE | CDUMP | HM}]
	adrci> purge -i 123 456 adrci> purge -age 60 -type incident
QUIT	quit
	$ ardrci adrci> quit
RUN	run script_name @ script_name @@ script_name
	-- need to create a demo script here and post it adrci> run uwadrscript
SET BASE	set base <base_path>
	adrci> set base /apps/oracle/product
SET BROWSER	set browser browser_program
	adrci> set browser firefox
SET CONTROL	set control (<SHORTP_POLICY | LONGP_POLICY> = value, ...)
	adrci> set control (SHORTP_POLICY = 360)
SET ECHO	set echo <ON | OFF>
	adrci> set echo off
SET EDITOR	set editor editor_program
	adrci> set editor vi
SET HOME	set home <home_location>
	adrci> show homes adrci> set home diag\rdbms\orabase\orabase adrci> show home
SET HOMES	set homes <home_location1>, <home_location2>, <...>
	adrci> show homes adrci> set homes diag\rdbms\orabase\orabase, diag\tnslsnr\perrito2\listener adrci> show homes
SET HOMEPATH	set homepath homepath_str1 [homepath_str2] [...]
	adrci> show homepath adrci> set homepath diag\rdbms\orabase\orabase adrci> show homepath
SET TERMOUT	termout <ON | OFF>
	adrci> set termout on adrci> set termout off
SHOW ALERT	show alert [-p predicate_string] [-tail [num] [-f]] [-term] [-file alert_file_name]
	$ adrci exec="show homes; show incident" adrci> show alert Choose the alert log from the following homes to view: 1. diag\client\user_unknown\host_411310321_11 2. diag\rdbms\orabase\orabase 3. diag\tnslsnr\perrito2\listener Q: to quit Q $ adrci adrci> set home diag\rdbms\orabase\orabase adrci> show alert adrci> show alert 25
Tail the Alert Log	-- open a terminal window adrci> show home adrci> set homepath diag\rdbms\orabase\orabase adrci> show alert -tail -f -- to verify SQL> ALTER SYSTEM SWITCH LOGFILE;
Show only lines with specific text	-- open a terminal window adrci> show home adrci> set homepath diag\rdbms\orabase\orabase adrci> show alert -P "MESSAGE_TEXT LIKE '%ORA-7445%'";
SHOW BASE	show base
	adrci> show base ADR base is "c:\oracle\product"
SHOW CONTROL	show control
	adrci> set homepath diag\rdbms\orabase\orabase adrci> show control
SHOW HM_RUN	show hm_run [-p predicate_string]
	adrci> show hm_run
SHOW HOME	show home
	adrci> show home
SHOW HOMES	show homes
	adrci> show homes
SHOW HOMEPATH	show homepath
	adrci> show homepath
SHOW INCDIR	show incdir [id | id_low id_high]
	adrci> show incdir
SHOW INCIDENT	show incident -p predicate_string [-mode {BASIC|BRIEF|DETAIL}] [-orderby field1, field2, ...] [ASC|DSC]
	adrci> show incident
SHOW PROBLEM	show problem [-p predicate_string] [-last num | -all] [-orderby field1, field2, ...] [ASC|DSC]]
	adrci> show problem
SHOW REPORT	show report report_type run_name
	-- need to define a single home conn / as sysdba SELECT run_id, name, check_name, run_mode, status, error_number FROM gv$hm_run; adrci> set homepath diag\rdbms\orabase\orabase adrci> show report hm_run hm_run_1
SET TRACEFILE	show tracefile [file1 file2 ...] [-rt | -t] [-i inc1 inc2 ...] [-path path1 path2 ...]
	adrci> show tracefile %mmon% -rt adrci> show tracefile -i 1 4 -path diag/rdbms/orabase/orabase
SPOOL	SPOOL filename [[APPEND] | [OFF]] spool file_name_and_path [<APPEND | OFF>]
	adrci> spool /home/oracle/adr.log adrci> show alert -term adrci> spool off
Demo
ADRCI Demo	SQL> conn / as sysdba SQL> desc gv$hm_run SQL> select run_id, name, check_name, run_mode, status, error_number      from gv$hm_run; With help of  http://www.morganslibrary.org/reference/adr.html