ADRCI (Automatic Diagnostic Repository Command Interpreter) in Oracle 19c Lab Exercise

 Hi All,

In this post i am going to share about ADRCI useful Handson Lab exercise. 

ADRCI (Automatic Diagnostic Repository Command Interpreter) in Oracle  19c a command-line tool used to investigate database problems, view health checks and manage diagnostic data , It is primarily used to troubleshoot database errors, read alert logs, and package incident data for Oracle Support.

ensure this $ORACLE_HOME/bin should added in your OS path.

Connect to ADRCI prompt:

set home if you are using multiple homes in same server .

if you want to set the new home >> set homepath <newhomepath>

check the alert log for all database , listener , tns and other alerts on database use below command

give 1 option to check database alert log, 4 option for listener logs .... Q for quit .

if you are not given any option it will gives an error .. 

if you want to see specific home set the homepath then use commands ..

how to delete the old alert or trace .. ?

purge -age 600 -type ALERT ( it will purge older than 600 minutes )

LONGP_POLICY is used to purge below data . Default value is 365 days.

>> ALERT ,INCIDENT, SWEEP etc .

SHORTP_POLICY is used to purge for below data Default value is 30 days.

>> TRACE , CDUMP  etc ..

ADRCI >> Control policy 

if you want to set custom policies :

i have reduced shortp_policy from 720 t0 240 

adrci>  set control (LONGP_POLICY = 8760)

adrci> set control (SHORTP_POLICY = 720)

adrci>

check the incident and create package using adrci

pack all incident with in the specific time frame :

adrci> ips pack time '2026-05-20 12:00:00.00' to '2026-05-21 13:00:00.00'

 

check the package details - all package details 

specific package details :

How to Delete the complete package using adrci 

adrci> ips delete package 2

how to Remove incidents from the packages using adrci 

adrci > ips remove incident 2 package 1

How to Remove the problem keys from packages using adrci 

adrci > ips remove problem 4 package 3

Thanks,

Srini