question Re: sqoop connection error in Support Questions

sqoop connection error

sharma1 — Fri, 16 Sep 2022 09:19:25 GMT

Hi ,

i am trying to connect oracle database 11gr2 with sqoop Sqoop 1.4.5-cdh5.3.0. but gettig error

hdfs@node01:/opt/cloudera/parcels/CDH/lib/hadoop$ sqoop list-tables -connect jdbc:oracle:thin:@192.168.171.149:1521/BG11G -username hdfsuser -P
Warning: /opt/cloudera/parcels/CDH-5.3.0-1.cdh5.3.0.p0.30/bin/../lib/sqoop/../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
15/01/15 20:49:36 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5-cdh5.3.0
Enter password:
15/01/15 20:49:41 INFO oracle.OraOopManagerFactory: Data Connector for Oracle and Hadoop is disabled.
15/01/15 20:49:41 INFO manager.SqlManager: Using default fetchSize of 1000
15/01/15 20:49:41 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.NullPointerException
java.lang.NullPointerException
at org.apache.sqoop.manager.OracleManager.listTables(OracleManager.java:759)
at org.apache.sqoop.tool.ListTablesTool.run(ListTablesTool.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)

i am running CDH5.3 on ubuntu 12 .

i came accros Quest OraOop software . it is necessary to install this to move data rom oracle to hdfs

Re: sqoop connection error

sharma1 — Mon, 19 Jan 2015 00:13:30 GMT

Guys ,

Anyone can help on this ?

Re: sqoop connection error

GautamG — Mon, 19 Jan 2015 04:31:50 GMT

> jdbcracle:thin:@192.168.171.149:1521/BG11G

Should that not be jdbc:oraacle:thin:@//192.168.171.149:1521/BG11

Also ensure there is no firewall blocking communications between the
cluster nodes and the Oracle server

Re: sqoop connection error

yfelemban — Tue, 29 Sep 2015 00:07:49 GMT

I tried this

[root@quickstart bin]# sqoop list-tables --connect jdbcracle:thin@10.0.0.3:1521/xe --username hr -P

Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
15/09/28 16:56:48 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5-cdh5.4.2
Enter password:
15/09/28 16:57:05 ERROR tool.BaseSqoopTool: Got error creating database manager:
java.io.IOException: No manager for connect string: jdbcracle:thin@10.0.0.3:152
1/xe
at org.apache.sqoop.ConnFactory.getManager(ConnFactory.java:191)
at org.apache.sqoop.tool.BaseSqoopTool.init(BaseSqoopTool.java:250)
at org.apache.sqoop.tool.ListTablesTool.run(ListTablesTool.java:44)
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)

and didn't work , do you know where the problem is ?

Re: sqoop connection error

Somu — Tue, 29 Sep 2015 00:16:14 GMT

-P expects password : User should enter in the console

Instead of -P use :

--password your_password

Re: sqoop connection error

yfelemban — Tue, 29 Sep 2015 11:26:49 GMT

[root@quickstart cloudera]# sqoop list-tables --connect jdbcracle:thin@10.0.0.3:1521/xe --username hr --password hr
Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
15/09/29 04:24:18 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5-cdh5.4.2
15/09/29 04:24:18 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
15/09/29 04:24:19 ERROR tool.BaseSqoopTool: Got error creating database manager: java.io.IOException: No manager for connect string: jdbcracle:thin@10.0.0.3:1521/xe
at org.apache.sqoop.ConnFactory.getManager(ConnFactory.java:191)
at org.apache.sqoop.tool.BaseSqoopTool.init(BaseSqoopTool.java:250)
at org.apache.sqoop.tool.ListTablesTool.run(ListTablesTool.java:44)
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)

-----------------------------------

still same problem , I'm not sure if jdbcracle:thin@ is proper driver !!! don't you think so?

Re: sqoop connection error

Somu — Tue, 29 Sep 2015 12:56:58 GMT

Here is an example for My SQL:

--connect jdbc:mysql://quickstart:3306/retail_db

I guess for Oracle you should use below format with replacement:

--connect jdbc:oracle:thin:@OracleServer:OraclePort:OracleSID

--connect jdbc:oracle:thin:@//OracleServer:OraclePort/OracleService

Make sure you have installed Oracle Connector for Sqoop.

Re: sqoop connection error

yfelemban — Tue, 29 Sep 2015 14:32:50 GMT

Kindly , Do you have any suggestion URL in how to install Oracle Connector for sqoop, i would prefer if there is video for it step by step.

best regards, and thank you so much

Re: sqoop connection error

Somu — Tue, 29 Sep 2015 15:30:21 GMT

http://www.cloudera.com/content/cloudera/en/downloads/connectors/sqoop/oracle/v1-6.html

Re: sqoop connection error

jk13 — Wed, 30 Sep 2015 10:01:10 GMT

he is using 5.3 so that shouldn't be neccessary with --direct or am i wrong?