Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Sqoop import from Oracle - IO Error: The Network Adapter could not establish the connection

avatar
Explorer

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.

1 REPLY 1

avatar
Expert Contributor