Sorry for the delay in the response, finally got back to this project.
We are running PRTG Network Monitor 17.2.31.2153.
We have .NET Framework 4.7 installed on our Windows Server 2012 R2 Standard virtual server running in 64 bit mode with 8 Gb of RAM.
When I run SQLv2.exe with database settings of
- Type=Oracle
- Server=<DNS NAME OF SERVER>
- Port=1521
- SID=<SERVICE NAME FOR DB>
- Username=<ORACLE USERNAME>
- Password=<ORACLE PASSWORD>
- Query="select count(spriden_pidm) from saturn.spriden"
with defaults for all the Data Settings, I get "Connection request timed out".
From the same machine using Oracle 12C full drivers 12.1.0 using Oracle's SQL Developer 4.1.4 and TNSNAMES.ORA, I can successfully connect to the host at that port with that service name/userid/password using Oracle Encryption that is enforced by the server.
When using the sensor in PRTG, to exactly duplicate our TNSNAMES.ORA Setting
-------------------------
bpr1_dr =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = <DNS NAME OF SERVER>)(Port = 1521))
)
(CONNECT_DATA =
(UR = A)
(SERVICE_NAME = <SERVICE NAME FOR DB>)
)
)
-------------------------
, I have been appending the extra line in CONNECT_DATA to the Service Name, e.g. <SERVICE NAME FOR DB>)(UR=A
Here is the result from the Result of Sensor...log file:
{{{-------------------------
10.01.18 10:49:46: Connections String: USER ID=<ORACLE USERNAME>;CONNECTION TIMEOUT=60;PASSWORD=<ORACLE PASSWORD>;DATA SOURCE="(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<DNS NAME OF SERVER>)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=<SERVICE NAME FOR DB>)(UR = A)))"
-------------------------}}}
Here is the Result of Sensor.....txt result file:
<prtg>
<error>1</error>
<text>Network Transport: TCP transport address connect failure</text>
</prtg>
Add comment