2. Oozie

  1. 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.

  2. 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.

  3. 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;


loading table of contents...