Top Tags

Oracle SQL sensors for specifc system

0

We want monitor specific oracle database to our company, we need to specify a specific account to access these data and a string type of output format in a text file, how can do this with sensors SQL prtg?

3 Replies

1

you would use an SQL Sensor from PRTG? Why you want to get an text file? All informations of PRTG are stored to the local database.

I'm not sure why a text file is useful. Maybe you can make this clear, how you want to use it :).

In order to monitor the sql server, you can choose Oracle SQL or the Oracle SQL v2 to get informations.
For this you have to know the service with username and password (as you said before) and then the sql request.

I don't use OracleSQL before, so i compare it from MSSQL, MySQL and ADO. But maybe i could help you, too.

0

We want monitor some services of an Electronic Document Management implemented on an oracle system (connection, job failure, lock, ....).
We try to use the Oracle SQL sensor v2 Beta, but it doesn't allow to use explicit credentials for the database connection (Contrary to what the doc says).
So we try to use the Oracle SQL sensor (V1), we got the "OK" but it does not return any values.

0

Ok is the result, if the match isn't there or is there, defines from your settings. You can Match with numbers or characters or changes. But i think this is not the thing you want. v2 allows you to get an data table and check single fields. This is maybe more the thing you want.

What is the error you got, if you want to connect via explicit connection string to Oracle Database?
In v2 you can also define the data table als message in message-box.

Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.