Oracle DB Query (Number) service

The Oracle DB Query (Number) service runs user-specified queries to return specified columns as numeric representations.

N-able 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

To check the connectivity or query results for the Oracle server from a monitored device, run the helper tool, 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 TypeOracle
Instances on a Device200
Supported Systems/ApplicationsOracle DB server 10.2 or higher
Device ClassServer - Generic and Server - Windows
Monitored By

Windows agent or Windows probe

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

Scan Interval15 minutes
Connection Timeout ValueTime 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 ValueTime in seconds the agent or probe will wait for a query response to return from an Oracle server before timing out.
Hostname or IP addressHostname or IP address of the Oracle listener. This value is used in the Connection String in place of [HOSTNAME_VALUE].
Instance PortPort number of the Oracle listener. This value is used in the Connection String in place of [PORT_VALUE].

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 TypeOracle 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:


The agent or probe replaces the entities enclosed in brackets in the connection string with the value inputted in Service Details. This enables you to change the connection string as required.

Database UsernameUsername used to access the instance. This value is used in the Connection String in place of [USERNAME_VALUE].
Database PasswordPassword used to access the database. This value is used in the Connection String in place of [USERNAME_VALUE].
Database QuerySQL query statement submitted to the database. As a best practice, specify the column name in the query and avoid using “*”.
Numeric Column NameSpecify a column name that represent a numeric values. The column name could be the table column name or the name specified as "AS." If the Column Name is incorrect, the service will indicate Failed.
Column 1-5 Name
  • Name of the database values being queried for the value.
  • Values that N-able N-central should look for in the results of the Oracle query.

 If there is more than one column and regex the result is AND operation. For example, if users have specified column 1 and regex 1 and column 2 and regex 2, both conditions should return "True" for the service to indicate normal status.

Oracle DB query (number)

Transaction time in millisecondsTime to connect, authenticate, send a query, retrieve results, and disconnect.
Total Number Of Rows returned by The QueryNumber of rows returned by a query.
Rows returned by the query that matched all column regular expressions.The number of rows that matched all of the column regular expressions.