Reply
New Contributor
Posts: 1
Registered: ‎04-25-2017

ERROR WHILE CONNECTING TO ORACLE DB VIA SQOOP

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)

Posts: 365
Topics: 11
Kudos: 57
Solutions: 30
Registered: ‎09-02-2016

Re: ERROR WHILE CONNECTING TO ORACLE DB VIA SQOOP

@nitink

 

Are you using parquet? if so please refer this link

 

https://issues.apache.org/jira/browse/SQOOP-2571

 

Champion
Posts: 547
Registered: ‎05-16-2016

Re: ERROR WHILE CONNECTING TO ORACLE DB VIA SQOOP

Could you excute --verbose on your sqoop command. To dig more into the error.

 --verbose

Also please make sure if the ports are good  and  check on the oracle instances .

finally see if you can use --driver in the sqoop .

Announcements