SQL Oracle Agent job error: java.lang.Error: Incompatible version of libocijdbc[Jdbc:121010, Jdbc-OCI:121020

book

Article ID: 88427

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Affects Release version(s): null


The SQL Oracle Agent is up. But when a job is run, the agent crash with the error below:

java.lang.Error: Incompatible version of libocijdbc[Jdbc:121010, Jdbc-OCI:121020 
at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:4094) 
at java.security.AccessController.doPrivileged(Native Method) 
at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:4087) 
at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:301) 
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:715) 
at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:195) 
at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:51) 
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:564) 
at com.uc4.ex.sql.db.DriverBridge.establishConnection(DriverBridge.java:137) 
at com.uc4.ex.sql.ConnectionManager.getConnection(ConnectionManager.java:212) 
at com.uc4.ex.sql.SQLConsumer.ensureConnection(SQLConsumer.java:304) 
at com.uc4.ex.sql.SQLConsumer.execute(SQLConsumer.java:132) 
at com.uc4.ex.Job.run(Job.java:469) 
at com.uc4.ex.ThreadPool$RunnableDecorator.run(ThreadPool.java:53) 
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) 
at java.util.concurrent.FutureTask.run(FutureTask.java:266) 
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) 
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) 
at java.lang.Thread.run(Thread.java:745) 

 

Environment

Release:
Component: ARAOEB

Resolution



CAUSE: 

The Oracle thick and thin driver has to be the exact same version.

From the error message: Jdbc:121010, Jdbc-OCI:121020 

The numbers in the error message above may vary, depending on your thick and thin driver version. 

Jdbc is the Oracle thin driver (eg: ojdbc7.jar, ojdbc6.jar, etc)
Jdbc-OCI is the Oracle thick driver.

In this case, the thin driver is 12.1.0.1 and thick driver is 12.1.0.2.


SOLUTION:

The Oracle thick and thin driver has to be the exact same version.
Upgrade the driver that is lower to the same version as the other driver.
You can download the driver from the Oracle site.