Our Oracle Database (12g) is under the same IP-Adress with different credentials for every tablespace. For the correct running of the Sensor "Oracle SQL" we need for every tablespace a DEVICE - is there annother posibility?
The Oracle SQL-Sensor works correct with this configuration. When we clone the same SENSOR under another DEVICE (for example an application server with another IP-Adress) and define the same credentials for Oracle Databases, it will not work. We receive the error message "Netzwerktransport: Verbindungsfehler bei TCP-Transportadresse" - what's wrong?
We are using the latest release of PRTG, Installed last week, Trailversion for 30 Days. Thanks for your help.
Article Comments
Attention: This article is a record of a conversation with the Paessler support team. The information in this conversation is not updated to preserve the historical record. As a result, some of the information or recommendations in this conversation might be out of date.
Hi Stephan,
Thanks fo your suggestion. We've implemented the ADO SQL v2 - Sensor instead of Oracle SQL and it works fine.
Connection string is:
Provider=msdaora;Data Source=<DataSourceName>;User Id=%dbloginuser;Password=%dbloginpassword;
replace <DataSourceName> with your corresponding datasource.
Oct, 2017 - Permalink
To avoid future problems with updates (microsoft or oracle) we have changed our provider in the connection string to the one from oracle itself "OraOLEDB.Oracle".
New Connection string: Provider=OraOLEDB.Oracle;Data Source=<datasource>;User Id=%dbloginuser;Password=%dbloginpassword;
Nov, 2017 - Permalink
Hi Urs,
You could also use the ADO SQL v2 sensor with the corresponding connection string. This allows you to specify the credentials on a per-sensor basis. Note that you can use %dbloginuser and %dbloginpassword to insert the credentials into the string.
Kind regards,
Stephan Linke, Tech Support Team
Oct, 2017 - Permalink