ADRCI Commands for Managing Oracle Diagnostics
3 min read
ADRCI (Automatic Diagnostic Repository Command-Line Interface) is a utility for managing and analyzing Oracle diagnostic data, including listener logs, alert logs, incidents, and core dumps. This guide covers essential ADRCI commands.
General Commands
| Command | Description | Example |
|---|---|---|
adrept | Launches the ADR report viewer. | Type adrept in the ADRCI prompt to access diagnostic reports. |
adrcat | Displays the contents of the ADR repository. | Type adrcat to list all available diagnostic logs and data. |
adrci | Main command-line interface for managing ADR data. | Simply type adrci to enter the ADR command-line interface. |
Common Operations
| Task | Command(s) | Example |
|---|---|---|
| Get current base location (ADR_BASE) | adrci> show base | Example: ADR base is "/var/w3buddy/app/oracle" |
| Set a new ADR_BASE | adrci> set base <new_base_path> | Example: adrci> set base /var/w3buddy/app/grid |
| List current ADR homes (ORACLE_HOME) | adrci> show home | Displays available Oracle homes, e.g., /var/w3buddy/app/oracle |
| Set a new ORACLE_HOME | adrci> set homepath <home_path> | Example: adrci> set homepath /var/w3buddy/app/oracle_home1 |
| View alert log | adrci> show alertadrci> show alert -tail <number> | Example: adrci> show alert -tail 50 (views the last 50 lines). |
| Purge old diagnostic files | adrci> purge -age <minutes> -type <type> | Example: adrci> purge -age 1440 -type ALERT (purges alerts older than 24 hours). |
Purging Policies
| Policy | Data Types | Default Retention | Commands | Example |
|---|---|---|---|---|
| LONGP_POLICY | ALERT, INCIDENT, SWEEP, STAGE, HM | 365 days | adrci> set control (LONGP_POLICY = <hours>) | Example: adrci> set control (LONGP_POLICY = 8760) (sets retention to 1 year). |
| SHORTP_POLICY | TRACE, CDUMP, UTSCDMP, IPS | 30 days | adrci> set control (SHORTP_POLICY = <hours>) | Example: adrci> set control (SHORTP_POLICY = 720) (sets retention to 30 days). |
| View current policy | – | – | adrci> show control | Example: adrci> show control (displays the current retention settings). |
Note:
- Adjust retention policies based on the storage and operational requirements.
- Values for retention periods are set in hours (e.g., 720 hours = 30 days).
Incident Package Management
| Task | Command(s) | Example |
|---|---|---|
| Create incident package | adrci> IPS CREATE PACKAGE INCIDENTor adrci> ips pack incident in <output_path> | Example: adrci> ips pack incident in /var/w3buddy/packages |
| Create an empty package | adrci> IPS CREATE PACKAGE | Creates a new package for manual additions. |
| Add incident to a package | adrci> IPS ADD INCIDENT <incident_number> PACKAGE <package_number> | Example: adrci> IPS ADD INCIDENT 1001 PACKAGE 3 |
| Add specific files to a package | adrci> IPS ADD FILE <file_path> PACKAGE <package_number> | Example: adrci> IPS ADD FILE /var/w3buddy/logs/alert_db.log PACKAGE 3 |
| Generate a package file | adrci> IPS GENERATE PACKAGE <package_number> IN <output_directory> | Example: adrci> IPS GENERATE PACKAGE 3 IN /var/w3buddy/generated_packages |
| Unpack an IPS file | adrci> ips unpack file <file_name> into <directory> | Example: adrci> ips unpack file ORA_12345.zip into /var/w3buddy/unpacked_files |
| Pack incidents in a time frame | adrci> ips pack time '<start_time>' to '<end_time>' | Example: adrci> ips pack time '2025-01-01 12:00:00.00' to '2025-01-02 12:00:00.00' |
| View package information | adrci> ips show packageadrci> ips show package <package_number> detail | Example: adrci> ips show package 3 (shows details of package 3). |
| Delete package | adrci> ips delete package <package_number> | Example: adrci> ips delete package 3 (removes the package completely). |
| Remove incident from package | adrci> ips remove incident <incident_number> package <package_number> | Example: adrci> ips remove incident 1002 package 3 |
| Remove problem from package | adrci> ips remove problem <problem_number> package <package_number> | Example: adrci> ips remove problem 2001 package 3 |
