Using Oozie with Oracle

Before using OOZIE with a new or existing Oracle database; obtain the appropriate driver and .jar files, and create a Hive user with sufficient permissions.

Determine the appropriate Oracle database version and obtain the release drivers and .jar file.

Table 1. Oracle Datbase Version Information
Oracle Database Version	Drivers	File
Oracle Database 11g	Oracle Database 11g Release 2 drivers	ojdbc6.jar
Oracle Database 12c	Oracle Database 12c Release 1 drivers	ojdbc7.jar

On the Ambari Server host, stage the appropriate JDBC driver file for later deployment.
1. Download the Oracle JDBC (OJDBC) driver from https://www.oracle.com/technetwork/database/application-development/jdbc/downloads/index.html.
2. Make sure the .jar file has the appropriate permissions.
  chmod 644 ojdbc7.jar
3. Add the path to the downloaded .jar file.
  ambari-server setup --jdbc-db=oracle --jdbc-driver=/path/to/downloaded/ojdbc7.jar
Create a user for OOZIE and grant it permissions.
using the Oracle database admin utility:
```
# sqlplus sys/root as sysdba
CREATE USER [OOZIE_USER] IDENTIFIED BY [OOZIE_PASSWORD];
GRANT ALL PRIVILEGES TO  [OOZIE_USER];
GRANT CONNECT, RESOURCE TO [OOZIE_USER];
QUIT;
```
Where [OOZIE_USER] is the Oozie user name and [OOZIE_PASSWORD] is the Oozie user password.