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 — Tue, 22 May 2018 14:55:13 GMT

Hello experts.

I am facing the below error while trying to execute the job remotely using Talend 7.01 studio. Please help in resolving this.

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]

Thanks

crteja

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

Jesperrekuh — Tue, 22 May 2018 17:08:52 GMT

Your credentials are either false, or the remote server is not allowed to connect, contact DBAdministrator to grant connection to from whatever client you're trying to connect.

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