Werk #14790: Handle special oracle version

Komponente Checks & agents
Titel Handle special oracle version
Datum 30.11.2022
Checkmk-Editon Checkmk Raw (CRE)
Checkmk-Version 2.2.0i1 2.1.0p19 2.0.0p33
Level Kleine Änderung
Klasse Bugfix
Kompatibilität Kompatibel - benötigt kein manuelles Eingreifen

You're affected if you're using mk_oracle for linux and the oracle version (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 <\tt>

Background information:

  • the oracle version (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

Zur Liste aller Werks