Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Issue with Configuring Sqoop Connectivity to an SSL-Enabled Oracle Database

Issue with Configuring Sqoop Connectivity to an SSL-Enabled Oracle Database

New Contributor

Hi,

 

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.

 

https://oracle.com/technetwork/topics/wp-oracle-jdbc-thin-ssl-130128.pdf

https://blogs.apache.org/sqoop/entry/using_oracle_wallets_with_sqoop

 

Steps we did so far by using above links:

Oracle DB Server side setup:

  • Enabled SSL using 2484 port
  • Generated public key to auto login form client machine

Client side setup (From Edge Node)

  • Added public key into oracle wallet
  • Copied Jar files to /sqoop/lib:  ojdbc8.jar, oraclepki.jar, osdt_cert.jar, osdt_core.jar
  • Added this parameter into java.security file paramater security.provider.3=oracle.security.pki.OraclePKIProvider 

 

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 !

 

1 REPLY 1
Highlighted

Re: Issue with Configuring Sqoop Connectivity to an SSL-Enabled Oracle Database

Mentor

@npoorna20 

 

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 

 

HTH