Check errors in the Oracle alert log file using the ADRCI utility

1. Log in to the Oracle Server.
2. Run the ADRCI command to check existing errors in the alert log file.

C:\>adrci

ADRCI: Release 21.0.0.0.0 - Production on Fri Apr 14 14:43:38 2023

Copyright (c) 1982, 2021, Oracle and/or its affiliates.  All rights reserved.

ADR base = "C:\app\product\21c"

3. Show homes command to show the home location of log files

adrci> show homes
ADR Homes:
diag\clients\host_1783686503_110
diag\clients\user_OracleServiceXE\host_1783686503_110
diag\rdbms\xe\xe
diag\tnslsnr\ORACLEINSTANCE\listener

4. Choose the alert log home for ORA errors i.e diag\rdbms\xe\xe

adrci> set home diag\rdbms\xe\xe

5. Now check the incident present in an alert log file: Show incident shows all the alert log incidents with their date.

adrci> show incident
ADR Home = C:\app\product\21c\diag\rdbms\xe\xe:
*************************************************************************
INCIDENT_ID   PROBLEM_KEY                  CREATE_TIME                       
------------  ---------------------------- ----------------------------------
668745        ORA 4031                     2022-02-19 07:53:49.542000 +01:00 
668801        ORA 4031                     2022-02-19 07:53:53.466000 +01:00 
668802        ORA 4031                     2022-02-19 07:53:57.230000 +01:00 
700500        ORA 600 [kwqitnmphe:ltbagi]  2022-03-03 03:45:47.323000 +02:00 
704519        ORA 600 [kwqitnmphe:ltbagi]  2022-03-03 05:05:15.543000 +02:00 
704583        ORA 600 [kwqitnmphe:ltbagi]  2022-03-03 07:54:06.761000 +02:00 

6. Now check the problems like ora 600 is considered an Oracle internal error or major issue.

adrci> show problem

ADR Home = C:\app\product\21c\diag\rdbms\xe\xe:
*************************************************************************
PROBLEM_ID PROEM_KEY                   LAST_INCIDENT LASTINC_TIME
---------- --------------------------- ------------- ---------------------------------
1          ORA 4031                    700884        2022-02-19 09:23:45.353000 +02:00
2          ORA 600 [kwqitnmphe:ltbagi] 709177        2022-03-03 09:34:41.764000 +02:00

7. Sometimes we need to provide all log files as a package to load on oracle support site:

adrci>  ips pack problem 1 in c:\ips_oracle