We have existing Sqoop connections to oracle db without ssl and we are able to ingest the data into hadoop successfully so far.
Now we got a requirement to use SSL-enabled oracle db for hadoop ingestion.
We followed the below links and did the setup and able to telnet with ssl enabled port successfully.
Steps we did so far by using above links:
Oracle DB Server side setup:
Client side setup (From Edge Node)
But when we try it from Sqoop import using oracle wallet (for TCPS protocal & SSL enabled port i.e. 2484 port) we are getting network adapter issues.
ERROR manager.SqlManager: Error executing statement: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
Does anyone know how to setup the Sqoop Import configuration for SSL enabled oracle db with wallet ?
Thank you !
This is what you should do to successfully ingest data using sqoop with Oracle SSL enable connection configuring Sqoop Connectivity to an SSL-enabled Oracle Database. it's straight forward please let me know if it worked or if you need help