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]

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]

[Anonymous]

Hello,

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

Best regards

Sabrina

[Anonymous · Accepted solution]

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