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. |
Nagulu Polagani
Latest posts by Nagulu Polagani (see all)
- Application does not have any Components in it - October 5, 2018
- Launch EC2 Instance using Ansible - August 13, 2018
- Install Ansible on AWS Red Hat Enterprise Linux - August 9, 2018