Werk #10671: mk_oracle: Support for Custom SQL with Remote Monitoring

The new feauture Custom SQL could be used with Remote Monitoring as well. Be aware that the configuration of Custom SQL and Remote Monitoring is not easy...

The SQLS_ITEM_SID is mandatory in this configuration. Otherwise the value from SQLS_SIDS is used in the service name during Discovery.

The following example shows only the needed parameter for a configuration. This is not complete for a whole mk_oracle.cfg!

Example mk_oracle.cfg:

REMOTE_INSTANCE_1_db1=c##cmk:cmkpass::dbhost:1524:piggybackhost:db191:19

SQLS_SECTIONS="invalid_objects"
SQLS_DIR=/etc/check_mk
SQLS_MAX_CACHE_AGE=10

invalid_objects () {
    SQLS_SIDS=REMOTE_INSTANCE_1_db1
    SQLS_ITEM_SID=db191
    SQLS_SQL=invalid_objects.sql
}

Zur Liste aller Werks