jdbc_response probe fails to connect to Oracle database

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Cannot monitor Oracle  databases with the jdbc_response probe.  The loglevel 5 logs captured from the probe generate an error message similar to the following when the probe is activated, or when testing the connection to the database:
Could not connect to jdbc:oracle:thin:@<server>:<port>:<database>. No matching authentication protocol.

 

 

 

Environment

jdbc_response probe  version 1.23,1.24

Cause

Oracle improved authentication security with the newer release which prevents older oracle jdbc drivers from successfully authenticating when logging into the older database server.

Resolution

1. Deactivate the jdbc_response probe.
2. Download a copy of the compatible ojdbc.jar jdbc driver jar file for the Oracle  database from Oracle.
3. Rename the downloaded jar file to oracle.jar
4. Replace the <installPath>\Nimsoft\probes\database\jdbc_response\lib\oracle.jar file on the robot where you have the jdbc_response probe installed with the renamed jar file that you downloaded.
5. Activate the jdbc_response probe.

Additional Information