I have an Oracle database Listener that requires Oracle Advanced Encryption (OAE) from the client. This works when using the Oracle 12c Drivers and the SQLNET.ORA file with the appropriate encryption settings, but not from your Oracle SQL V2 sensor. I get an "ORA-12537: Network Session: End of file" error message from the sensor.

Your KB https://helpdesk.paessler.com/en/support/solutions/articles/52803-how-do-prtg-sensors-connect-to-oracle-databases pointed to dotConnect for Oracle—Using Direct Mode which alluded to supporting OAE if certain settings were set, but it didn't show where in PRTG one could do that.

Is there a settings file/registry setting that PRTG users can access to turn on the appropriate OAE settings? If not, is there a way to have the sensor use OCI (assuming I install the Oracle 12c Drivers on the PRTG Windows box?

Article Comments

Hello Bill,

The KB article you've mentioned might not apply as it refers to the old SQLv1 sensors. Before consulting the developers about it, these details would be interesting:

  • Which PRTG version do you have currently running? Changelog of version 16.3.25.5488/5489 stated something about "Fixed an issue caused by the connection encryption of the Oracle SQL v2 sensor."
  • Make sure to have the latest version of .NET running on the probe system (aka PRTG server or remote probe if applicable).
  • Run SQLv2.exe manually located in prtg_install_directory/Sensor System, it's basically what the sensors use and has a little gui for manual testing. What do you get there? Same error?

Thank you & Kind regards,

Erhard


Feb, 2017 - Permalink

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>

Jan, 2018 - Permalink

Hi Bill,

Could you try to use the ADO method within the sensor? The connection strings for oracle are elaborated here: https://www.connectionstrings.com/oracle/

Kind regards
Stephan Linke, Tech Support Team


Jan, 2018 - Permalink