Wednesday, March 10, 2010

ADR How to Package Diagnostic Information in 11g

$ adrci

ADRCI: Release 11.1.0.7.0 - Production on Mon Mar 8 16:35:56 2010

Copyright (c) 1982, 2007, Oracle. All rights reserved.

ADR base = "/oracle"
adrci>
adrci> show incident


ADR Home = /oracle/diag/rdbms/test/TEST01:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
656910 ORA 600 [critical problem] 2010-01-29 11:31:45.635899 +09:00
656909 ORA 600 [critical problem] 2010-01-29 11:19:30.662164 +09:00
656478 ORA 7445 [critical problem] 2010-01-25 13:21:00.086171 +09:00
656477 ORA 7445 [critical problem] 2010-01-25 13:16:54.434050 +09:00
...
20 rows fetched

ADR Home = /oracle/diag/clients/user_oracle/host_2085451943_11:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
25 oci 24550 [3] 2009-08-19 17:01:14.504278 +09:00
17 oci 24550 [3] 2009-08-19 16:59:56.250301 +09:00
9 oci 24550 [3] 2009-06-18 08:09:28.329766 +09:00
1 oci 24550 [3] 2009-06-18 08:07:58.791738 +09:00
4 rows fetched

adrci> show homepath
ADR Homes:
diag/rdbms/test/TEST01
diag/clients/user_oracle/host_2085451943_11
diag/clients/user_precise/host_2085451943_11
diag/clients/user_norad/host_2085451943_11
diag/tnslsnr/TEST01/test_TEST01
diag/tnslsnr/TEST01/listener_TEST01
diag/tnslsnr/TEST01/listener_TEST01
diag/tnslsnr/TEST01/listener
adrci> set homepath diag/rdbms/test/TEST01
adrci> ips create package incident 656910

Created package 1 based on incident id 656910, correlation level typical
adrci>
adrci> IPS GENERATE PACKAGE 1 in /oracle/diag

Generated package 1 in file /oracle/diag/ORA600critical problem_20100308163713_COM_1.zip, mode complete
adrci> exit
$ls -altr
total 12744
-rw-r--r-- 1 oracle dba 6456404 Mar 8 16:39 ORA600critical problem_20100308163713_COM_1.zip

Reference:
Note.738732.1 ADR How to Package Diagnostic Information in 11g