Talend Remote Engine IO Error: The Network Adapter could not establish the connection

[Sirasit_Mahawanitwong]

Hi

I have Talends jobs which connection to oracle databases and convert into CSV files. The jobs are deploy on Talend Remote Engine and it ran well until all sudden, it got the following error:

tDBInput_1 IO Error: The Network Adapter could not establish the connection

java.sql.SQLRecoverableException: IO Error: 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 java.sql.DriverManager.getConnection(DriverManager.java:664)

    at java.sql.DriverManager.getConnection(DriverManager.java:208)

    at thaioil.lims_labvantage_zcrudeflex_incre_0_1.LIMS_labvantage_ZCrudeflex_Incre.tDBInput_1Process(LIMS_labvantage_ZCrudeflex_Incre.java:4870)

    at thaioil.lims_labvantage_zcrudeflex_incre_0_1.LIMS_labvantage_ZCrudeflex_Incre.runJobInTOS(LIMS_labvantage_ZCrudeflex_Incre.java:10754)

    at thaioil.lims_labvantage_zcrudeflex_incre_0_1.LIMS_labvantage_ZCrudeflex_Incre.main(LIMS_labvantage_ZCrudeflex_Incre.java:10301)

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.establishConnection(NSProtocol.java:661)

    at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:202)

    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)

    ... 9 more

Caused by: java.io.IOException: Connection timed out, socket connect lapse 127226 ms. /10.65.18.87 1521 0 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)

    ... 16 more

Caused by: java.net.ConnectException: Connection timed out

    at sun.nio.ch.Net.connect0(Native Method)

    at sun.nio.ch.Net.connect(Net.java:454)

    at sun.nio.ch.Net.connect(Net.java:446)

    at sun.nio.ch.SocketChannelImpl.connect(SocketChannelImpl.java:645)

    at java.nio.channels.SocketChannel.open(SocketChannel.java:189)

    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)

    ... 18 more

Noted that some other Oracle databases did work as normal.

Now I try to telnet from the Talend Remote Engine to the database with following command

telnet 10.65.18.89 1521

Trying 10.65.18.89...

Connected to 10.65.18.89.

Escape character is '^]'.

I check the connection info and nothing wrong with them.

I really don't know what could cause this error.

[prg]

Hello @Sirasit Mahawanitwong​,

Please ensure there is connectivity between Studio, Jobserver platform, and the Oracle Server hosting the Database using ping, telnet, and tracers, sqlplus command.

- Please make sure your tnsnames.ora is complete and has the databases you wish to connect to.

- Please make sure you can tnsping the server you wish to connect to On the server, make sure it will be open on the port you desire with the specific application you are using.

Possible Root Cause for The Network Adapter could not establish the connection error

1. the 'hostname, port, sid/service name' combination is invalid

2. the database is NOT registered with the listener.

3. the database is NOT started.

Please revert back to the community, if needed.

Regards,

Vaishnavi