Are there any recommandations, what to install on a Windows Server 2012R2 to monitor tables in Oracle Schemas using ADO SQL (so without the Oracle SQL Sensor - because we do not want to place the sensor on the Oracle server but on the applicationserver, so even if you don't have the permission to view the database server, you can still use some database monitoring using SQL)? I don't want to install a full Oracle SQL Client on my PRTG cluster nodes. Or are there any thirdparty drivers (OLEDB oder ODBC) you'd recommend?
Thank you
Article Comments
I can not use the Oracle SQL v2 sensor, because the user who wants to see SQL Data is not allowed on the Oracle servers, so I wanted to put the sensor on a server, he's allowed to access. To use oracle ADO SQL, you need to install some parts of the oracle client. Do you know,what needs to be installed? In Server 2012 R2 MS dropped support for the build-in oracle odbc client.
Aug, 2015 - Permalink
I'm not sure if I get you correct, but the Oracle SQL v2 sensor doesn't need anything to be installed on the oracle servers. It just needs valid credentials in order to access it :)
Aug, 2015 - Permalink
The server I want to put the sensor on is not the databaseserver, it's an applicationserver. If I use the Oracle SQL v2 sensor, I can give a system ID but no server name, connectstring, ...
That's why I need to use ADO SQL, if the Oracle SQL v2 sensor would support giving a servername and so on (so the full extract of the connection string ie. and the username / password for the user used to connect).
Aug, 2015 - Permalink
Couldn't you simply add the database server as a device and put the Oracle v2 server there? There's nothing that would be installed on the actual oracle server. The sensor just uses the server address and the DB credentials from "Credentials for Database Management Systems" to connect to the database.
If you insist to use the connection strings, .NET 3.5 should come with an OracleClient.dll that allows ADO to work - Connection Strings for Oracle.
However, I'm not sure what versions of Oracle are compatible to ADO :/
Aug, 2015 - Permalink
Adding the Oracle server and a oracle v2 Sensor works for me, but only for single servers. Do you have an idea how to add an Oracle RAC? It's just not one servername.
Aug, 2015 - Permalink
Sorry, we don't have any experiences with Oracle RAC. Guess you have to create multiple devices then ...
Aug, 2015 - Permalink
Okay, what I did now is: I created both RAC nodes as a server and created Sensors (Oracle SQL/Oracle SQL v2/Custom Script (for a query where the rows (channnels) given, change dynamically) for both of them. Than I build a new Device and put Sensor Factory sensors on it and combinded the sensors from both nodes into one.
Thank you.
Aug, 2015 - Permalink
Did you already tey the Oracle SQL v2 sensor? You don't need the
client any longer with that:
Requirements
You could also use the ADO SQL sensor and the corresponding oracle connection string (http://www.connectionstrings.com/oracle/). Although the sensor doesn't offer as much flexibility as the Oracle SQL v2 sensor in terms of result evaluation.
Jul, 2015 - Permalink