ADR Different Methods to Create IPS Package (文档 ID 411.1)

郑全

Applies to:   Oracle Database - Enterprise Edition - Version 11.1.0.6 to 12.1.0.2 [Release 11.1 to 12.1]
Oracle Database - Standard Edition - Version 11.1.0.6 to 12.1.0.2 [Release 11.1 to 12.1]
Information in this document applies to any platform.

Oracle has introduced several new Diagnosability features in 11g. One of them is Incident Packaging Service (IPS). IPS uses rules to correlate all relevant dumps and traces from ADR for a given problem and allows you to package them to ship to Oracle Support.

Refer to the Document 443529.1 for the quick steps to create package.

You can access IPS through EM or ADRCI.

This document provides instructions to create package using different methods.
SolutionInvoke adrci and set ADR_HOME.
You can create a logical package based on an incident number, a problem number, a problem key, or a time interval. Create a logical package such that it will be most useful to diagnose the error of your concern.

(*) Following are the different methods using which a package can be created :

1) Creating package based on incident
Select correct incident if there are many incidents.


adrci>SHOW INCIDENT
adrci>IPS CREATE PACKAGE INCIDENT incident_number


2) Creating Empty package


adrci>IPS CREATE PACKAGE

This creates an empty package. You must use the IPS ADD INCIDENT or IPS ADD FILE commands to add diagnostic data to the package before generating it.

3) Creating package based on problem ID


adrci>IPS CREATE PACKAGE PROBLEM problem_ID

This creates a package and includes diagnostic information for incidents that reference the specified
problem ID. (Problem IDs are integers.) You can obtain the problem ID for an incident from the
report displayed by the SHOW INCIDENT -MODE BRIEF command. Because there can be many incidents with the same problem ID, ADRCI adds to the package the diagnostic information for the first three incidents ("early incidents") that occurred and last three incidents ("late incidents") that
occurred with this problem ID, excluding any incidents that are older than 90 days.

4) Creating package based on problem key


adrci>IPS CREATE PACKAGE PROBLEMKEY "problem_key"

The problem key must be enclosed in single quotes (') or double quotes (") if it contains spaces or quotes.

5) Creating package based on time interval

This creates a package and includes diagnostic information for all incidents that occurred from sec
seconds ago until now. sec must be an integer.


adrci>IPS CREATE PACKAGE SECONDS sec
adrci>IPS CREATE PACKAGE TIME 'start_time' TO 'end_time'

This creates a package and includes diagnostic information for all incidents that occurred within the
specified time range. start_time and end_time must be in the format 'YYYY-MM-DD HH24:MI:SS.FF TZR'.
This is a valid string for the NLS_TIMESTAMP_TZ_FORMAT initialization parameter. The fraction (FF) portion of the time is optional, and the HH24:MI:SS delimiters can be colons or periods.


(**) Following are the different methods using which a package can be altered or physically packaged :


A. Adding Incidents and files to the logical package :

You can add more files or more incidents to the package.


adrci>IPS ADD INCIDENT incident_number PACKAGE package_number
adrci>IPS ADD FILE filespec PACKAGE package_number

filespec is the complete path and name of the trace file to add .
package_number is the package id.


B. Generate a physical incident package :

Once you have created a logical package using one of the above methods, next step is to generate a physical package.


adrci>IPS GENERATE PACKAGE package_number IN path

This generates a complete physical package (zip file) in the designated path.
For example,
the following command creates a complete physical package in the directory /home/steve/diagnostics from logical package number 2:


adrci>IPS GENERATE PACKAGE 2 IN /home/steve/diagnostics

Upload this package to the SR for diagnosing the problem.

You can also create logical package and generate physical package with just one command :
IPS Pack.


adrci>IPS PACK INCIDENT incident_id IN path

All the methods discussed above apply to 'IPS pack' as well.


Would you like to explore this topic further with other Oracle Customers,Oracle Employees, and Industry Experts?
Click here to join the discussion where you can ask questions, get help from others, and share your experiences with this specific article


ReferencesNOTE:422893.1 - Understanding Automatic Diagnostic Repository.
NOTE:745960.1 - How to Unpack a Package in to ADR
NOTE:443529.1 - Database 11g: Quick Steps to Package and Send Critical Error Diagnostic Information to Support [Video]