Recently while doing R&D, I came across the ADR Command Interpreter (ADRCI).

Introduced in Oracle Database Release 11g, it is a command-line tool that one can use to manage diagnostic data.

Diagnostic data includes incident and problem descriptions, trace files, dumps, health monitor reports, alert log entries, and more.

ADRCI has a rich command set, and can be used in interactive mode or within scripts.

In addition, ADRCI can execute scripts of ADRCI commands in the same way that SQL*Plus executes scripts of SQL and PL/SQL commands.

It enables us to:

• View diagnostic data within the Automatic Diagnostic Repository (ADR).
• View Health Monitor reports.
• Package incident and problem information into a zip file for transmission to Oracle Support.

I tried using it and found interface just like RMAN command interpreter.

Just run the command “adrci” as follows and you will be logged into the tool:

C:\Documents and Settings\oradev>adrci

ADRCI: Release 11.1.0.6.0 - Beta on Sat Dec 17 09:35:23 2007

Copyright (c) 1982, 2007, Oracle. All rights reserved.

ADR base = “d:\oracle”
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>

ADR data is secured by operating system permissions on the ADR directories, hence there is no need to log in to ADRCI.

More Details can be found here.

Note: However, Oracle Enterprise Manager is easiest and recommended way to manage diagnostic data.