I am trying to configure, in metadata, a connection to a remote oracle database. I chose an oracle connection with SID When I test the connection I get the following error message:
Echec de la connexion Vous devez modifier les paramètres de la base de données. java.lang.RuntimeException: java.sql.SQLRecoverableException: Erreur d'E/S: The Network Adapter could not establish the connection 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.SQLRecoverableException: Erreur d'E/S: The Network Adapter could not establish the connection 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: The Network Adapter could not establish the connection at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:571) at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:548) at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:682) at oracle.net.ns.NSProtocol.connect(NSProtocol.java:309) at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1596) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:588) ... 15 more Caused by: java.io.IOException: Permission denied: connect, socket connect lapse 1 ms. /10.89.14.206 1521 15000 1 true at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:233) at oracle.net.nt.ConnOption.connect(ConnOption.java:174) at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:510) ... 20 more Caused by: java.net.SocketException: Permission denied: connect at sun.nio.ch.Net.connect0(Native Method) at sun.nio.ch.Net.connect(Unknown Source) at sun.nio.ch.Net.connect(Unknown Source) at sun.nio.ch.SocketChannelImpl.connect(Unknown Source) at java.nio.channels.SocketChannel.open(Unknown Source) at oracle.net.nt.TimeoutSocketChannel.connect(TimeoutSocketChannel.java:99) at oracle.net.nt.TimeoutSocketChannel.<init>(TimeoutSocketChannel.java:77) at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:192) ... 22 more
To access the Oracle database server, I have to go through a VPN (Pulse Secure). I'm using TOS 7.3.1 and I'm on Windows 10. Anyone have a solution?
I advanced on the subject. If I create a job and use, for example, an Oracle tDBInput, and launch the job, I manage to connect to the database and retrieve the data from a table. It is therefore, at the metadata level that this does not work. With this solution, I have to configure the schema manually. Any idea to make metadata work?
