Cloudera Community

Welcome to the Cloudera Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Advanced Search
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Who agreed with this topic

ERROR WHILE CONNECTING TO ORACLE DB VIA SQOOP

avatar
author-rank nitink
New Contributor

Created on ‎04-25-2017 01:48 AM - edited ‎09-16-2022 04:30 AM

Hi All,

Please help as i am getting below error while trying to execute Sqoop query:

 

sqoop list-databases -connect jdbc:oracle:thin:@//10.84.22.4:1521/BIPROD --username nitin --password test
 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5-cdh5.4.0
 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
 INFO oracle.OraOopManagerFactory: Data Connector for Oracle and Hadoop is disabled.
 INFO manager.SqlManager: Using default fetchSize of 1000
 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.NullPointerException
java.lang.NullPointerException
at org.apache.sqoop.manager.OracleManager.listDatabases(OracleManager.java:695)
at org.apache.sqoop.tool.ListDatabasesTool.run(ListDatabasesTool.java:49)
at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
at org.apache.sqoop.Sqoop.main(Sqoop.java:236)

2,219
0 Kudos
1
Who agreed with this topic