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