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

Document ID : KB000088427
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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) 

 
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.