DocsHortonworks Data Platform

 

 3.1. Using Oozie with Oracle

To set up Oracle for use with Oozie:

  1. On the Oozie Server host, install the appropriate JDBC .jar file.

    1. Download the Oracle JDBC (OJDBC) driver from http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html.

    2. Select Oracle Database 11g Release 2 - ojdbc6.jar.

    3. Copy the .jar file to the Java share directory.

      cp ojdbc6.jar /usr/share/java

    4. Make sure the .jar file has the appropriate permissions - 644.

  2. Create a user for Oozie and grant it permissions.

    • Using the Oracle database admin utility: 

      # sqlplus sys/root as sysdba
CREATE USER $OOZIEUSER IDENTIFIED BY $OOZIEPASSWORD;
GRANT ALL PRIVILEGES TO $OOZIEUSER;                            
QUIT;

    • Where $OOZIEUSER is the Oozie user name and $OOZIEPASSWORD is the Oozie user password.

Legal notices
loading table of contents...