my first ADR package

You got an internal error and want to create a zip of all relevant files.

First, let’s generate an internal error. I found a quick way to generate an ora-600 or an ora-700 (which is a harmless ora-600 in 11g, read 737878.1) on oradeblog

SQL> oradebug unit_test dbke_test dde_flow_kge_soft foo bar baz
Statement processed.

Now start the command line interface, and set the ORACLE HOME
$ adrcli
adrci> show home
ADR Homes:
diag/tnslsnr/precision/listener
diag/tnslsnr/localhost/listener
diag/rdbms/lsc02/LSC02
diag/rdbms/lsc03/LSC03
diag/rdbms/lsc01/LSC01
adrci> set homepath diag/rdbms/lsc02/LSC02
adrci> show home
ADR Homes:
diag/rdbms/lsc02/LSC02

Check the incidents :
adrci> show incident

ADR Home = /u01/app/oracle/diag/rdbms/lsc02/LSC02:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------- ---------------------------------
53065 ORA 700 [foo] 2011-03-14 18:20:24 +01:00
1 rows fetched

Create the package metadata :

adrci> IPS CREATE PACKAGE INCIDENT 53065
Created package 1 based on incident id 53065, correlation level typical
adrci> ips SHOW PACKAGE 1
DETAILS FOR PACKAGE 1:
PACKAGE_ID 1
PACKAGE_NAME ORA700foo_20110314182607
PACKAGE_DESCRIPTION
DRIVING_PROBLEM 1
DRIVING_PROBLEM_KEY ORA 700 [foo]
DRIVING_INCIDENT 53065
DRIVING_INCIDENT_TIME 2011-03-14 18:20:24.304000 +01:00
STATUS New (0)
CORRELATION_LEVEL Typical (2)
PROBLEMS 1 main problems, 0 correlated problems
INCIDENTS 1 main incidents, 0 correlated incidents
INCLUDED_FILES 4
SEQUENCES Last 0, last full 0, last base 0
UNPACKED FALSE
CREATE_TIME 2011-03-14 18:26:07.566961 +01:00
UPDATE_TIME 2011-03-14 18:26:07.620324 +01:00
BEGIN_TIME N/A
END_TIME N/A
FLAGS 0

The metadata files (in $ORACLE_BASE/rdbms/db_name/sid/*.ams) are in an Oracle binary format

Create the package zip file :
adrci> IPS GENERATE PACKAGE 1 in /home/lsc/foo
Generated package 1 in file /home/lsc/foo/ORA700foo_20110314182607_COM_1.zip,
mode complete

This zip file contains all traces and alerts that you may ever need to diagnose/resolve the analysis

adrci> ips show files package 1
FILE_ID 1
FILE_LOCATION /incident/incdir_53065
FILE_NAME LSC02_ora_14163_i53065.trm
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2
FILE_LOCATION /incident/incdir_53065
FILE_NAME LSC02_ora_14163_i53065.trc
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 3
FILE_LOCATION /trace
FILE_NAME LSC02_ora_14163.trc
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 4
FILE_LOCATION /trace
FILE_NAME LSC02_ora_14163.trm
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 5
FILE_LOCATION /alert
FILE_NAME log.xml
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 6
FILE_LOCATION /trace
FILE_NAME alert_LSC02.log
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 7
FILE_LOCATION /trace
FILE_NAME LSC02_diag_5247.trc
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 8
FILE_LOCATION /trace
FILE_NAME LSC02_diag_5247.trm
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 12
FILE_LOCATION /trace
FILE_NAME LSC02_mmon_5265.trc
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 13
FILE_LOCATION /trace
FILE_NAME LSC02_mmon_5265.trm
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2007
FILE_LOCATION /incpkg/pkg_1/seq_1/export
FILE_NAME IPS_CONFIGURATION.dmp
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2008
FILE_LOCATION /incpkg/pkg_1/seq_1/export
FILE_NAME IPS_PACKAGE.dmp
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2009
FILE_LOCATION /incpkg/pkg_1/seq_1/export
FILE_NAME IPS_PACKAGE_INCIDENT.dmp
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2010
FILE_LOCATION /incpkg/pkg_1/seq_1/export
FILE_NAME IPS_PACKAGE_FILE.dmp
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2011
FILE_LOCATION /incpkg/pkg_1/seq_1/export
FILE_NAME IPS_PACKAGE_HISTORY.dmp
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2012
FILE_LOCATION /incpkg/pkg_1/seq_1/export
FILE_NAME IPS_FILE_METADATA.dmp
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2013
FILE_LOCATION /incpkg/pkg_1/seq_1/export
FILE_NAME IPS_FILE_COPY_LOG.dmp
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2014
FILE_LOCATION /incpkg/pkg_1/seq_1/export
FILE_NAME DDE_USER_ACTION_DEF.dmp
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2015
FILE_LOCATION /incpkg/pkg_1/seq_1/export
FILE_NAME DDE_USER_ACTION_PARAMETER_DEF.dmp
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2016
FILE_LOCATION /incpkg/pkg_1/seq_1/export
FILE_NAME DDE_USER_ACTION.dmp
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2017
FILE_LOCATION /incpkg/pkg_1/seq_1/export
FILE_NAME DDE_USER_ACTION_PARAMETER.dmp
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2018
FILE_LOCATION /incpkg/pkg_1/seq_1/export
FILE_NAME DDE_USER_INCIDENT_TYPE.dmp
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2019
FILE_LOCATION /incpkg/pkg_1/seq_1/export
FILE_NAME DDE_USER_INCIDENT_ACTION_MAP.dmp
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2020
FILE_LOCATION /incpkg/pkg_1/seq_1/export
FILE_NAME INCIDENT.dmp
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2021
FILE_LOCATION /incpkg/pkg_1/seq_1/export
FILE_NAME INCCKEY.dmp
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2022
FILE_LOCATION /incpkg/pkg_1/seq_1/export
FILE_NAME INCIDENT_FILE.dmp
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2023
FILE_LOCATION /incpkg/pkg_1/seq_1/export
FILE_NAME PROBLEM.dmp
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2024
FILE_LOCATION /incpkg/pkg_1/seq_1/export
FILE_NAME HM_RUN.dmp
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2025
FILE_LOCATION /incpkg/pkg_1/seq_1/export
FILE_NAME EM_USER_ACTIVITY.dmp
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2026
FILE_LOCATION /incpkg/pkg_1/seq_1
FILE_NAME config.xml
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2027
FILE_LOCATION /incpkg/pkg_1/seq_1/crs
FILE_NAME crsdiag.log
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2028
FILE_LOCATION /incpkg/pkg_1/seq_1
FILE_NAME metadata.xml
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2029
FILE_LOCATION /incpkg/pkg_1/seq_1
FILE_NAME manifest_1_1.xml
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2030
FILE_LOCATION /incpkg/pkg_1/seq_1
FILE_NAME manifest_1_1.html
LAST_SEQUENCE 1
EXCLUDE Included

FILE_ID 2031
FILE_LOCATION /incpkg/pkg_1/seq_1
FILE_NAME manifest_1_1.txt
LAST_SEQUENCE 1
EXCLUDE Included

Even an html file

Manifest for package 1

Manifest details

Package ID 1
Creation time 2011-03-14 18:26:07.566961 +01:00
Archive time 2011-03-14 18:37:14.499389 +01:00
Sequence 1
Package mode Complete
Package status Generating
Package flags Flags: (No flags set)

Contents summary

Main problems 1
Correlated problems 0
Main incidents 1
Correlated incidents 0

ADR details

Product rdbms
Target lsc02
Instance LSC02
ADR base /u01/app/oracle
ADR home /u01/app/oracle/diag/rdbms/lsc02/LSC02

Main problems

Problem ID Problem key Incidents included Incidents total
1 ORA 700 [foo] 1 1

Correlated problems

Problem ID Problem key Incidents included Incidents total

Main incidents

Incident ID Problem ID Error Message Incident time
53065 1 ORA-700 [foo] [bar] [baz] 2011-03-14 18:20:24.304000 +01:00

Correlated incidents

Incident ID Problem ID Error Message Incident time

Files

File name Location Size File time
LSC02_ora_14163_i53065.trm <ADR_HOME>/incident/incdir_53065 54828 2011-03-14 18:20:26.000000 +01:00
LSC02_ora_14163_i53065.trc <ADR_HOME>/incident/incdir_53065 2433968 2011-03-14 18:20:26.000000 +01:00
LSC02_ora_14163.trc <ADR_HOME>/trace 1308 2011-03-14 18:20:26.000000 +01:00
LSC02_ora_14163.trm <ADR_HOME>/trace 210 2011-03-14 18:20:24.000000 +01:00
log.xml <ADR_HOME>/alert 885849 2011-03-14 18:20:27.000000 +01:00
alert_LSC02.log <ADR_HOME>/trace 164969 2011-03-14 18:20:27.000000 +01:00
LSC02_diag_5247.trc <ADR_HOME>/trace 1287 2011-03-14 18:20:26.000000 +01:00
LSC02_diag_5247.trm <ADR_HOME>/trace 77 2011-03-14 18:20:26.000000 +01:00
LSC02_mmon_5265.trc <ADR_HOME>/trace 8703 2011-03-14 18:33:43.000000 +01:00
LSC02_mmon_5265.trm <ADR_HOME>/trace 838 2011-03-14 18:33:43.000000 +01:00
IPS_CONFIGURATION.dmp <ADR_HOME>/incpkg/pkg_1/seq_1/export 2818 2011-03-14 18:37:13.000000 +01:00
IPS_PACKAGE.dmp <ADR_HOME>/incpkg/pkg_1/seq_1/export 476 2011-03-14 18:37:13.000000 +01:00
IPS_PACKAGE_INCIDENT.dmp <ADR_HOME>/incpkg/pkg_1/seq_1/export 193 2011-03-14 18:37:13.000000 +01:00
IPS_PACKAGE_FILE.dmp <ADR_HOME>/incpkg/pkg_1/seq_1/export 1126 2011-03-14 18:37:14.000000 +01:00
IPS_PACKAGE_HISTORY.dmp <ADR_HOME>/incpkg/pkg_1/seq_1/export 280 2011-03-14 18:37:13.000000 +01:00
IPS_FILE_METADATA.dmp <ADR_HOME>/incpkg/pkg_1/seq_1/export 2888 2011-03-14 18:37:14.000000 +01:00
IPS_FILE_COPY_LOG.dmp <ADR_HOME>/incpkg/pkg_1/seq_1/export 214 2011-03-14 18:37:14.000000 +01:00
DDE_USER_ACTION_DEF.dmp <ADR_HOME>/incpkg/pkg_1/seq_1/export 908 2011-03-14 18:37:13.000000 +01:00
DDE_USER_ACTION_PARAMETER_DEF.dmp <ADR_HOME>/incpkg/pkg_1/seq_1/export 708 2011-03-14 18:37:13.000000 +01:00
DDE_USER_ACTION.dmp <ADR_HOME>/incpkg/pkg_1/seq_1/export 204 2011-03-14 18:37:13.000000 +01:00
DDE_USER_ACTION_PARAMETER.dmp <ADR_HOME>/incpkg/pkg_1/seq_1/export 198 2011-03-14 18:37:13.000000 +01:00
DDE_USER_INCIDENT_TYPE.dmp <ADR_HOME>/incpkg/pkg_1/seq_1/export 353 2011-03-14 18:37:13.000000 +01:00
DDE_USER_INCIDENT_ACTION_MAP.dmp <ADR_HOME>/incpkg/pkg_1/seq_1/export 166 2011-03-14 18:37:13.000000 +01:00
INCIDENT.dmp <ADR_HOME>/incpkg/pkg_1/seq_1/export 700 2011-03-14 18:37:13.000000 +01:00
INCCKEY.dmp <ADR_HOME>/incpkg/pkg_1/seq_1/export 303 2011-03-14 18:37:13.000000 +01:00
INCIDENT_FILE.dmp <ADR_HOME>/incpkg/pkg_1/seq_1/export 268 2011-03-14 18:37:13.000000 +01:00
PROBLEM.dmp <ADR_HOME>/incpkg/pkg_1/seq_1/export 395 2011-03-14 18:37:13.000000 +01:00
HM_RUN.dmp <ADR_HOME>/incpkg/pkg_1/seq_1/export 342 2011-03-14 18:37:14.000000 +01:00
EM_USER_ACTIVITY.dmp <ADR_HOME>/incpkg/pkg_1/seq_1/export 207 2011-03-14 18:37:14.000000 +01:00
config.xml <ADR_HOME>/incpkg/pkg_1/seq_1 56180 2011-03-14 18:37:14.000000 +01:00
crsdiag.log <ADR_HOME>/incpkg/pkg_1/seq_1/crs 184 2011-03-14 18:37:14.000000 +01:00
metadata.xml <ADR_HOME>/incpkg/pkg_1/seq_1 556 2011-03-14 18:37:14.000000 +01:00

But did Oracle Support ever asked you for an ADR package? Or do they still ask for RDA

I used to select, zip and send traces files manually, I may consider ADR packages by my next ORA-600 !

1 thought on “my first ADR package

  1. Pingback: OCM 11g upgrade | Laurent Schneider

Comments are closed.