Automatic Diagnostic Repository Command Interpreter (ADRCI)

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

See the following topics:

About the ADR Command Interpreter (ADRCI) Utility ADRCI is a command-line tool that is part of the fault diagnosability infrastructure introduced in Oracle Database 11g. Definitions These are definitions of terms used for ADRCI and the Oracle Database fault diagnosability infrastructure. Starting ADRCI and Getting Help You can use ADRCI in interactive mode or batch mode. Setting the ADRCI Homepath Before Using ADRCI Commands When diagnosing a problem, you may want to work with diagnostic data from multiple database instances or components, or you may want to focus on diagnostic data from one instance or component. Viewing the Alert Log The alert log is written as both an XML-formatted file and as a text file. You can view either format of the file with any text editor, or you can run an ADRCI command to view the XML-formatted alert log with the XML tags omitted. Finding Trace Files ADRCI enables you to view the names of trace files that are currently in the automatic diagnostic repository (ADR). Viewing Incidents The ADRCI SHOW INCIDENT command displays information about open incidents. Packaging Incidents You can use ADRCI commands to package one or more incidents for transmission to Oracle Support for analysis. ADRCI Command Reference Describes the ADRCI commands. Troubleshooting ADRCI Describes some common ADRCI error messages.

[root@srv1  odaorabase0]# adrci
 
ADRCI: Release 19.0.0.0.0 - Production on Tue Feb 25 14:40:01 2025
 
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
 
ADR base = "/u01/app/odaorabase/oracle"
adrci>
adrci>
adrci>
adrci> show homes
ADR Homes:
diag/rdbms/sitnecdb/SITNECDB
diag/rdbms/repocdb/REPOCDB
diag/rdbms/testcdb/TESTCDB
diag/rdbms/pricdb/PRICDB
diag/asm/user_root/host_1122105564_110
diag/clients/user_oracle/host_1122105564_110
diag/asmtool/user_root/host_1122105564_110
diag/asmcmd/user_oracle/phanes
diag/kfod/phanes/kfod
adrci> purge -age 60
DIA-48448: This command does not support multiple ADR homes
 
adrci> set home diag/rdbms/sitnecdb/SITNECDB
adrci> purge -age 60
adrci> set home diag/rdbms/repocdb/REPOCDB
adrci> purge -age 60
adrci> set home diag/rdbms/testcdb/TESTCDB
adrci> purge -age 60
adrci> set home diag/rdbms/pricdb/PRICDB
adrci> purge -age 60
adrci> set home diag/asm/user_root/host_1122105564_110
adrci> purge -age 60
adrci> set home diag/asmcmd/user_oracle/phanes
adrci> purge -age 60