To set up Oracle for use with Oozie:
On the Ambari Server host, stage the appropriate JDBC driver file for later deployment.
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.
Make sure the .jar file has the appropriate permissions - 644.
Execute the following command, adding the path to the downloaded.jar file:
ambari-server setup --jdbc-db=oracle --jdbc-driver=/path/to/downloaded/ojdbc6.jar
Create a user for Oozie and grant it permissions.
Using the Oracle database admin utility, run the following commands:
# sqlplus sys/root as sysdba CREATE USER <OOZIEUSER> IDENTIFIED BY <OOZIEPASSWORD>; GRANT ALL PRIVILEGES TO <OOZIEUSER>; GRANT CONNECT, RESOURCE TO <OOZIEUSER>; QUIT;Where <OOZIEUSER> is the Oozie user name and <OOZIEPASSWORD> is the Oozie user password.
