Problem Diagnosis - Expert Oracle RAC Performance Diagnostics and Tuning - page 621

DRIVING_INCIDENT_TIME 2010-12-02 01:04:06.313000 -08:00
STATUS New (0)
CORRELATION_LEVEL All (4)
PROBLEMS 1 main problems, 0 correlated problems
INCIDENTS 1 main incidents, 0 correlated incidents
INCLUDED_FILES 3
The show package command lists all the incidents and the problems associated with this package.
Step 7
Once the package has been created, the next step is to generate the package. This step can be completed in one step
or can be completed in increments, meaning that in the future when more incidents occur with the same error or any
related incidents occur, they could be added to the same package. In this specific example, the package is closed with
the complete clause:
adrci> IPS GENERATE PACKAGE 1 IN /home/oracle/mvallath
Generated package 1 in file /home/oracle/mvallath/ORA600kjb_20101213212018_COM_1.zip, mode complete
adrci> ips show incidents package 1
MAIN INCIDENTS FOR PACKAGE 1:
INCIDENT_ID 88515
PROBLEM_ID 2
EXCLUDE Included
CORRELATED INCIDENTS FOR PACKAGE 1:
V$DIAG_IPS_FILE_METADATA
When generating a package for the incident or problem, ADR collects all the related metadata information. This view
lists the metadata related to the incident:
Script Name:MVRACPDnTap_adripsmetadata.sql
BFILE INCIDENT_ID
------------------------------------------------------------------ -----------
<ADR_HOME>/incident/incdir_88515/PRDDB_1_lms1_11152_i88515.trc#0 88515
<ADR_HOME>/incpkg/pkg_1/seq_2/crs/alertprddb1.log#0 0
<ADR_HOME>/trace/PRDDB_1_lms1_11152.trc#0 0
<ADR_HOME>/alert/log.xml#0 0
<ADR_HOME>/trace/alert_PRDDB_1.log#0 0
<ADR_HOME>/incpkg/pkg_1/seq_1/export/IPS_CONFIGURATION.dmp#0 0
<ADR_HOME>/incpkg/pkg_1/seq_1/export/IPS_PACKAGE.dmp#0 0
<ADR_HOME>/incpkg/pkg_1/seq_1/export/IPS_PACKAGE_INCIDENT.dmp#0 0
<ADR_HOME>/incpkg/pkg_1/seq_1/export/IPS_PACKAGE_FILE.dmp#0 0
<ADR_HOME>/incpkg/pkg_1/seq_1/export/IPS_PACKAGE_HISTORY.dmp#0 0