The ADRCI commands are not too exotic and using SHOW, SET and HELP make
the tool feel a lot like the listener control utility LSNRCTL. That
is another advantage of ADRCI over Enterprise Manager: the commands
in ADRCI are here and now. OEM has latency issues. How many times
has one seen the big red down arrow indicating the instance is down
while at the same time the DBA is logged in via SQL*Plus?
By means of a quick introduction to ADRCI, here is the start of a
session, some “where am I” information, and an output of help topics.
C:\>adrci
ADRCI: Release 11.1.0.6.0 - Beta on Sat Sep 20
15:38:12 2008
Copyright (c) 1982, 2007, Oracle.
All rights reserved.
ADR base = "c:\app\ora11g"
adrci> show home
ADR Homes:
diag\clients\user_unknown\host_411310321_11
diag\rdbms\db11\db11
diag\tnslsnr\t42\listener
adrci> help
HELP [topic]
Available Topics:
CREATE REPORT
ECHO
EXIT
HELP
HOST
IPS
PURGE
RUN
SET BASE
SET BROWSER
SET CONTROL
SET ECHO
SET EDITOR
SET HOMES | HOME | HOMEPATH
SET TERMOUT
SHOW ALERT
SHOW BASE
SHOW CONTROL
SHOW HM_RUN
SHOW HOMES | HOME | HOMEPATH
SHOW INCDIR
SHOW INCIDENT
SHOW PROBLEM
SHOW REPORT
SHOW TRACEFILE
SPOOL
There are other commands intended to
be used directly by Oracle, type
"HELP EXTENDED" to see the adrci command list.
The hierarchy of directories within the repository is shown below
(from Figure 8-1 in the Administrator’s Guide).
Figure 8.2: ADR
Hierarchy
RAC nodes and ASM will have their own ADR
setup, and those could be spanning a common file system.
ADR deals with problems, so create one in order to have something to
work with. Is every problem reportable, that is, is any ORA error
recorded in the alert log sufficient to create an incident? The answer
is no.
That is a bit more serious than a user error for a wrong size while
resizing a datafile. Start ADRCI and set the home to the rdbms path,
but leave all homes in the SHOW HOME output.
The next step is to see what SHOW INCIDENT displays. In the output
below, a CREATE_TIME column is not shown due to editing/page size
limitations.
adrci> set homepath diag\rdbms\db11\db11
adrci> show incident
ADR Home = c:\app\ora11g\diag\rdbms\db11\db11:
********************************************************
INCIDENT_ID
PROBLEM_KEY
--------------------
-----------------------------------
8545
ORA 600 [kcidr_io_check_common_6]
Note that the database did not and does not
have to be opened or have an instance running, for that matter, in
order to use ADRCI.
Use the “show home” command to see which
ADR homes are available, followed by the “set homepath” as necessary.
Note that more than one home can be involved in an incident. Only the
rdbms home need apply in this example for viewing a specific file.
adrci> set homepath diag\rdbms\db11\db11
adrci> show home
ADR
Homes:
diag\rdbms\db11\db11
NOTE: Rampant
author Laurent Schneider has some additional insight into
creating an Oracle Automatic Diagnostic Repository (ADR).
