Uploaded image for project: 'Sqoop'
  1. Sqoop
  2. SQOOP-2502

Unable to connect to Oracle DB : Could not load db driver class: oracle.jdbc.OracleDriver

    Details

    • Type: Test
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Not A Problem
    • Affects Version/s: 1.4.5
    • Fix Version/s: None
    • Component/s: connectors/oracle
    • Labels:
      None
    • Environment:

      CentOS 6.6 , HDP 2.2.6

    • Flags:
      Important

      Description

      Hi ,

      I am trying to connect to the Oracle DB server.
      I have placed the ojdbc6.jar in the lib directory and given 755 permission to that.

      Still i am getting the following error -

      Warning: /usr/hdp/2.2.6.0-2800/accumulo does not exist! Accumulo imports will fail.
      Please set $ACCUMULO_HOME to the root of your Accumulo installation.
      15/08/18 12:45:19 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5.2.2.6.0-2800
      15/08/18 12:45:19 DEBUG tool.BaseSqoopTool: Enabled debug logging.
      15/08/18 12:45:19 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
      15/08/18 12:45:19 DEBUG sqoop.ConnFactory: Loaded manager factory: org.apache.sqoop.manager.oracle.OraOopManagerFactory
      15/08/18 12:45:19 DEBUG sqoop.ConnFactory: Loaded manager factory: com.cloudera.sqoop.manager.DefaultManagerFactory
      15/08/18 12:45:19 DEBUG sqoop.ConnFactory: Trying ManagerFactory: org.apache.sqoop.manager.oracle.OraOopManagerFactory
      15/08/18 12:45:19 DEBUG oracle.OraOopManagerFactory: Data Connector for Oracle and Hadoop can be called by Sqoop!
      15/08/18 12:45:19 INFO oracle.OraOopManagerFactory: Data Connector for Oracle and Hadoop is disabled.
      15/08/18 12:45:19 DEBUG sqoop.ConnFactory: Trying ManagerFactory: com.cloudera.sqoop.manager.DefaultManagerFactory
      15/08/18 12:45:19 DEBUG manager.DefaultManagerFactory: Trying with scheme: jdbc:oracle:thin:@10.137.12.76
      15/08/18 12:45:19 DEBUG manager.OracleManager$ConnCache: Instantiated new connection cache.
      15/08/18 12:45:19 INFO manager.SqlManager: Using default fetchSize of 1000
      15/08/18 12:45:19 DEBUG sqoop.ConnFactory: Instantiated ConnManager org.apache.sqoop.manager.OracleManager@5217e8de
      15/08/18 12:45:19 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: Could not load db driver class: oracle.jdbc.OracleDriver
      java.lang.RuntimeException: Could not load db driver class: oracle.jdbc.OracleDriver
      at org.apache.sqoop.manager.OracleManager.makeConnection(OracleManager.java:286)
      at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              prjains Prateek
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: