Five Stars

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

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]

1 REPLY
Moderator

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

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.