Oracle OCI connection problem

[cd160]

Hello,

I'm trying to setup an Oracle OCI database connection. I'm using TOS 6.4, and Oracle version 11.

When I check the connection, I get the following error.

Connection failure. You must change the Database Settings.
java.lang.RuntimeException: java.lang.Error: Incompatible version of libocijdbc[Jdbc:112040, Jdbc-OCI:112030
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1095)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:289)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$62.runWithCancel(DatabaseForm.java:3983)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$62.runWithCancel(DatabaseForm.java:1)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.Error: Incompatible version of libocijdbc[Jdbc:112040, Jdbc-OCI:112030
at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3563)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3556)
at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:269)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553)
at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:165)
at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:53)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:186)
... 9 more

[manodwhb]

@cd160 ,it is saying that Incompatible version of libocijdbc[Jdbc:112040, Jdbc-OCI:112030..

check the below link.

https://stackoverflow.com/questions/47220981/unable-to-connect-to-oracle-database-using-service-name...

[manodwhb]

@cd160 ,have you verified below link. if not please.

https://community.talend.com/t5/Design-and-Development/resolved-ORACLE-OCI-connection-problem/td-p/5...

[cd160]

@manodwhb , thank you for your reply. I did check this link but I got a little confused. Is this supposed to be on the database server or on my local machine where I am using Talend? ORACLE_HOME does not exist on my machine. 

[manodwhb]

@cd160 ,it should be on data based server

[cd160]

@manodwhb,

I'm confused as to why I should add ocijdbc10.dll, although the oracle version is 11 and Talend has been working fine with it. I only got this error when I tried to create OCI connection. In the solved ticket that you referred to, user is working with Talend 5.3. I'm working with version 6.4.
Isn't there anything to do from my machine or Talend side?