Database Reference
In-Depth Information
Starting in Oracle 11
g
and above, the process of gathering the trace information and uploading it to support
has been modified (and made significantly easier). A new command-line tool, in conjunction with a user interface
via Enterprise Manager, allows you to review the trace information in the ADR, and package and transmit it to
Oracle Support.
The Automatic Diagnostic Repository Command Interpreter (ADRCI) utility allows you to review “problems”
(critical errors in the database) and incidents (occurrences of those critical errors) and to package them up for
transmission to support. The packaging step includes retrieving not only the trace information, but also details from
the database alert log and other configuration/test case information. For example, I set up a situation in my database
that raised a critical error. (No, I won't say what it is. You have to generate your own critical errors.) I knew I had a
“problem” in my database because the ADRCI tool told me so:
[ora12cr1@dellpe ~]$ adrci
ADRCI: Release 12.1.0.1.0 - Production on Mon Sep 2 17:45:38 2013
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
ADR base = "/home/ora12cr1/app/ora12cr1"
adrci> show problem
ADR Home = /home/ora12cr1/app/ora12cr1/diag/rdbms/ora12cr1/ora12cr1:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
------------ ------------------------ --------------- ---------------------------------
1 ORA 7445 [qctcopn] 36281 2013-09-02 17:52:11.438000 -04:00
On September 2, 2013 I caused an ORA-7445, a serious problem, in the database (a bug was filed and fixed). I can
now see what was affected by that error by issuing the
show incident
command:
adrci> show incident
ADR Home = /home/ora12cr1/app/ora12cr1/diag/rdbms/ora12cr1/ora12cr1:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
--------------- --------------------------- ----------------------------------
36249 ORA 7445 [qctcopn] 2013-09-02 17:45:06.791000 -04:00
36250 ORA 7445 [qctcopn] 2013-09-02 17:51:58.469000 -04:00
36281 ORA 7445 [qctcopn] 2013-09-02 17:52:11.438000 -04:00
I can see there three incidents, and I can identify the information related to each incident via the
show tracefile
command:
adrci> show tracefile -I 36250
diag/rdbms/ora12cr1/ora12cr1/incident/incdir_36250/ora12cr1_ora_22682_i36250.trc
This shows me the location of the trace file for incident number 36250. Further, I can see a lot of detail about the
incident if I so choose:
adrci> show incident -mode detail -p "incident_id=36250"
ADR Home = /home/ora12cr1/app/ora12cr1/diag/rdbms/ora12cr1/ora12cr1:
*************************************************************************
