Can not connect to Oracle database using database agent

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Can not connect to Oracle database using database agent

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

Symptoms

The Connection object which is used for SQL Variable displays the error messages when click "Test Connection" 

" U2000112 Remote system is not available via connection object"   

 In the agent's log file there are errors: 

- java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver  or 

-  java.lang.UnsatisfiedLinkError: oracle.jdbc.driver.T2CConnection.getLibraryVersionNumber()I" 

 

---

Cause

- JDBC Driver is missing in the "jdbc" folder of agent installation 

- the ojdbc6.jar version in JDBC folder of db service agent does not match the oci libary version in Oracle Client. The jar must have the same version (not newer, not older). 

 

---

Resolution

For both database type: Oracle OCI (Oracle Client Interface) and Oracle JDBC, the JDBC Driver is needed (should be put inside "jdbc" folder of agent installation) 

After the JDBC driver ojdbc6.jar is copied to the jdbc folder, the agent MUST be restarted to take effect 

If the error U2000112 still shows up and in the agent's log file, the message "java.lang.UnsatisfiedLinkError.." remains, then the steps belows should be taken: 

+ Delete the existing jdbc drivers from /opt/uc4tst/agents/sql/bin/jdbc - this means "rm /opt/uc4tst/agents/sql/bin/jdbc/*" 

+ Copy the jdbc driver from the oracle installation: "cp /app/oracle//product/ofm11/Oracle_FRHome1/jdbc/lib/ojdbc6.jar /opt/uc4tst/agents/sql/bin/jdbc/ojdbc6.jar" 

After that, restart the DB_SERVICE agent; this should solve the problem