-
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=brokenitem key:
db.odbc.get[get_tablespace,,"Driver={$ORACLE.DRIVER};DBQ=//{$ORACLE.HOST}:{$ORACLE.PORT}/{$ORACLE.SERVICE}{$ORACLE.TCP.KEEPALIVE};"]