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.
You must install Oracle 12.2, create the Oozie Oracle user and grant privileges, and add the Oracle JDBC driver jar file to Oozie.
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 <user> identified by <password> default tablespace <tablespace> temporary tablespace temp; User created. SQL> grant create sequence to <user>; Grant succeeded. SQL> grant create session to <user>; Grant succeeded. SQL> grant create table to <user>; Grant succeeded. SQL> alter user <user> quota unlimited on <tablespace>; User altered. SQL> exit
/var/lib/oozie/
directory.