Sunday, June 6, 2010

ADRCI (Automatic Diagnostic Repository Command Interface)

Automatic Diagnostic Repository
================================


ADR ( In Oracle 11g)
========
ADR (Automatic Diagnostic Repository) is part of the Oracle database's fault diagnosability
infrastructure, first introduced with Oracle 11g, to reduce time for resolving
problems (round trip time between DBA's and Oracle Support).

DBA's can change the ADR directory by changing the DIAGNOSTIC_DEST initialization parameter.

The following subdirectories are present in the ADR home directory:

alert - The XML formatted alert log file (called log.xml)
trace - files and text alert.log file
cdump - core files

cmd> ADRCI


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 list

adrci> show base
ADR base is "d:\oracle11g_app_upgrade\era-1"
adrci>
adrci>
adrci> show incdir

ADR Home = d:\oracle11g_app_upgrade\era-1\diag\rdbms\beftn\beftn:
*************************************************************************
adrci>
adrci> show report
DIA-48415: Syntax error found in string [show report
] at column [12]

adrci> show alert

ADR Home = d:\oracle11g_app_upgrade\era-1\diag\rdbms\beftn\beftn:
*************************************************************************
Output the results to file: c:\docume~1\era-1\locals~1\temp\alert_4316_3868_beft
n_1.ado
'vi' is not recognized as an internal or external command,
operable program or batch file.
adrci>
adrci>
adrci>



ADRCI :=
=============================
(Automatic Diagnostic Repository Command Interface) is a command line utility of ADR
that ships with the Oracle database software.