==== Reference links ====
  * [[http://intermediatesql.com/oracle/oracle-11g-xml-alert-logs-surprise-they-are-actually-more-convenient-to-work-with/|Convenient access to adrci log files]]
  *  [[http://arup.blogspot.co.uk/2013/04/switching-back-to-regular-listener-log.html|Switch back to old-style listener log file - not using adr]]
  *  [[https://oracle-base.com/articles/11g/automatic-diagnostics-repository-11gr1|adrci at oracle-base.com]]
The new way to package problems and their incidents up for Oracle Support.\\
A useful way to keep the purging of trace files under control.\\
With an Oracle database environment setup, type:
<code>
adrci
</code>
To get out, type:
<code>
adrci> exit
</code>
To get help, type:
<code>
adrci> help
</code>
Show registered ORACLE_HOMEs
<code>
show home
</code>
Set one of the homes
<code>
set home diag/rdbms/orcl
</code>
tail the alert log (adrci reads the XML version of the alert log)
<code>
show alert -tail -f
</code>
Are there any problems?
<code>
show problem
</code>
Show the incident(s) of this problem
<code>
show incident -all
</code>
Show more detail about an incident
<code>
show incident -mode detail -p "incident_id=<incident number>"
</code>
Show the incident trace file for this incident
<code>
show trace /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_6201/orcl_ora_2299_i6201.trc
</code>
Package a problem up for Oracle Support
<code>
ips create package problem 1 correlate all
</code>
Zip a problem package for Oracle Support
<code>
ips generate package <package number created in previous step> in "/home/oracle"
</code>
To see current setup, type:
<code>
adrci> show control
</code>
==== Is the list of HOMEs incorrect? ====
Check the ADR Base. This is probably set wrongly. Thanks to [[http://marcel.vandewaters.nl/oracle/database-oracle/adrci-no-adr-base-is-set|this site]], we can set the ADR Base to what it should be.
<code>
echo "ORACLE_BASE: ${ORACLE_BASE}"
STORED_ADR_BASE=$(cat $ORACLE_HOME/log/diag/adrci_dir.mif)
printf "Stored ADR_BASE: %s\n" "${STORED_ADR_BASE}"
</code>
Does it show the ORACLE_BASE? If not populate it correctly with this
<code>
printf "%s" "${ORACLE_BASE}" >$ORACLE_HOME/log/diag/adrci_dir.mif
</code>
==== Purging trace and dump files in 11g with adrci ====
SHORTP_POLICY and LONGP_POLICY are number of hours to keep trace files and alert files respectively. These can be changed by typing:
<code>
set control (SHORTP_POLICY=240)
</code>
Trace files will now be deleted after 10 days.\\
If space is running low, you can manually delete trace files.\\
This deletes all trace files older than 1 day (note the age parameter is minutes, not hours).
<code>
purge -age 3600 -type trace
</code>
Show the tracefiles in reverse time order<code>show tracefile -rt
</code>
==== Use ADR command line interface from shell ====
<code>
adrci exec="show homes"
adrci exec="set home diag/tnslsnr/ravjde01/listener_ravjde1; show control"
adrci exec="set home diag/tnslsnr/ravjde01/listener_ravjde1; set control (shortp_policy=360,longp_policy=720);purge;show control;"
</code>
Show ADR homes related to databases
<code>
$ORACLE_HOME/bin/adrci exec="show homes" | grep "rdbms"
</code>
==== Shell script to purge ADR data ====
Found [[http://www.dadbm.com/oracle-database-housekeeping-methods-adr-files-purge/|here]]
<code>
  -  Purge ADR contents (adr_purge.sh)
purge_log () {
purge_min=$(( 24 * 60 * $2 ))
echo "INFO: purging $1 older than $2 days"
adrci exec="set homepath $file_line; purge -age $purge_min -type $1"
}
echo "INFO: adrci purge started at `date`"
adrci exec="show homes"|grep -v : | while read file_line
do
    echo "INFO: adrci purging diagnostic destination " $file_line
    echo "------------------"
    purge_log ALERT 365
    purge_log INCIDENT 273
    purge_log TRACE 120
    purge_log CDUMP 75
    purge_log HM 75
    echo "------------------"
done
echo "INFO: adrci purge finished at `date`
</code>
==== Create a package to send to Oracle Support ====
A problem may consist of one or more incidents.
=== Show the available adr homes ===
<code>
show home
</code>
=== Set the appropriate adr home ===
<code>
set home diag/rdbms/<db_unique_name>/<instance_name>
</code>
=== Find the problem id ===
<code>
show incident -mode detail -p "incident_id=<incident id>"
</code>
or
<code>
show problem
</code>
=== Create a package containing the latest incident for this problem ===
<code>
ips create package problem <problem id>
</code>
or
=== Create a package containing all incidents for this problem ===
<code>
ips create package problem <problem id> correlate all
</code>
=== Generate a zipped package file ===
<code>
ips generate package <package number> in "/tmp"
</code>