<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>question SQOOP Connection Issue ( Sqoop to Oracle) in Support Questions</title>
    <link>https://community.cloudera.com/t5/Support-Questions/SQOOP-Connection-Issue-Sqoop-to-Oracle/m-p/290297#M214805</link>
    <description>&lt;P&gt;&lt;SPAN&gt;Could you please help on below connection issue:&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;I have already placed the JAR file in the&amp;nbsp;(/usr/lib/sqoop/lib)&amp;nbsp;folder. And I have verified ping/tnsping/telnet .. etc in database side and&amp;nbsp;nc -z (127.XX.XX.XX 1521) in Cloudera and everything looks fine but I'm unable to connect sqoop.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;sqoop list-tables \&lt;BR /&gt;&amp;gt; --connect jdbc:oracle:thin:@localhost:1521/pdborcl \&lt;BR /&gt;&amp;gt; --username hr \&lt;BR /&gt;&amp;gt; -P \&lt;BR /&gt;&amp;gt; --verbose&lt;BR /&gt;Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail.&lt;BR /&gt;Please set $ACCUMULO_HOME to the root of your Accumulo installation.&lt;BR /&gt;20/02/23 09:59:00 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.13.0&lt;BR /&gt;20/02/23 09:59:00 DEBUG tool.BaseSqoopTool: Enabled debug logging.&lt;BR /&gt;Enter password:&lt;BR /&gt;20/02/23 09:59:03 DEBUG sqoop.ConnFactory: Loaded manager factory: org.apache.sqoop.manager.oracle.OraOopManagerFactory&lt;BR /&gt;20/02/23 09:59:03 DEBUG sqoop.ConnFactory: Loaded manager factory: com.cloudera.sqoop.manager.DefaultManagerFactory&lt;BR /&gt;20/02/23 09:59:03 DEBUG sqoop.ConnFactory: Trying ManagerFactory: org.apache.sqoop.manager.oracle.OraOopManagerFactory&lt;BR /&gt;20/02/23 09:59:04 DEBUG oracle.OraOopManagerFactory: Data Connector for Oracle and Hadoop can be called by Sqoop!&lt;BR /&gt;20/02/23 09:59:04 INFO oracle.OraOopManagerFactory: Data Connector for Oracle and Hadoop is disabled.&lt;BR /&gt;20/02/23 09:59:04 DEBUG sqoop.ConnFactory: Trying ManagerFactory: com.cloudera.sqoop.manager.DefaultManagerFactory&lt;BR /&gt;20/02/23 09:59:04 DEBUG manager.DefaultManagerFactory: Trying with scheme: jdbc:oracle:thin:@localhost&lt;BR /&gt;20/02/23 09:59:04 DEBUG manager.OracleManager$ConnCache: Instantiated new connection cache.&lt;BR /&gt;20/02/23 09:59:04 INFO manager.SqlManager: Using default fetchSize of 1000&lt;BR /&gt;20/02/23 09:59:04 DEBUG sqoop.ConnFactory: Instantiated ConnManager org.apache.sqoop.manager.OracleManager@727f6c7d&lt;BR /&gt;20/02/23 09:59:05 DEBUG manager.OracleManager: Creating a new connection for jdbc:oracle:thin:@localhost:1521/pdborcl, using username: hr&lt;BR /&gt;20/02/23 09:59:05 DEBUG manager.OracleManager: No connection paramenters specified. Using regular API for making connection.&lt;BR /&gt;20/02/23 09:59:05 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.NullPointerException&lt;BR /&gt;java.lang.NullPointerException&lt;BR /&gt;at org.apache.sqoop.manager.OracleManager.listTables(OracleManager.java:769)&lt;BR /&gt;at org.apache.sqoop.tool.ListTablesTool.run(ListTablesTool.java:49)&lt;BR /&gt;at org.apache.sqoop.Sqoop.run(Sqoop.java:147)&lt;BR /&gt;at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)&lt;BR /&gt;at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)&lt;BR /&gt;at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)&lt;BR /&gt;at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243)&lt;BR /&gt;at org.apache.sqoop.Sqoop.main(Sqoop.java:252)&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;</description>
    <pubDate>Sun, 23 Feb 2020 18:48:25 GMT</pubDate>
    <dc:creator>Prabhu_Muppala</dc:creator>
    <dc:date>2020-02-23T18:48:25Z</dc:date>
  </channel>
</rss>

