Table of Contents

Automatic Diagnostic Repository

ADRCI

When starting adrci, if you get a message saying there is no base you can set it manually

adrci> set base /u01/app/oracle
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"
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
adrci> show tracefile -rt
adrci> show tracefile %j001% -rt
adrci> show trace $ORACLE_BASE/diag/rdbms/ssoprdrp/SSOPRDRP/trace/SSOPRDRP_j001_51663.trc
adrci> show control

Parameter values for policies are in hours

adrci> set control (SHORTP_POLICY = 360)
adrci> set control (LONGP_POLICY = 2190)
adrci> purge -age 2880
adrci> purge -age 2880 -type trace

Oracle Support Documents

How To Filter ADRCI 'Show Alert' Output By Date and Time
How To Purge Listener Log.Xml File?
Automatic Diagnostic Cleanup - Auto purge
Retention Policy for ADR
Which Files Are Part Of SHORTP_POLICY And LONGP_POLICY In ADR?