Check Oracle DB by Query (Service Check)

Service Check Category: Network Connectivity Checks

Passive: No

Description: Sends a specific, user-provided SQL query to an Oracle server and compares the response the a user-supplied value. If the evaluation is "true," the check remains in the OK state. If the evaluation is "false," the check enters the CRITICAL state. This check is made through a direct SQL connection. The "Oracle Database" device subtype must be applied to the managed device to use this service check.

Check-specific Configuration Options:

(See Service Checks for configuration options common to all service checks.)

• COMMAND
  (Required) The SQL query to be used to check the database.
• COMPARATOR
  (Required) The logical operator by which to evaluate the value returned by the query.
  Acceptable values are:
  • ==
  • >=
  • <=
  • !=
  • =- (for regex)
  • !- (for inverse regex)
• VALUE
  (Required) The value to which the value returned by the query will be compared (match or not match).
• DESCRIPTION
  (Required) This field specifies a name for this check. The name entered must be unique among service check names on the host it is added to (the name may used again only on a different host). It is used to identify this specific check from among other service checks added to the same host.