Can not connect to Oracle database using database agent

Document ID : KB000090322
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Can not connect to Oracle database using database agent
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