Configuring OoziePDF version

Configuring Oracle for Oozie

You must install Oracle 12.2, create the Oozie Oracle user and grant privileges, and add the Oracle JDBC driver jar file to Oozie.

  1. Install and Start Oracle 12.2
  2. Create the Oozie Oracle User and Grant Privileges.
    The following example uses the Oracle sqlplus command-line tool, and shows the privileges Cloudera recommends. Oozie needs CREATE SESSION to start and manage workflows. The additional roles are needed for creating and upgrading the Oozie database.
    sqlplus system@localhost/<SERVICE_NAME>
        
    SQL> create user oozie identified by oozie default tablespace users temporary tablespace temp;
        User created.
    SQL> grant alter any index to oozie;
        Grant succeeded.
    SQL> grant alter any table to oozie;
        Grant succeeded.
    SQL> grant create any index to oozie;
        Grant succeeded.
    SQL> grant create sequence to oozie;
        Grant succeeded.
    SQL> grant create session to oozie;
        Grant succeeded.
    SQL> grant create table to oozie;
        Grant succeeded.
    SQL> grant drop any sequence to oozie;
        Grant succeeded.
    SQL> grant select any dictionary to oozie;
        Grant succeeded.
    SQL> grant drop any table to oozie;
        Grant succeeded.
    SQL> alter user oozie quota unlimited on users; 
        User altered.
    SQL> alter user oozie quota unlimited on system;
        User altered.
    SQL> exit
  3. Add the Oracle JDBC Driver JAR to Oozie.
    Copy or symbolically link the Oracle JDBC driver JAR into the /var/lib/oozie/ directory.