jdbc_response probe fails to connect to Oracle 12c database

Document ID : KB000043256
Last Modified Date : 21/09/2018
Show Technical Document Details
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.

 

 

Background:
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
Instructions:
  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.