sqoop connection error

[#1]

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

[#2]

Guys ,

Anyone can help on this ?

[#3]

> 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​

[#4]

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 ?

[#5]

-P expects password : User should enter in the console

Instead of -P use :

--password your_password

[#6]

[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?

[#7]

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

OR

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

Make sure you have installed Oracle Connector for Sqoop.

[#8]

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

[#9]

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

[#10]

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