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

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

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

Thanks for sharing!

Kind regards,
Stephan Linke, Tech Support Team


Nov, 2017 - Permalink