jdbc_response probe 1.27.0 not connecting to Oracle 12 after upgrade when TLS is enabled

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

I recently upgraded the jdbc_response probe from an older version to 1.27.0 and now all my Oracle 12 database connections are failing to connect.

Downgrading to 1.26.1 allows them to connect again.

Errors like the following keep repeating over and over in the logs:

Nov 01 15:30:59:787 [Thread-50, jdbc_response] Checking Result for current value
Nov 01 15:30:59:787 [Thread-50, jdbc_response]  null
Nov 01 15:30:59:787 [Thread-50, jdbc_response] returning result
Nov 01 15:30:59:787 [Thread-42, jdbc_response] Profile (ProfileName)
Nov 01 15:30:59:787 [Thread-42, jdbc_response]      connect time = -1.0
Nov 01 15:30:59:787 [Thread-42, jdbc_response]      prepare time = -1.0
Nov 01 15:30:59:787 [Thread-42, jdbc_response]        query time = -1.0
Nov 01 15:30:59:787 [Thread-42, jdbc_response]       result time = -1.0
Nov 01 15:30:59:787 [Thread-42, jdbc_response]        close time = -1.0
Nov 01 15:30:59:787 [Thread-42, jdbc_response]     response time = -1.0
Nov 01 15:30:59:787 [Thread-42, jdbc_response]  Profile (ProfileName) time : -1.0
Nov 01 15:30:59:788 [Thread-42, jdbc_response] Profile (ProfileName) connect time = -1.0 prepare time = -1.0 query time = -1.0 result time = -1.0 close time = -1.0 tresponse time = -1.0

This is only affecting profiles with TLS enabled and an Oracle Wallet Defined.

How can I connect to these servers with jdbc_response 1.27.0?

Environment

jdbc_response probe 1.27.0

Oracle 12 Database  

TLS Enabled

Cause

missing jar files

Resolution

The probe requires some additional jar files to use Oracle Wallets (TLS).  This is a requirement of the ojdbc8 driver.  It will only impact Oracle 12 using OJDBC 8 to connect.  Oracle 19/OJDBC 11 are not affected.

You need to use all the three jars while using Oracle Wallets. 

(1) oraclepki.jar (309752 bytes ) - (SHA1 Checksum: eb09d25408b64a4249dc31a7347f862eac6e288b

(2) osdt_cert.jar (210567 bytes) - (SHA1 Checksum: 2cdf20055b540ab743e8d1c18cfb69fd76088a68)

(3) osdt_core.jar (312560 bytes) - (SHA1 Checksum: 2a0eb779abfe2cd31d9352da7b8c2e58c05fe427)

These files can be downloaded from Oracle directly.

Copy these files into the folder (UIM HOME)/nimsoft/probes/database/jdbc_response/lib  and then restart the probe.