January 1, 2013

ADRCI Command Interpreter in 11g

By Nagulu Polagani

The ADR Command Interpreter (ADRCI) is a command-line tool that you use to manage Oracle Database diagnostic data.

Automatic Diagnostic Repository (ADR)

The ADR is a file-based repository for database diagnostic data such as traces, dumps, the alert log, health monitor reports, and more. It has a unified directory structure across multiple instances and multiple products. Beginning with Release 11g, the database, Automatic Storage Management (ASM), and other Oracle products or components store all diagnostic data in the ADR. Each instance of each product stores diagnostic data underneath its own ADR home.

All ADRCI commands operate on diagnostic data in the “current” ADR homes. More than one ADR home can be current at any one time. Some ADRCI commands (such as SHOW INCIDENT) search for and display diagnostic data from all current ADR homes, while other commands require that only one ADR home be current, and display an error message if more than one is current.
To use ADRCI in interactive mode:

The PATH environment variable must include ORACLE_HOME/bin.

Enter the following command at the operating system command prompt:

ADRCI
The utility starts and displays the following prompt:

adrci>
Enter ADRCI commands, following each with the Enter key.

Enter one of the following commands to exit ADRCI:

EXIT
QUIT

List of ADRCI commands

Command	Description
CREATE REPORT	Creates a report for the specified report type and ID.
ECHO	Echoes the input string.
EXIT	Exits the current ADRCI session.
HOST	Executes operating system commands from ADRCI.
IPS	Invokes the IPS utility.
QUIT	Exits the current ADRCI session.
RUN	Runs an ADRCI script.
SET BASE	Sets the ADR base for the current ADRCI session.
SET BROWSER	Reserved for future use.
SET CONTROL	Set purging policies for ADR contents.
SET ECHO	Toggles command output.
SET EDITOR	Sets the default editor for displaying trace and alert log contents.
SET HOMEPATH	Makes current one or more ADR homes.
SET TERMOUT	Toggles terminal output.
SHOW ALERT	Shows alert log messages.
SHOW BASE	Shows the current ADR base.
SHOW CONTROL	Shows ADR information, including the current purging policy.
SHOW HM_RUN	Shows Health Monitor run information.
SHOW HOMEPATH	Shows the current homepath.
SHOW HOMES	Lists the current ADR homes.
SHOW INCDIR	Lists the trace files created for the specified incidents.
SHOW INCIDENT	Outputs a list of incidents.
SHOW PROBLEM	Outputs a list of problems.
SHOW REPORT	Shows a report for the specified report type and ID.
SHOW TRACEFILE	Lists qualified trace filenames.
SPOOL	Directs output to a file.