Consider enabling keep-alive for the OracleDB ODBC monitor.

XMLWordPrintable

    • Type: Incident report
    • Resolution: Unresolved
    • Priority: Trivial
    • None
    • Affects Version/s: 7.0.20
    • Component/s: Templates (T)
    • Support backlog

      When monitoring using "Oracle by ODBC", monitoring stop.
      The odbc poller process appears to be in an infinite loop waiting for a response from the other end.

      I think this situation can be alleviated by adding an option to enable keep-alives.

      For example, "Get tablespace"

      • write it directly
        Before change:
        db.odbc.get[get_tablespace,,"Driver={$ORACLE.DRIVER};DBQ=//{$ORACLE.HOST}:{$ORACLE.PORT}/{$ORACLE.SERVICE};"]
        

        After change:

        db.odbc.get[get_tablespace,,"Driver={$ORACLE.DRIVER};DBQ=//{$ORACLE.HOST}:{$ORACLE.PORT}/{$ORACLE.SERVICE}?enable=broken;"]
        
      • use a user macro
        macro
        name:value
        {$ORACLE.TCP.KEEPALIVE} : ?enable=broken
        

        item key:

        db.odbc.get[get_tablespace,,"Driver={$ORACLE.DRIVER};DBQ=//{$ORACLE.HOST}:{$ORACLE.PORT}/{$ORACLE.SERVICE}{$ORACLE.TCP.KEEPALIVE};"]
        

      https://docs.oracle.com/en/database/oracle/oracle-database/21/netrf/local-naming-parameters-in-tns-ora-file.html#GUID-7A18022A-E40D-4880-B3CE-7EE9864756CA

            Assignee:
            Zabbix Integration Team
            Reporter:
            Itsuki Karimata
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: