Creating Incident Package With ADRCI

Posted: June 12, 2014 in Database General
Tags: , ,

Recently I tried to create an incident package for Oracle support and find it very easy and convenient to use, so thought of sharing…. Basically through ADRCI we can combine all incident related files to one and send to oracle support. Apart from this it can be used for viewing diagnostic data with in automatic diagnostic repository (ADR). Diagnostic data includes incident and problem descriptions, trace files, dumps, health monitor reports, alert log entries, and more. Below are steps that I used for creating two incident packages.

First, go to adrci prompt and check the reported incidents. In my case, I have two databases GLDB & ACCDB running from same oracle home, so it will show incidents for both databases. When I tried to create package I got below error:

adrci> IPS CREATE PACKAGE INCIDENT 156129
DIA-48448: This command does not support multiple ADR homes

Reason for this is that we need to set the home right from which we need to create incident

adrci> show homes
ADR Homes:
diag/rdbms/gldb/GLDB
diag/rdbms/testdb1/TESTDB1
adrci> set home diag/rdbms/gldb/GLDB

Below is full text for commands that are used to create a package.

/u01/app/oracle/product/11.2.0.3 =>adrci

ADRCI: Release 11.2.0.3.0 - Production on Sun Mar 30 09:34:48 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

ADR base = "/u01/app/oracle/admin"
adrci>
adrci>
adrci>
adrci> show incident

ADR Home = /u01/app/oracle/admin/diag/rdbms/gldb/GLDB:
*************************************************************************
INCIDENT_ID          PROBLEM_KEY                                                 CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
108209               ORA 445                                                     2014-02-13 01:17:01.410000 +01:00
108210               ORA 445                                                     2014-02-13 12:02:03.713000 +01:00
108211               ORA 445                                                     2014-02-14 07:02:22.391000 +01:00
156129               ORA 445                                                     2014-03-30 03:02:50.743000 +02:00
156130               ORA 445                                                     2014-03-30 04:40:54.699000 +02:00
156217               ORA 445                                                     2014-03-30 05:59:43.103000 +02:00
156218               ORA 445                                                     2014-03-30 06:01:48.879000 +02:00
156219               ORA 445                                                     2014-03-30 06:03:57.081000 +02:00
156220               ORA 445                                                     2014-03-30 06:06:00.327000 +02:00
156221               ORA 445                                                     2014-03-30 06:08:03.929000 +02:00

ADR Home = /u01/app/oracle/admin/diag/rdbms/accdb/ACCDB:
*************************************************************************
INCIDENT_ID          PROBLEM_KEY                                                 CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
67665                ORA 445                                                     2014-02-13 11:49:06.173000 +01:00
67425                ORA 445                                                     2014-02-13 11:51:06.115000 +01:00
2 rows fetched

adrci> IPS CREATE PACKAGE INCIDENT 156129
DIA-48448: This command does not support multiple ADR homes

adrci> show homes
ADR Homes:
diag/rdbms/gldb/GLDB
diag/rdbms/testdb1/TESTDB1
adrci> set home diag/rdbms/gldb/GLDB
adrci> IPS CREATE PACKAGE INCIDENT 156129
Created package 1 based on incident id 156129, correlation level typical
adrci> IPS ADD INCIDENT 156129 PACKAGE 1
Added incident 156129 to package 1
adrci> IPS GENERATE PACKAGE 1 IN /u01/app/oracle/admin
Generated package 1 in file /u01/app/oracle/admin/ORA445_20140330094558_COM_1.zip, mode complete
adrci>

adrci> adrci>
adrci> IPS CREATE PACKAGE INCIDENT 156130
Created package 2 based on incident id 156130, correlation level typical
adrci> IPS ADD INCIDENT 156130 PACKAGE 2
Added incident 156130 to package 2
adrci> IPS GENERATE PACKAGE 2 IN /u01/app/oracle/admin
Generated package 2 in file /u01/app/oracle/admin/ORA445_20140330095106_COM_1.zip, mode complete
adrci> exit
/u01/app/oracle/product/11.2.0.3 =>

Once package is created it’s basically a zip file containing all the required files for the particular incident like alert.log file, trc & trm files. I just unzipped the one of the files generated from packaging incident and below is directory structure for this.

ADRCI zip file directory structure

ADRCI zip file directory structure

Also I have posted a poll to know, how many people are using this feature for oracle support. Please give your inputs on this.

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s