Talend : Fail to create an oracle connection

Question

i created a new talend project. i tried to create an oracle connection but il fails here is a screenshot

error log : Connection failure. You must change the Database Settings. java.lang.RuntimeException: java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

  at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:208)
  at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1146)
  at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
  at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:290)
  at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:4208)
  at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.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.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

  at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:854)
  at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
  at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57)
  at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747)
  at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562)
  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:199)
  ... 9 more

Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

  at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:284)
  at oracle.net.ns.NSProtocol.connect(NSProtocol.java:340)
  at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1596)
  at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:588)
  ... 15 more

It doesn't look like you have Oracle's JDBC driver installed. — pmdba
Do you have an access to the internet from your local machine? Especially to maven repo. Alternatively you can download JDBC driver by yourself from Oracle's site. — astentx

Amine Ben Khelifa Amine Ben Khelifa · Accepted Answer · 2021-04-22T07:36:20

Could you do these steps ? Go to windows-> Preferences -> General -> Network Connections -> change the active Provider to Native

Talend : Fail to create an oracle connection

1 Answers