Hello,

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?

Thanx you.

Regards

Nathalie Garrett

Article Comments

Hey Nathalie,

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.

Please give us more information about, what you want to do :)

Best

Sascha


Dec, 2014 - Permalink

Hi Sascha,

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.

For exemple we try with this code:

select username,count(*) from v$session group by username

Thanx you for your answer.

Regards


Dec, 2014 - Permalink

Hey Nathalie,

ok now it's more clear. Thanks for this.

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.

It is to you, to post the error code, or write an support call, because its not that, what the doc says. Support Calls please on this page ;) ( https://shop.paessler.com/en/openticket ).

Thanks

Sascha


Dec, 2014 - Permalink