adrci
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| adrci [2019/04/26 08:45] – stuart | adrci [2021/07/29 15:14] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ==== Reference links ==== | ==== Reference links ==== | ||
| - | * [[http:// | + | * [[http:// |
| * [[http:// | * [[http:// | ||
| * [[https:// | * [[https:// | ||
| Line 35: | Line 35: | ||
| Show the incident(s) of this problem | Show the incident(s) of this problem | ||
| < | < | ||
| - | show incident | + | show incident |
| </ | </ | ||
| Show more detail about an incident | Show more detail about an incident | ||
| Line 60: | Line 60: | ||
| Check the ADR Base. This is probably set wrongly. Thanks to [[http:// | Check the ADR Base. This is probably set wrongly. Thanks to [[http:// | ||
| < | < | ||
| - | printf " | + | echo " |
| + | STORED_ADR_BASE=$(cat $ORACLE_HOME/ | ||
| + | printf "Stored ADR_BASE: | ||
| + | </code> | ||
| + | Does it show the ORACLE_BASE? | ||
| + | < | ||
| + | printf " | ||
| </ | </ | ||
| ==== Purging trace and dump files in 11g with adrci ==== | ==== Purging trace and dump files in 11g with adrci ==== | ||
| Line 73: | Line 79: | ||
| purge -age 3600 -type trace | purge -age 3600 -type trace | ||
| </ | </ | ||
| - | Show the tracefiles in reverse time order | + | Show the tracefiles in reverse time order< |
| - | < | + | |
| - | show tracefile -rt | + | |
| </ | </ | ||
| - | |||
| ==== Use ADR command line interface from shell ==== | ==== Use ADR command line interface from shell ==== | ||
| < | < | ||
| adrci exec=" | adrci exec=" | ||
| - | adrci exec=" | + | adrci exec=" |
| - | adrci exec=" | + | adrci exec=" |
| </ | </ | ||
| Show ADR homes related to databases | Show ADR homes related to databases | ||
| Line 88: | Line 91: | ||
| $ORACLE_HOME/ | $ORACLE_HOME/ | ||
| </ | </ | ||
| - | |||
| ==== Shell script to purge ADR data ==== | ==== Shell script to purge ADR data ==== | ||
| Found [[http:// | Found [[http:// | ||
| Line 95: | Line 97: | ||
| purge_log () { | purge_log () { | ||
| purge_min=$(( 24 * 60 * $2 )) | purge_min=$(( 24 * 60 * $2 )) | ||
| - | echo “INFO: purging $1 older than $2 days” | + | echo "INFO: purging $1 older than $2 days" |
| - | adrci exec=”set homepath $file_line; | + | adrci exec="set homepath $file_line; purge -age $purge_min -type $1" |
| } | } | ||
| - | + | echo "INFO: adrci purge started at `date`" | |
| - | echo “INFO: adrci purge started at `date`” | + | adrci exec="show homes"|grep -v : | while read file_line |
| - | adrci exec=”show homes”|grep -v : | while read file_line | + | |
| do | do | ||
| - | echo “INFO: adrci purging diagnostic destination | + | |
| - | echo “——————————————————————————-” | + | echo "------------------" |
| - | purge_log ALERT 365 | + | purge_log ALERT 365 |
| - | purge_log INCIDENT 273 | + | purge_log INCIDENT 273 |
| - | purge_log TRACE 120 | + | purge_log TRACE 120 |
| - | purge_log CDUMP 75 | + | purge_log CDUMP 75 |
| - | purge_log HM 75 | + | purge_log HM 75 |
| - | echo “——————————————————————————-” | + | echo " |
| done | done | ||
| - | echo | + | echo "INFO: adrci purge finished at `date` |
| - | echo “INFO: adrci purge finished at `date`” | + | |
| </ | </ | ||
| ==== Create a package to send to Oracle Support ==== | ==== Create a package to send to Oracle Support ==== | ||
| Line 122: | Line 122: | ||
| === Set the appropriate adr home === | === Set the appropriate adr home === | ||
| < | < | ||
| - | set home diag/ | + | set home diag/ |
| </ | </ | ||
| === Find the problem id === | === Find the problem id === | ||
| Line 145: | Line 145: | ||
| ips generate package <package number> in "/ | ips generate package <package number> in "/ | ||
| </ | </ | ||
| + | |||
adrci.1556268332.txt.gz · Last modified: 2019/04/26 08:45 by stuart