Automatic Diagnostic Repository Command Interpreter (ADRCI)
Seeing the ADRCI Homes
show home
Setting a home Patch
set home path diag/rdbms/agap/AGAP
To show
show alert -tail 200
show alert -tail -f
show incident
show incident -mode detail -P "INCIDENT_ID=16873"
show alert -P "MESSAGE_TEXT LIKE '%ORA-600%'"
show TRACEFILE -I 1681
show incident -mode brief -p "incident_id=60073"
show alert -tail -f
show incident
show incident -mode detail -P "INCIDENT_ID=16873"
show alert -P "MESSAGE_TEXT LIKE '%ORA-600%'"
show TRACEFILE -I 1681
show incident -mode brief -p "incident_id=60073"
To Purge
1440 minutes = 1 day
8640 minutes = 6 days
43200 minutes = 30 days
purge -age 1440
purge -age 8640 -type ALERT
purge -age 8640 -type INCIDENT
purge -age 8640 -type TRACE
purge -age 8640 -type CDUMP
purge -age 8640 -type HM
Shell Script to purge
[oracle@ol7-121-rac1 ADRCI]$ more adrci_purge.sh
# Purge ADR contents (adr_purge.sh)
# ALERT LOG purge setting
TYPE_ALERT=129600
TYPE_INCIDENT=43200
TYPE_TRACE=43200
TYPE_CDUMP=43200
TYPE_HM=43200
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 "INFO: purging ALERT older than $(($TYPE_ALERT/1440)) days"
adrci exec="set homepath $file_line;purge -age $TYPE_ALERT -type ALERT"
echo "INFO: purging INCIDENT older than $(($TYPE_INCIDENT/1440)) days"
adrci exec="set homepath $file_line;purge -age $TYPE_INCIDENT -type INCIDENT"
echo "INFO: purging TRACE older than $((TYPE_TRACE/1440)) days"
adrci exec="set homepath $file_line;purge -age $TYPE_TRACE -type TRACE"
echo "INFO: purging CDUMP older than $((TYPE_CDUMP/1440)) days"
adrci exec="set homepath $file_line;purge -age $TYPE_CDUM -type CDUMP"
echo "INFO: purging HM older than $((TYPE_HM/1440)) days"
adrci exec="set homepath $file_line;purge -age $TYPE_HM -type HM"
echo "INFO: adrci purge finished at `date`"
# Purge ADR contents (adr_purge.sh)
# ALERT LOG purge setting
TYPE_ALERT=129600
TYPE_INCIDENT=43200
TYPE_TRACE=43200
TYPE_CDUMP=43200
TYPE_HM=43200
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 "INFO: purging ALERT older than $(($TYPE_ALERT/1440)) days"
adrci exec="set homepath $file_line;purge -age $TYPE_ALERT -type ALERT"
echo "INFO: purging INCIDENT older than $(($TYPE_INCIDENT/1440)) days"
adrci exec="set homepath $file_line;purge -age $TYPE_INCIDENT -type INCIDENT"
echo "INFO: purging TRACE older than $((TYPE_TRACE/1440)) days"
adrci exec="set homepath $file_line;purge -age $TYPE_TRACE -type TRACE"
echo "INFO: purging CDUMP older than $((TYPE_CDUMP/1440)) days"
adrci exec="set homepath $file_line;purge -age $TYPE_CDUM -type CDUMP"
echo "INFO: purging HM older than $((TYPE_HM/1440)) days"
adrci exec="set homepath $file_line;purge -age $TYPE_HM -type HM"
echo "INFO: adrci purge finished at `date`"
Execute
sh -x adrci_purge.sh
To pack a incident or problem to send MOS
ips pack incident 60073 in /home/oracle
ips create package problem problem_ID
ips create package problem
ips create package problem 1 in /home/oracle
ips create package problemkey "ORA 7445 [qmxarFindPartition()+15]"
example
adrci>> show incident
adrci>> ips create package — this will create a logical package
adrci>> help ips
adrci>> ips add incident xxxx package 4
adrci>> ips add file <alert loc> package 4
adrci>> ips finalize package 2
adrci>> ips generate package 2 in <local folder>
example
adrci>> show incident
adrci>> ips create package — this will create a logical package
adrci>> help ips
adrci>> ips add incident xxxx package 4
adrci>> ips add file <alert loc> package 4
adrci>> ips finalize package 2
adrci>> ips generate package 2 in <local folder>
To see home directory
show parameter diagnostic_dest
col NAME format a40
col VALUE format a100
Set line 300
Set pagesize 200
select INST_ID, NAME, VALUE from v$diag_info;
adrci command examples
adrci>> show homes
adrci>> help
adrci>> help show incident
adrci>> show incident -mode basic
adrci>> show incident -mode detail -p “incident_id=14556”
adrci>> set homepath diag/rdbms/askmdb/ASKMDB11
adrci>> show alert
adrci>> show alert -tail -f
adrci>> show alert -p “module_id=’DBMS_SCHEDULER'”
adrci>> show alert -p “module_id != ‘DBMS_SCHEDULER'”
adrci>> show alert -p “module_id like ‘%SCHEDULER'”
adrci>> spool a
adrci>> show alert -tail 50
adrci>> spool off
adrci>> show alert -p “message_text like ‘%STREAM%'”
adrci>> show tracefile
adrci>> show tracefile %reco% -rt
HEALTH MONITOR
adrci> show hm_run -p “run_id=36961”
