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/, mode complete

A Rahim Khan

    • Francisco
    • August 11th, 2012

    Hi Rahim,
    i try to use adrci, but when i try to pack the incident i received this message
    adrci> IPS PACK PROBLEM 2 in /tmp
    sh: zip: not found.
    DIA-49450: Non-zero return code from archiving utility [0] [32512]

    do you have any idea?

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: