jdbc_response probe fails to connect to Oracle 12c database

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

  

Cannot monitor Oracle 12c 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.

 

 

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

Environment

jdbc_response probe through the current GA release version 1.23

Resolution

1. Deactivate the jdbc_response probe.
2. Download a copy of the ojdbc7.jar jdbc driver jar file for the Oracle 12c 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

Link to a copy of the Oracle 12c jdbc driver jar file:
http://www.oracle.com/technetwork/database/features/jdbc/default-2280470.html
As always, please contact CA Technologies support for CA UIM if you have further questions.