Werk #6480: mk_oracle: Support for Container Database (Multitenant)

Component Checks & agents
Title mk_oracle: Support for Container Database (Multitenant)
Date Aug 23, 2018
Checkmk Edition Checkmk Raw (CRE)
Checkmk Version 1.6.0b1
Level Trivial Change
Class New Feature
Compatibility Compatible - no manual interaction needed

Oracle introduced the Containerdatabase (CDB) with 12c.

Important information for the monitoring user: It is mandatory to create a specified user in Oracle. Be aware that the prefix c## is only usable in a CDB and it is not possible to use this user in non CDB (old setups!)

For Databases with CDB: * create user c##check_mk identified by "secret"; * alter user c##check_mk set container_data=all container = current; * grant create session, select_catalog_role to c##check_mk container=all;

For Databases without CDB: * create user check_mk identified by "geheim"; * grant create session, select_catalog_role to check_mk:

Incompatible Change: The plugin is compatible against non CDB environments. There was a work arround for monitoring 1 PDB inside a CDB with the old version of mk_oracle. This will not work anymore, because the plugin creates new output and the checks creates new services. Plese do a services Discovery in environments with the work arround. Don't forget to change rules for changed services.

Affected Services: * oracle_instance * oracle_jobs * oracle_performance * oracle_recovery_status * oracle_sessions * oracle_tablespaces

To the list of all Werks