System Requirements

1. Supported Platforms and Operating Systems

The officially supported platforms and operating systems for SysMaster DB 8.3 are as follows.

Category
Product and Version

Operating System

  • Linux:

    • CentOS 7 (64-bit)

    • Red Hat Enterprise Linux 7, 8.1~8.5, 8.10 (64-bit)

    • Oracle Linux Server release 9.4

    • Rocky Linux release 9.5/9.6

  • Windows:

    • Windows 10 (64-bit)

    • Windows Server 2022 (64-bit)

  • Operating systems that support the installation of the following supported platforms and software requirements

Docker

v20.10 or later

Docker-compose

v2.3.4 or later

Podman

v4.4.1 or later, Linux Kernel 4.18 or later on Linux Red Hat Enterprise Linux 8 or later.

Podman-compose

v1.0.6 or or later

Kubernetes

v1.17 or later

Monitoring database

Tibero 6 FixSet06 or later Tibero 7

Monitoring database operating system

  • Linux:

    • CentOS 7 (64-bit)

    • Red Hat Enterprise Linux 7, 8.1~8.6 (64-bit)

    • Oracle Linux 8.6 (64-bit)

    • Rocky Linux 8.6 (64-bit)

    • ProLinux 7.5 (64-bit)

    • AIX 7.2 (64-bit)

  • [Note]

    • C++11-supported compiler

    • gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44) or later

    • laterGLIBCXX_3.4.19 or later

    • GLIBC_2.17 or later

Note

'Monitoring Database' can only be monitored for databases installed on operating systems listed in the 'Monitoring Database Operating System' list.


2. Hardware and software

The hardware and software requirements for installing SysMaster DB 8.3 are as follows.

Category
Specifications

CPU

8 Core

RAM

32 GB

Storage

30 GB or more (additional 50 GB per day may be required depending on the data retention period (RETENTION_DAY))

Web browser

Chrome (latest version recommended)

Note

Specifications are based on a total of 600 active sessions (60 active sessions × 10 instances).


The recommended patches for the monitoring database of SysMaster DB 8.3 are as follows.

Patch Number
Patch contents

240373

Improved missing OS user and machine information in sessions where the program is PE_SLAVE.

[Note] If this patch is not applied, OS user and machine information will be missing in sessions where the program is PE_SLAVE.

276404

Improved issue where a new physical plan was generated each time the internal query executed when querying Tibero's global view.

[Note] In SysMaster DB 8, global views are queried every second to collect lock information. If this patch is not applied, a physical plan is generated every second for a specific SQL statement, which may cause a no response issue when querying the SQL statement in [Analysis] > [Plan Analysis], etc.

279651f

libtpmstat library creation

[Note] If this patch is not applied, the libtpmstat library must be distributed along with the TPM Agent installation. TPM Agent 8.1.3 and later are not compatible with patches 279651e or earlier, so patch 279651f or later is required. Regardless of the 279651 patch version applied to Tibero, the 279651 patch version used during TPM Agent build must match the 279651 patch version of the library.

281081

V$TEMPSEG_USAGE view SESSION_NUMBER column value display issue improved

[Note] If the patch is not available, incorrect information may be displayed in the [Realtime] > [Usage Monitoring] > [Temp Usage], [Analysis] > [Usage Analysis] > [Temp Usage] menu.

304981b

[Note] If this patch is not applied, OS User and Machine information may be displayed incorrectly in SQL Trace information. 279651f Patch must be applied first, and is not compatible with patches below 279651e.

307175a

Fixed an issue where SQL Trace information was not collected for closed sessions.

[Note] If this patch is not applied, SQL Trace information may be significantly missing in environments where sessions are frequently opened and closed.

328607b

Fixed an issue where wait count and time were incorrectly adjusted for wait events when collecting wait count and wait time information.

[Note] Without this patch, wait time and wait count values may be displayed inaccurately.

304770a

TSC monitoring-specific patch [Note] If the patch is not installed, the information below will not be available in the V$DATABASE view, and TSC monitoring information will be displayed incorrectly, such as primary and standby not being distinguished.

1) OPEN_MODE에 value 추가
    - READ ONLY WITH APPLY

2) PROTECTION_MODE
   : Protection mode currently in effect for the database
    - UNPROTECTED
    - PROTECTION
    - AVAILABILITY
    - PERFORMANCE

3) DATABASE_ROLE
   : Current role of the database
    - PRIMARY
    - PHYSICAL STANDBY
    - LOGICAL STANDBY (TODO)
    - SNAPSHOT STANDBY
    - CASCADING STANDBY

4) STANDBY_BECAME_PRIMARY_TSN
   : TSN at which the physical standby database became primary

5) STANDBY_BECAME_PRIMARY_DATE
   : Time at which the physical standby database became primary

338513a

This patch is required for actual TPR integration. Only the package creation script needs to be executed without server patches.

338594a

This patch fixes a bug in the Tibero package that fails to delete TPR report files created on the Tibero server during TPR integration.

[Note] The TPR integration function works even without this patch, but the report files accumulate on the server and need to be deleted periodically.

Manual deletion of report files: Periodically delete report files starting with .tpr as follows.

rm -f .tpr*

149894l

This patch is required because TPR snapshot queries use a query not supported in Tibero 6 without this patch. Without this patch, queries will not work in Tibero 6.

250728f

Patch that enables viewing the V$INSTANCE view from the standby instance. Without this patch, the instance is not clustered.

Last updated