Creation of Packages & ZIP files to send to Oracle Support using ADRCI
For instance, we found problem in Database with Problem ID 1.
adrci> show problem
ADR Home = /u01/app/oracle/diag/rdbms/orcl/orcl:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
1 ORA 7445 [qcstda()+702] 6201 2011-06-01 10:22:08.924000 +02:00
1 rows fetched
Now, if you can't solve this problem on your own and you need to claim support from Oracle. You can gather all the required information with a method called “Incident Packaging Service” (IPS).
adrci> ips create package problem 1 correlate all
Created package 2 based on problem id 1, correlation level all
This did not yet create a ZIP file and is therefore referred to as “Logical Package”. The ZIP file is generated from the Logical Package that was created.
adrci> ips generate package 2 in "/home/oracle"
Generated package 2 in file /home/oracle/ORA7445qc_20110601112533_COM_1.zip, mode complete
Thanks
A Rahim Khan