Viewing Alert Logs from ADRCI

Show Real Time log.

 [oracle@orcl ~]$ adrci

 ADRCI: Release 19.0.0.0.0 - Production on Tue Aug 8 15:10:27 2023

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

 ADR base = "/u01/app/oracle"
 adrci> show alert -tail -f

Show last 50 lines.

 adrci> show alert -tail 10
 2023-08-08 14:44:38.858000 -03:00
 29294753,29299830,29307090,29307109,29311336,29329675,29330791,29339299,
 29357821,29360467,29360775,29367971,29368725,29379299,29379381,29380527,
 29381000,29382296,29391301,29393649,29402110,29411931,29413360,29457319,
 29465047
 ===========================================================
 2023-08-08 14:45:22.198000 -03:00
 Archive Log Start
 .... (PID:3505783): ARCHIVE LOG START has been deprecated, see ALTER DATABASE ARCHIVELOG
 2023-08-08 14:45:41.318000 -03:00
 Thread 1 advanced to log sequence 570 (LGWR switch)
   Current log# 3 seq# 570 mem# 0: /u01/oradata/CDB1/redo03.log
 ARC1 (PID:3505792): Archived Log entry 1 added for T-1.S-569 ID 0x423d86b0 LAD:1
 adrci>

Show incidents.

 adrci> show alert -p "message_text like '%incident%'"
 2023-08-08 14:30:03.562000 -03:00
 Errors in file /u01/app/oracle/diag/rdbms/cdb1/cdb1/trace/cdb1_vktm_3505221.trc  (incident=15407) (PDBNAME=CDB$ROOT):
 ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
 Incident details in: /u01/app/oracle/diag/rdbms/cdb1/cdb1/incident/incdir_15407/cdb1_vktm_3505221_i15407.trc
 2023-08-08 14:43:37.890000 -03:00
 Errors in file /u01/app/oracle/diag/rdbms/cdb1/cdb1/trace/cdb1_vktm_3505713.trc  (incident=17968) (PDBNAME=CDB$ROOT):
 ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
 Incident details in: /u01/app/oracle/diag/rdbms/cdb1/cdb1/incident/incdir_17968/cdb1_vktm_3505713_i17968.trc

Show ORA alerts.

 adrci> show alert -p "message_text like '%ORA-%'"
 2023-05-23 15:34:10.339000 -03:00
 Errors in file /u01/app/oracle/diag/rdbms/cdb1/cdb1/trace/cdb1_ora_51990.trc:
 ORA-00313: open failed for members of log group 1 of thread 1
 ORA-00312: online log 1 thread 1: '/u01/oradata/CDB1/redo01.log'
 ORA-27037: unable to obtain file status
 Linux-x86_64 Error: 2: No such file or directory
 Additional information: 7
 Errors in file /u01/app/oracle/diag/rdbms/cdb1/cdb1/trace/cdb1_ora_51990.trc:
 ORA-00313: open failed for members of log group 2 of thread 1

Read specific trace file.

 adrci> show trace /u01/app/oracle/diag/rdbms/cdb1/cdb1/incident/incdir_17968/cdb1_vktm_3505713_i17968.trc
 Output the results to file: /tmp/utsout_3507008_140_6.ado
 /u01/app/oracle/diag/rdbms/cdb1/cdb1/incident/incdir_17968/cdb1_vktm_3505713_i17968.trc
 ----------------------------------------------------------
 LEVEL PAYLOAD
 ----- ------------------------------------------------------------------------------------------------------------------------------------------------
       Dump file /u01/app/oracle/diag/rdbms/cdb1/cdb1/incident/incdir_17968/cdb1_vktm_3505713_i17968.trc
       Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
       Version 19.3.0.0.0
       Build label:    RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417
       ORACLE_HOME:    /u01/app/oracle/product/19.0.0/dbhome_1
       System name:      Linux
       Node name:        orcl.localdomain
       Release:  5.15.0-101.103.2.1.el8uek.x86_64
       Version:  #2 SMP Mon May 1 20:11:30 PDT 2023
       Machine:  x86_64
       Instance name: cdb1
       Redo thread mounted by this instance: 0 <none>
       Oracle process number: 5
       Unix process pid: 3505713, image: oracle@orcl.localdomain (VKTM)

 ...