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

Question

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!

Choolake · Accepted Answer

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

JoseManuel · Answer

Hello,This seems more of an Oracle TNS listener misconfiguration Oracle native sqlplus should be able to connect before using SQOOP: sqlplus /@prxd10-scan.intranet.slt.com.lk:1521/Hope this helps,-JMP

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.