Hi,
I am trying to import data Oracle using below command, but getting error
" INFO mapreduce.Job: Task Id : attempt_1537882416287_0003_m_000000_2, Status : FAILED
Error: java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
".
sqoop import --direct --connect jdbc:oracle:thin:@10.128.6.XX:1537/crmsrv --username xxxx --password xxxx --table SIEBEL.S_ENTLMNT_MTRC -m 1
2)
If I am trying with below command getting error
"
ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
"
sqoop import --direct --connect jdbc:oracle:thin:@10.128.6.XX:1537:crmsrv --username xxxx --password xxxx --table SIEBEL.S_ENTLMNT_MTRC -m 1
Appreciate for your prompt response.
Thanks.
