How to monitor Oracle 19c Cloud ATP Database using Wallet using jdb_response probe

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We are trying to use the jdbc_response probe to monitor Oracle 19c Cloud ATP Database using Wallet but we are seeing this error when we test the connection.

Jun 17 10:16:22:608 [attach_socket, jdbc_response] Caught exception loading driver for connection test : java.sql.SQLException: Io exception: Unknown host specified  

 

Environment

jdbc_response probe 1.26.1

Cause

The ojdbc jar file needs to be updated.

Resolution

1. Get ojdbc8.jar from:
   https://download.oracle.com/otn-pub/otn_software/jdbc/1922/ojdbc8.jar
2. Deactivate the jdbc_response probe.
3. Backup the lib folder.
4. Delete the ojdbc jar files.
5. Put the downloaded file in jdbc_response/lib folder
6. Activate the jdbc_response probe and test again.