Werk #16023: Use oracledb over cx_Oracle module for Oracle DB in check_sql

Component

Checks & agents

Title

Use oracledb over cx_Oracle module for Oracle DB in check_sql

Date

Aug 10, 2023

Level

Trivial Change

Class

Bug Fix

Compatibility

Compatible - no manual interaction needed

Checkmk versions & editions

2.3.0b1 Not yet released	Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk Cloud (CCE), Checkmk MSP (CME)
2.3.0b1	Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk Cloud (CCE), Checkmk MSP (CME)
2.2.0p8	Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk Cloud (CCE), Checkmk MSP (CME)

The python module cx_Oracle is replaced by oracledb to support Python 3.11 for Oracle database checks with the check_sql active check. In order to use the check_sql with an Oracle DB it is now necessary to install the oracledb python package with:

python3 -m pip install oracledb --upgrade

To the list of all Werks