Support Questions

Find answers, ask questions, and share your expertise

Unable to execute the Sqoop command after configuring the existing environment into the new environment

avatar
Contributor

Unable to execute the Sqoop command after configuring the existing environment into the new environment.

we are using Sqoop import/export command to get the data from other DB to the HADOOP. But it's failed with following error. But we can do eval command and list command for same DB.

Error: java.lang.RuntimeException: java.sql.SQLException: ORA-12541: Cannot connect. No listener at host prxd10-scan.intranet.slt.com.lk port 1521. (CONNECTION_ID=fnQPj6XGQbKYLTFy6NYkAA==) https://docs.oracle.com/error-help/db/ora-12541/

but we are doing some Sqoop job with HADOOP and other DBs.

please help me!

1 ACCEPTED SOLUTION

avatar
Contributor

Thank you for the comments. we fixed the issue. issue is firewall rules not granted correctly

Thank you!

View solution in original post

4 REPLIES 4

avatar
Expert Contributor

Hello,

This seems more of an Oracle TNS listener misconfiguration 
Oracle native sqlplus should be able to connect before using SQOOP: 

sqlplus <USER>/<PASSWD>@prxd10-scan.intranet.slt.com.lk:1521/<listener>

Hope this helps,
-JMP

avatar
Contributor

Thank you for the updated. but Oracle native sqlplus already enabled.

avatar
Expert Contributor

OK....
So, sqlplus works from the same host SQOOP is being tried?
What is the output from SQOOP eval for "SELECT COUNT(*) FROM <YOUR TABLE>;" vs import on the same table?   

avatar
Contributor

Thank you for the comments. we fixed the issue. issue is firewall rules not granted correctly

Thank you!