===== Automatic Diagnostic Repository =====
==== ADRCI ====
When starting adrci, if you get a message saying there is no base you can set it manually
<code>adrci> set base /u01/app/oracle</code>

<code>adrci> show homes
adrci> set homepath .....
adrci> show alert -tail -f
adrci> show alert -p "message_text like '%ORA-%'"
adrci> show alert -p "ORIGINATING_TIMESTAMP > systimestamp -1/24"</code>

<code>adrci> show incident
INCIDENT_ID          PROBLEM_KEY                                                 CREATE_TIME
-------------------- ----------------------------------------------------------- ---------------------------------
9675                 ORA 700 [kskvmstatact: excessive swapping observed]         2015-07-16 22:05:37.616000 +01:00

adrci> show problem
PROBLEM_ID           PROBLEM_KEY                                                 LAST_INCIDENT        
-------------------- ----------------------------------------------------------- ------------------ 
1                    ORA 700 [kskvmstatact: excessive swapping observed]         9675               

adrci> show incident -mode detail -p "incident_id=9675"

adrci> ips create package problem 1 correlate all
Created package 1 based on problem id 1, correlation level all
adrci> ips generate package 1 in "/home/oracle"
Generated package 1 in file /home/oracle/ORA700ksk_20150722100606_COM_1.zip, mode complete</code>

<code>adrci> show tracefile -rt
adrci> show tracefile %j001% -rt
adrci> show trace $ORACLE_BASE/diag/rdbms/ssoprdrp/SSOPRDRP/trace/SSOPRDRP_j001_51663.trc</code>

<code>adrci> show control</code>
Parameter values for policies are in hours
<code>adrci> set control (SHORTP_POLICY = 360)
adrci> set control (LONGP_POLICY = 2190)
adrci> purge -age 2880
adrci> purge -age 2880 -type trace</code>

==== Oracle Support Documents ====
[[https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1221773.1|How To Filter ADRCI 'Show Alert' Output By Date and Time]]\\ 
[[https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=816871.1|How To Purge Listener Log.Xml File?]]\\
[[https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1196437.1|Automatic Diagnostic Cleanup - Auto purge]]\\
[[https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=564269.1|Retention Policy for ADR]]\\
[[https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=975448.1|Which Files Are Part Of SHORTP_POLICY And LONGP_POLICY In ADR?]]