Werk #14790: Handle special oracle version 12.1.0.1

Name: checkmk
Rating: 4.7 (114 reviews)

Component

Checks & agents

Title

Handle special oracle version 12.1.0.1

Date

Nov 30, 2022

Level

Trivial Change

Class

Bug Fix

Compatibility

Compatible - no manual interaction needed

Checkmk versions & editions

2.2.0b1	Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk Cloud (CCE), Checkmk MSP (CME)
2.1.0p19	Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)
2.0.0p33	Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)

You're affected if you're using mk_oracle for linux and the oracle version 12.1.0.1 (SE One). The agent plugin may output something like:

   ,vp.block_size pblock_size, vp.recovery_status precovery_status
                               *
ERROR at line 28:
ORA-00904: "VP"."RECOVERY_STATUS": invalid identifier

Background information:

the oracle version 12.1.0.1 (SE One) is missing the recovery_status, see https://docs.oracle.com/database/121/REFRN/GUID-A399F608-36C8-4DF0-9A13-CEE25637653E.htm#fnsrc_d1698612e372
this version of oracle shouldn't be used anymore in production as it is EOL
for installations which are still using this version, we're now falling back to a supported query

To the list of all Werks