[backlog] OracleDB - K8s - Potential for irrelevant logs to be shown in dashboard

[Dasomeone]

Introduced with #1299 the updated OracleDB mixin supports showing logs from container logs, which are not necessarily all related to OracleDB.

Just making a note in case we need to review/add extra filtering in the future

[algchoo]

Looking at a working instance of the sample application, I can confirm that it'd be a variety of logs. It looks like logs coming from the container regarding startup for the database, then listener logs, then alert logs.

Container log output

CONTAINER: starting up...
CONTAINER: first database startup, initializing...
CONTAINER: uncompressing database data files, please wait...
CONTAINER: done uncompressing database data files, duration: 20 seconds.
CONTAINER: starting up Oracle Database...

LSNRCTL for Linux: Version 21.0.0.0.0 - Production on 13-AUG-2024 14:05:16

Copyright (c) 1991, 2021, Oracle.  All rights reserved.

Starting /opt/oracle/product/21c/dbhomeXE/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 21.0.0.0.0 - Production
System parameter file is /opt/oracle/homes/OraDBHome21cXE/network/admin/listener.ora
Log messages written to /opt/oracle/diag/tnslsnr/oracledbxe-cb95674dd-8jqqd/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 21.0.0.0.0 - Production
Start Date                13-AUG-2024 14:05:31
Uptime                    0 days 0 hr. 0 min. 15 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   /opt/oracle/homes/OraDBHome21cXE/network/admin/listener.ora
Listener Log File         /opt/oracle/diag/tnslsnr/oracledbxe-cb95674dd-8jqqd/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
The listener supports no services
The command completed successfully
ORACLE instance started.

Total System Global Area 1610612120 bytes
Fixed Size		    9686424 bytes
Variable Size		  603979776 bytes
Database Buffers	  989855744 bytes
Redo Buffers		    7090176 bytes
Database mounted.
Database opened.

CONTAINER: Resetting SYS and SYSTEM passwords.

User altered.


User altered.


Session altered.


User created.


Grant succeeded.


#########################
DATABASE IS READY TO USE!
#########################

################################################
NOTICE: YOU ARE USING AN OLD IMAGE VERSION!
PLEASE CONSIDER UPGRADING TO gvenzl/oracle-free!
################################################

##################################################################
CONTAINER: The following output is now from the alert_XE.log file:
##################################################################
XEPDB1(3):SUPLOG: Set PDB SUPLOG SGA at PDB OPEN, old 0x18, new 0x0 (no suplog)
2024-08-13T14:05:46.636944+00:00
XEPDB1(3):Started service freepdb1/freepdb1/freepdb1
XEPDB1(3):Opening pdb with Resource Manager plan: DEFAULT_PLAN
2024-08-13T14:05:46.919598+00:00
Pluggable database XEPDB1 opened read write
Starting background process CJQ0
Completed: ALTER DATABASE OPEN
2024-08-13T14:05:47.041314+00:00
CJQ0 started with pid=54, OS id=222
2024-08-13T14:06:48.304317+00:00
TABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION SYS_P348 (5339) VALUES LESS THAN (TO_DATE(' 2024-08-14 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
TABLE SYS.WRP$_REPORTS_DETAILS: ADDED INTERVAL PARTITION SYS_P349 (5339) VALUES LESS THAN (TO_DATE(' 2024-08-14 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
TABLE SYS.WRP$_REPORTS_TIME_BANDS: ADDED INTERVAL PARTITION SYS_P352 (5338) VALUES LESS THAN (TO_DATE(' 2024-08-13 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2024-08-13T14:10:58.216276+00:00
Thread 1 advanced to log sequence 15 (LGWR switch),  current SCN: 2852571
  Current log# 1 seq# 15 mem# 0: /opt/oracle/oradata/XE/redo01.log
2024-08-13T14:26:16.540298+00:00
XEPDB1(3):TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P360 (45516) VALUES LESS THAN (TO_DATE(' 2024-08-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
XEPDB1(3):TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P363 (45516) VALUES LESS THAN (TO_DATE(' 2024-08-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2024-08-13T14:26:19.711840+00:00
Thread 1 advanced to log sequence 16 (LGWR switch),  current SCN: 2858214
  Current log# 2 seq# 16 mem# 0: /opt/oracle/oradata/XE/redo02.log