tOracleOutput_1 Io exception: The Network Adapter could not establish the connection java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

Anonymous — Mon, 21 May 2018 21:06:08 GMT

I am getting below error please help in fixing this. I am using talend 7.01 Studio.

Checking ports...

Sending job 'J_User' to server (192.168.30.78:8001)...

File transfer completed.

Deploying job 'J_User' on server (192.168.30.78:8000)...

Running job 'J_User'...
Starting job J_User at 15:34 21/05/2018.

[statistics] connecting to socket on port 3639
[statistics] connection refused
0|20180521153509_VZ6hs|20180521153509_VZ6hs|20180521153509_VZ6hs|J_User|start job||20180521153717.003-0400
1|20180521153509_VZ6hs|20180521153509_VZ6hs|20180521153509_VZ6hs|User_Info|0|0|start
Unable to connect to 192.168.60.106 on the port 3639
[FATAL]: dw.J_user_0_1.J_User - tOracleOutput_1 Io exception: The Network Adapter could not establish the connection
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:257)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:389)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:454)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:802)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at dw.J_user_0_1.J_User.tOracleInput_1Process(J_User.java:1466)
at dw.J_user_0_1.J_User.runJobInTOS(J_User.java:2874)
at dw.J_user_0_1.J_User.main(J_User.java:2706)
0|20180521153509_VZ6hs|20180521153509_VZ6hs|20180521153509_VZ6hs|J_User|end job||20180521153925.032-0400
Exception in component tOracleOutput_1 (J_User)
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:257)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:389)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:454)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:802)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at dw.J_user_0_1.J_User.tOracleInput_1Process(J_User.java:1466)
at dw.J_user_0_1.J_User.runJobInTOS(J_User.java:2874)
at dw.J_user_0_1.J_User.main(J_User.java:2706)

Job J_User ended at 15:38 21/05/2018. [exit code=1]

Re: tOracleOutput_1 Io exception: The Network Adapter could not establish the connection java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

Anonymous — Wed, 23 May 2018 04:31:54 GMT

Hello,

Please stick to one topic:https://community.talend.com/t5/Design-and-Development/tOracleOutput-1-Io-exception-The-Network-Adapter-could-not/m-p/120837 so that we can pay individule attention to your issue.

Best regards

Sabrina

Re: tOracleOutput_1 Io exception: The Network Adapter could not establish the connection java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

Anonymous — Sun, 26 Aug 2018 15:49:40 GMT

First you should check the network issues(e.g: firewall is blocking port 1521). If network is ok,

then most probably you have listener configured wrongly, the hostname you specify in connection string must be the same as in the listener.

https://www.youtube.com/watch?v=pMQXVihgrrE&t=212s

https://adhoctuts.com/fix-oracle-io-error-the-network-adapter-could-not-establish-the-connection-error/

topic Re: tOracleOutput_1 Io exception: The Network Adapter could not establish the connection java.sql.SQLException: Io exception: The Network Adapter could not establish the connection in Talend Studio

tOracleOutput_1 Io exception: The Network Adapter could not establish the connection java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

Re: tOracleOutput_1 Io exception: The Network Adapter could not establish the connection java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

Re: tOracleOutput_1 Io exception: The Network Adapter could not establish the connection java.sql.SQLException: Io exception: The Network Adapter could not establish the connection