Test CONN object fails with error "U02000112 Remote System is not available via Connection Object"

Products

• CA Automic One Automation

Issue/Introduction

Clicking "Test" button in CONN object gives error: "U02000112 Remote System is not available via Connection Object"

Same time, the SQL VARA object gives error upon clicking the "Preview":

Failed to create a connection to the database ('com.uc4.ex.sql.ConnectionException:java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver').

Cause

The required jar file is missing.

Environment

Release : 12.3

Component : DB Service Agent for SQL Varas

Resolution

Copy the required jdbc jar file to below locations: 

1. ...\Agents\db_service\bin\jdbc 
2. ...\Agents\sql\bin\jdbc

and restart the DBService Agent.