Exception running Sqoop: java.lang.RuntimeException: Could not load db driver class: oracle.jdbc.OracleDriver (Doc ID 1481038.1)

Last updated on AUGUST 02, 2017

Applies to:

Big Data Appliance Integrated Software - Version 1.0.1.1.0 and later
Linux x86-64

Symptoms

Trying to use list-databases via SQOOP and connecting with the Oracle JDBC Thin driver and getting the following exception:

sqoop list-databases --username SYSTEM --password myPassword --connect jdbc:oracle:thin:@myHost.example.com:1521:ORCL

 

12/08/03 15:39:15 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 com.cloudera.sqoop.manager.OracleManager.makeConnection(OracleManager.java:276)
        at com.cloudera.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:53)
        at com.cloudera.sqoop.manager.OracleManager.listDatabases(OracleManager.java:630)
        at com.cloudera.sqoop.tool.ListDatabasesTool.run(ListDatabasesTool.java:51)
        at com.cloudera.sqoop.Sqoop.run(Sqoop.java:146)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
        at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:182)
        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:221)
        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:230)
        at com.cloudera.sqoop.Sqoop.main(Sqoop.java:239)

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms