question Re: Unable to execute the Sqoop command after configuring the existing environment into the new environment in Support Questions

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

Choolake — Tue, 21 Apr 2026 06:28:30 GMT

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!

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

JoseManuel — Wed, 17 Jul 2024 20:38:59 GMT

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

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

Choolake — Thu, 18 Jul 2024 05:03:39 GMT

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

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

JoseManuel — Thu, 18 Jul 2024 13:48:22 GMT

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?

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

Choolake — Fri, 19 Jul 2024 06:46:54 GMT

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

Thank you!