[EN] 8 Quick Steps of IPS via ADRCI

----------- STEP 1 ------------------

[ASOS3]/u01/app/oracle/admin/asos3/bdump $ adrci

ADRCI: Release 11.2.0.3.0 - Production on Fri Mar 23 10:13:47 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/oracle"

----------- STEP 2 ------------------

adrci> show home

ADR Homes:
diag/rdbms/asos/ASOS3
...
...

----------- STEP 3 ------------------



adrci> set homepath diag/rdbms/asos/ASOS3

----------- STEP 4 ------------------

adrci> show homepath

ADR Homes:
diag/rdbms/asos/ASOS3

----------- STEP 5 ------------------

adrci> show problem

ADR Home = /u01/app/oracle/diag/rdbms/asos/ASOS3:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
1 ORA 600 [17090] 96642 2011-04-26 16:52:14.998000 +03:00
5 ORA 600 [ORA-00600: dahili hata kodu, bağımsız değişkenler: 697082 2011-08-01 03:32:18.857000 +03:00
4 ORA 600 [15800] 720367 2011-08-01 13:31:23.085000 +03:00
2 ORA 7445 [insdlMerge()+845] 745261 2011-08-03 16:31:49.396000 +03:00
6 ORA 603 793270 2011-08-16 11:15:19.425000 +03:00
7 ORA 600 [ORA-00600: internal error code, arguments: [kdzt_a 889358 2011-08-23 13:52:37.311000 +03:00
8 ORA 600 [kdzt_acmp_predeval invalid pcode] 888574 2011-08-24 10:45:42.297000 +03:00
12 ORA 240 912279 2011-08-29 12:32:10.691000 +03:00
13 ORA 29771 912264 2011-08-29 12:36:17.001000 +03:00
11 ORA 445 913255 2011-08-29 12:46:09.489000 +03:00
14 ORA 7445 [kfk_io_wrcchk()+21] 937408 2011-08-29 13:30:37.350000 +03:00
9 ORA 600 [qkkGrow1] 1057475 2011-09-23 16:21:16.114000 +03:00
16 ORA 7445 [kfioRqSetComplete()+34] 1130052 2011-09-24 07:11:35.006000 +03:00
17 ORA 29770 1368394 2011-10-26 09:17:13.698000 +03:00
15 ORA 4031 1513483 2011-11-27 08:44:25.917000 +02:00
18 ORA 600 [ktspfpblk:clsviol_kcbgcur_9] 1536676 2011-12-05 06:15:04.478000 +02:00
19 ORA 600 [kcbnew_2] 1536692 2011-12-06 09:11:40.590000 +02:00
10 ORA 32701 1656352 2011-12-29 14:37:19.031000 +02:00
20 ORA 600 [723] 1728263 2012-02-22 15:27:30.175000 +02:00
3 ORA 1578 1945871 2012-03-20 21:27:14.670000 +02:00
21 ORA 600 [kdzhcl: cusize greater than expected size] 1968564 2012-03-22 17:38:06.284000 +02:00
23 ORA 600 [kd9addSEUndo] 1968620 2012-03-22 19:52:28.537000 +02:00
22 ORA 7445 [kfkrqDump()+30] 1968621 2012-03-22 19:53:05.956000 +02:00
24 ORA 600 [ORA-00600: internal error code, arguments: [15800] 1969604 2012-03-22 21:38:44.151000 +02:00
24 rows fetched

----------- STEP 6 ------------------

adrci> show incident -p "problem_key='ORA 7445 [kfkrqDump()+30]'"

ADR Home = /u01/app/oracle/diag/rdbms/asos/ASOS3:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
1968621 ORA 7445 [kfkrqDump()+30] 2012-03-22 19:53:05.956000 +02:00
1 rows fetched

----------- STEP 7 ------------------

adrci> ips pack incident 1968621 in /u01/app/oracle/admin

Generated package 6 in file /u01/app/oracle/admin/ORA7445kf_20120323092515_COM_1.zip, mode complete

-- or
-- ips pack problem 100 in /tmp (Packs trace files of problem with id 100)
-- ips pack incident 6439 in /tmp (Packs trace files of incident with incident id 6439)
-- ips pack problemkey "ORA 1578" (Packs trace files of problem with Problem Key 'ORA 1578')
-- ips pack seconds 120 (Packs trace files of all incidents which occured in last 120 seconds)
-- ips pack time '2007-05-01 10:00:00.00' to '2007-05-01 23:00:00.00' (Packs trace files of all incidents within the given time period)

----------- STEP 8 ------------------

adrci> exit