By Laurent Schneider
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 !
|
|
 |
|
Get the Complete
Oracle Tuning Details
The landmark book
"Oracle
Tuning: The Definitive Reference Second Edition" has been
updated with over 1,150 pages of expert performance tuning tips.
It's packed with scripts and tools to hypercharge Oracle 11g
performance and you can
buy it for 40% off directly from the publisher.
|
|
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
| |
| |
Copyright ©
1996 -2017 by Burleson. All rights reserved.
Oracle® is the registered trademark of Oracle
Corporation. SQL Server® is the registered trademark of Microsoft
Corporation.
Many of the designations used by computer vendors to distinguish their
products are claimed as Trademarks
|
|
