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