step 1
adrci> show alert -p "message_text like '%incident%'"
ADR Home = /oramisc01/oracle/diag/rdbms/demoprim/demo1:
*************************************************************************
Output the results to file: /ora01/oracle/temp/alert_33812_140499732489984_demo_1.ado
step 2
adrci> show problem
ADR Home = /oramisc01/oracle/diag/rdbms/demoprim/demo1:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
1 ORA 600 [ktbdchk1: bad dscn] 80396 2018-08-19 16:39:16.523000 -04:00
1 rows fetched
step 3
adrci> show incident
ADR Home = /oramisc01/oracle/diag/rdbms/demoprim/demo1:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
80393 ORA 600 [ktbdchk1: bad dscn] 2018-08-19 16:38:39.543000 -04:00
80394 ORA 600 [ktbdchk1: bad dscn] 2018-08-19 16:39:14.585000 -04:00
80395 ORA 600 [ktbdchk1: bad dscn] 2018-08-19 16:39:15.629000 -04:00
80396 ORA 600 [ktbdchk1: bad dscn] 2018-08-19 16:39:16.523000 -04:00
4 rows fetched
step 4
show incident -mode detail -p "incident_id=80393"
step 5
First, create the package using the problem ID displayed by the SHOW PROBLEM command.
adrci > ips create package problem 1 correlate all
step 6
Next, create a zip to send to Oracle Support by specifying the package number displayed by the above command.
adrci > ips generate package 1 in "/tmp"
step 6
send the zip file to oracle
