If you are using external database (MySQL/Oracle) for Oozie metastore, you must add appropriate database connector JAR files using the instructions provided below:
Complete the instructions provided here.
Add the downloaded JAR files.
For MySQL:
/usr/lib/oozie/bin/oozie-setup.sh -hadoop 0.20.200 /usr/lib/hadoop -extjs /usr/share/HDP-oozie/ext-2.2.zip -jars /usr/lib/hadoop/lib/hadoop-lzo-0.5.0.jar:/usr/lib/oozie/libtools/mysql-connector-java-5.1.18-bin.jar
For Oracle:
/usr/lib/oozie/bin/oozie-setup.sh -hadoop 0.20.200 /usr/lib/hadoop -extjs /usr/share/HDP-oozie/ext-2.2.zip -jars /usr/lib/hadoop/lib/hadoop-lzo-0.5.0.jar:/usr/lib/oozie/libtools/odbc6.jar
