ELT for Oracle : tELTOracleOutput_1 java.sql.SQLException: The Network

[Anonymous]

I m new in Talend ETL (most experience in SSIS).
Talend ver 4.2 and Oracle 11g DB.
I make simple example with OracleELT
tELTOracleInput -> tELTOracleMap --> tELTOracleOutput
When running :
xception in component tELTOracleOutput_1
java.sql.SQLException: The Network Adapter could not establish the connection
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:525)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at thinkbi_dev.j_elt_load_0_1.j_elt_load.tELTOracleMap_1Process(j_elt_load.java:307)
at thinkbi_dev.j_elt_load_0_1.j_elt_load.runJobInTOS(j_elt_load.java:570)
disconnected
Any ideas ?

[Anonymous]

Is there any resolution for this error ? I am re-attaching the screenshots.

[Anonymous]

hello 
im using talend for a BI projet
i connected the source with oracle 10g
i made a simple etl with tETLOracleinput----tEtlOracleMap-----TEtlOracleOutput;
it gives me this error;
Démarrage du job bi a 15:37 20/03/2017.
connecting to socket on port 3994
connected
Exception in component tELTOracleOutput_1
java.sql.SQLRecoverableException: Exception d'E/S: The Network Adapter could not establish the connection
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:101)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:458)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:411)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:490)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:202)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:465)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
: local_project.bi_0_1.bi - tELTOracleOutput_1 Exception d'E/S: The Network Adapter could not establish the connection
at local_project.bi_0_1.bi.tELTOracleMap_1Process(bi.java:428)
at local_project.bi_0_1.bi.runJobInTOS(bi.java:789)
at local_project.bi_0_1.bi.main(bi.java:623)
disconnected
Job bi terminé à 15:37 20/03/2017.

[Anonymous]

Hi LAMYAE04,
Can you connect to your Oralce DB successfully through client without using talend tool? Is your network Ok with you?
Best regards
Sabrina