Created 08-29-2016 02:05 PM
I am getting below error while executing SQOOP import command : ERROR manager.SqlManager: Error executing statement: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
Created 08-29-2016 02:07 PM
Query : ./sqoop import --connect jdbc:oracle:thin://<ip address>:1521/app --username APP --password APP12# --table tbemp --hive-import
Created 08-29-2016 02:38 PM
Your --connect URL does not seem to be correct.
--connect jdbc:oracle:thin://<ip address>:1521/app
Change it to something like following
--connect jdbc:oracle:thin:@//<ip address>:1521/app
Created 08-29-2016 02:41 PM
Also it will be best to check if the oracle DB listener is started listening properly on port 1521 or not?
It will be also good to check if the port is accessible fine from the sqoop client host:
telnet <oracle_ipaddress> 1521
Created 08-29-2016 02:50 PM
This I need to do from hadoop namenode?
Created 08-29-2016 02:58 PM
@Amit Dass the telnet command it just to verify the connectivity between the host where you are running the "./sqoop import" command to the Oracle Database host "<oracle_ipaddress> 1521".
Created 09-02-2016 01:22 PM
If app is not a defined service for the TNS listener but the instance id, use this URL format
Also, make sure you can connect to the Oracle instance from the all the client nodes (typically) as the sqoop mappers will run across the cluster.
Created 04-27-2022 03:07 PM
connection from all nodes in cluster to Oracle DB, is must.
Created 10-27-2022 05:22 PM
This is good insight, how would I check if each node can connect to the Oracle DB?
Created 03-25-2021 12:28 PM
See if the listener and the database are initiated. I just started the listener (lsnrctl start) and the database (sqlplus / as sysdba and startup) and it worked.