Config Info
Name Oracle Connection Test
Version 1.0

About

This monitor executes the query :

SELECT * FROM v$version 

The goal is to monitor the availability of the ODBC and the response time.

How to use it

  1. Import the monitor
  2. Replace HOSTNAME, DBNAME as well as user and passwords.

Messages sent

To filter, the text DB-CONNECTION-TEST is sent as VAR04 

Monitor - HOSTNAME - DBNAME - Connection Test

General

Property Value
ClassID ODBCAgent.1
CreateEventWhenNoData true
Description HOSTNAME - DBNAME - Connection Test
GenerateHealthEvent 2
Name HOSTNAME - DBNAME - Connection Test
RedirectHealthEvent 5

 

Script - Set Health Wizard

Health Rules

Criticity Code
Critical not VSMDataRetrievalOK
Warning VSMResponseTime > 5
Minor  
Success True

 

Templates

Criticity Code
Critical &Host : Could not connect (ODBC : &DBName )

Error : &VSMDataRetrievalErrorDescription

Warning &Host : High connection response time (ODBC : &DBName )

Response Time : &VSMResponseTime s

Minor Minor error retrieving ODBC information
Success &Host : No connection problem (ODBC : &DBName )

Response Time : &VSMResponseTime s

 

Sent Variables

ID Variable
VAR02 Host
VAR03 DBName
VAR04 DB-CONNECTION-TEST
VAR05 VSMResponseTime
VAR06 VSMDataRetrievalErrorDescription
VAR07 VSMDataRetrievalErrorCode

 

Datasource - ODBC DataSource

General

Property Value
ClassID ODBCAgent.1
Description  
ErrorRetryTime 60
IntervalRetries 10
Kind 0
Name ODBC DataSource
Retries 1
SharingKind 1
Timer 60

 

Implementation

Property Value
DBName DBNAME
Host HOSTNAME
NumberOfRows 1
PassEncryption LEVEL1
Password 70C043874CC03138
Query SELECT * FROM v$version
Reconnect false
SecureMode false
User user

 

See also


Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: October 18, 2018