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.
- Install and Start Oracle 12.2
Create the Oozie Oracle User and Grant Privileges.
The following example uses the Oracle
sqlpluscommand-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 Enter password: ****** SQL> create user oozie identified by oozie default tablespace users temporary tablespace temp; User created. SQL> grant alter index to oozie; grant alter table to oozie; grant create index to oozie; grant create sequence to oozie; grant create session to oozie; grant create table to oozie; grant drop sequence to oozie; grant select dictionary to oozie; grant drop table to oozie; alter user oozie quota unlimited on users; alter user oozie quota unlimited on system; SQL> exit $
Add the Oracle JDBC Driver JAR to Oozie.
Copy or symbolically link the Oracle JDBC driver JAR into the