topic Re: Oracle OCI connection problem in Talend Studio

Oracle OCI connection problem

cd160 — Fri, 10 May 2019 07:50:29 GMT

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

Re: Oracle OCI connection problem

manodwhb — Fri, 10 May 2019 11:22:43 GMT

@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-names

Re: Oracle OCI connection problem

manodwhb — Fri, 10 May 2019 11:27:41 GMT

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

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

Re: Oracle OCI connection problem

cd160 — Mon, 13 May 2019 07:40:23 GMT

@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.

Re: Oracle OCI connection problem

manodwhb — Mon, 13 May 2019 18:29:31 GMT

@cd160 ,it should be on data based server

Re: Oracle OCI connection problem

cd160 — Fri, 17 May 2019 07:43:36 GMT

@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?