[
https://issues.apache.org/jira/browse/SQOOP-2502?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14727350#comment-14727350
]
Yibing Shi commented on SQOOP-2502:
-----------------------------------
[~prjains], in which directory have you put the ojdbc6.jar file? Is it
{{/usr/lib/sqoop/lib}} or {{/var/lib/sqoop}} or anything else?
> Unable to connect to Oracle DB : Could not load db driver class:
> oracle.jdbc.OracleDriver
> ------------------------------------------------------------------------------------------
>
> Key: SQOOP-2502
> URL: https://issues.apache.org/jira/browse/SQOOP-2502
> Project: Sqoop
> Issue Type: Test
> Components: connectors/oracle
> Affects Versions: 1.4.5
> Environment: CentOS 6.6 , HDP 2.2.6
> Reporter: Prateek
> Priority: Blocker
>
> 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)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
