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

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

1 REPLY
Eight Stars

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

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.