Member since
10-18-2017
3
Posts
0
Kudos Received
0
Solutions
10-07-2019
01:12 PM
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 !
... View more
Labels:
10-07-2019
10:35 AM
Hi Dwill, Is it worked for you Sqoop import with ssl enabled oracle db ? I got the same kind of requirement to use sqoop import with ssl enabled db and I am trying connecting through oracle wallet but getting network adapter issues. Could you please provide me the steps if it is working fine for you ? Thank you.
... View more
10-07-2019
10:10 AM
Is it working for you or still no luck ? I am also trying Sqoop with ssl enabled oracle db through oracle wallet but getting the same error? Can you please provide me the steps to configure if it is working for you ? Thanks.
... View more