2. Oozie

On the Oozie Server machine, install the appropriate JDBC .jar file.
- For Oracle:
  1. Download the Oracle JDBC (OJDBC driver from http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html.
    Select Oracle Database 11g Release 2 - ojdbc6.jar.
  2. Copy the .jar file to the Java share directory.
    cp ojdbc6.jar /usr/share/java
  3. Make sure the .jar file has the appropriate permissions - 644.
- For MySQL:
  1. Install the connector.
    RHEL/CentOS/Oracle Linux
    yum install mysql-connector-java
    SLES
    zypper install mysql-connector-java
  2. Confirm that the MySQL .jar file is in the Java share directory.
    ls /usr/share/java/mysql-connector-java.jar
  3. Make sure the .jar file has the appropriate permissions - 644.
On the Ambari Server host, install the appropriate JDBC .jar file.
- For Oracle:
  1. Download the Oracle JDBC (OJDBC) driver from http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html.
    Select Oracle Database 11g Release 2 - ojdbc6.jar .
  2. Copy the .jar file to the Java share directory.
    cp ojdbc6.jar /var/lib/ambari-server/resources
  3. Make sure the .jar file has the appropriate permissions - 644.
- For MySQL:
  1. Download the mysql connector driver from the host on which you installed mysql-connector-java.
  2. Copy the .jar file to the Java share directory.
    cp mysql-connector-java.jar /var/lib/ambari-server/resources
  3. Make sure the .jar file has the appropriate permissions - 644.
Create a user for Oozie and grant it permissions.
- For Oracle, create the Oozie user and grant it database permissions:
```
# sqlplus sys/root as sysdba
SQL> CREATE USER $OOZIEUSER IDENTIFIED BY $OOZIEPASSWORD;
SQL> GRANT ALL PRIVILEGES TO $OOZIEUSER;
SQL> QUIT;
```
  Where $OOZIEUSER is the Oozie user name and $OOZIEPASSWORD is the Oozie user password.
- For MySQL:
  1. Create the Oozie user and grant it database permissions.
    # mysql -u root -p mysql> CREATE USER ‘$OOZIEUSER’@’%’ IDENTIFIED BY ‘$OOZIEPASSWORD’; mysql> GRANT ALL PRIVILEGES ON *.* TO ‘$OOZIEUSER’@’%’; mysql> flush privileges;
    Where $OOZIEUSER is the Oozie user name and $OOZIEPASSWORD is the Oozie user password.
  2. Create the Oozie database.
    # mysql -u root -p mysql> CREATE DATABASE oozie;

Legal notices