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

[#1]

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!

[#2]

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

[#3]

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

[#4]

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?   

[#5 · Accepted solution]

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

Thank you!