> Services > Oracle DB Query (REGEX)

Oracle DB Query (REGEX)

The Oracle DB Query (REGEX) service monitors the results of an SQL query sent to an Oracle database. The data returned by the SQL query is then evaluated against the regular expressions specified in the service.

SolarWinds MSP recommends that you use a user name with View-Only privileges when configuring the service.

The Library used is the native Oracle library. There is no extra configuration required on the client or server side as long as the listener has been correctly configured.

Helper tool (DatabaseInvoker.exe)

To check the connectivity or query results for the Oracle server from a monitored device, run the DatabaseInvoker.exe located in the Probe or Agent bin folder. For more data, open the outfile.txt (located in the same folder) to find the column name and check values before configuring service details.

Service Status

Service Type

Oracle

Instances on a Device

200

Supported Systems/Applications

Oracle DB server 10.2 or higher

Device Class

Server - Generic and Server - Windows

Monitored By

Windows Agent or Windows Probe

Note: If a device has an Agent installed and the service is added, the monitoring is done by the Agent only. An Agent can be used to monitor a remote Oracle server if the IP/Hostname is set in the Service Details.

Scan Interval

15 minutes

Connection Timeout Value

Time (in seconds) the Agent or Probe will wait for a connection response from an Oracle server before timing out.

This value is used the in Connection String in place of [CONNECT_TIME_OUT_VALUE].

Query Timeout Value

Time (in seconds) the Agent or Probe will wait for a query response to return from an Oracle server before timing out.

Hostname or IP address

Hostname or IP address of the Oracle listener.

This value is used in the Connection String in place of [HOSTNAME_VALUE].

Instance Port

Port number of the Oracle listener.

This value is used in the Connection String in place of [PORT_VALUE].

SERVICE_NAME

SERVICE_NAME set up in listener.ora. Using SID, change the connection string accordingly.

This value is used in the Connection String in place of [SERVICE_NAME_VALUE].

Server Type

Oracle server type, dedicated, shared, etc.

This value is used in the Connection String in place of [SERVER_TYPE_VALUE].

Connection String

Enter the connection string in the Connection String field under Service Details or have the Agent or Probe assemble the connection string by replacing the value provided in the service details. Note: If you enter the complete connection string, the password will appear in plain text and is visible.

The default connection string is set in TNS format. To connect using EZ connection, use the following format:

Data Source=[HOSTNAME_VALUE]:[PORT_VALUE]/[SERVICE_NAME_VALUE];User Id=[USERNAME_VALUE];Password=[PASSWORD_VALUE];Connection Timeout=[CONNECT_TIME_OUT_VALUE]

The Agent or Probe will replace the entities enclosed in brackets in the connection string with the value inputted in Service Details. This allows you to change the connection string as required.

Database Username

Username used to access the instance.

This value is used in the Connection String in place of [USERNAME_VALUE].

Database Password

Password used to access the database.

This value is used in the Connection String in place of [USERNAME_VALUE].

Database Query

SQL query statement submitted to the database. As a best practice, specify the column name in the query and avoid using “*”.

Numeric Column Name

Specify a column name that represent a numeric values. The column name could be the table column name or the name specified as "AS." This value will be threshold against you can set your threshold accordingly. If the Column Name is incorrect there service show as failed.

Column 1-5 Name

(Optional) Specify the Column that you want to return as string presentation.

Values display in Scan Details and provide additional detail on other table columns. If you specify a column name that doesn’t exist, the service will display as Failed.

Oracle DB Query (Number)

Transaction time in milliseconds

Time to connect, authenticate, send a query, retrieve results, and disconnect.

Total Number Of Rows returned by The Query

Number of rows returned by a query.

Numeric Value Returned

Numeric value presentation of the Column name specified in Numeric Column Name (see above).

Column 1-5 Value

String representation of Column 1-5 value (see above).