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
    
    yum install mysql-connector-java-5.0.8-1
    
    SLES
    
    zypper install mysql-connector-java-5.0.8-1
  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-jave.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;

Index