Created 07-17-2024 10:55 AM
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!
Created 07-18-2024 11:46 PM
Thank you for the comments. we fixed the issue. issue is firewall rules not granted correctly
Thank you!
Created 07-17-2024 01:38 PM
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
Created 07-17-2024 10:03 PM
Thank you for the updated. but Oracle native sqlplus already enabled.
Created 07-18-2024 06:48 AM
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?
Created 07-18-2024 11:46 PM
Thank you for the comments. we fixed the issue. issue is firewall rules not granted correctly
Thank you!