New Contributor
Posts: 1
Registered: ‎10-10-2017

Oozie fails with Could not load db driver class: oracle.jdbc.OracleDriver

I am getting below error while executing sqoop export command(in shell script) with oozie.

"java.lang.RuntimeException: Could not load db driver class: oracle.jdbc.OracleDriver"

sqoop export from cli(edge node) works fine.

I have added the ojdbc6.jar to below locations. /opt/cloudera/parcels/CDH-5.7.1-1.cdh5.7.1.p0.11/lib/sqoop/lib/

(HDFS locations) /user/oozie/share/lib/sqoop/ and /user/oozie/share/lib/lib_20161215195933/sqoop

i have also set oozie.use.system.libpath=true in my oozie file

Please guide me if i am missing any setting.