ADRCI Command Interpreter in 11g

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:

The utility starts and displays the following prompt:

Enter ADRCI commands, following each with the Enter key.

Enter one of the following commands to exit ADRCI:



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. 

Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."

Latest posts by Nagulu Polagani (see all)