Administering Ambari
Also available as:
PDF
loading table of contents...

Using Oozie with Oracle

Before using OOZIE with a new or existing Oracle database; obtain the appropriate driver and .jar files, and create a Hive user with sufficient permissions.

Determine the appropriate Oracle database version and obtain the release drivers and .jar file.
Table 1. Oracle Datbase Version Information
Oracle Database Version Drivers File
Oracle Database 11g Oracle Database 11g Release 2 drivers ojdbc6.jar
Oracle Database 12c Oracle Database 12c Release 1 drivers ojdbc7.jar
  1. On the Ambari Server host, stage the appropriate JDBC driver file for later deployment.
    1. Download the Oracle JDBC (OJDBC) driver from https://www.oracle.com/technetwork/database/application-development/jdbc/downloads/index.html.
    2. Make sure the .jar file has the appropriate permissions.
      chmod 644 ojdbc7.jar
    3. Add the path to the downloaded .jar file.
      ambari-server setup --jdbc-db=oracle --jdbc-driver=/path/to/downloaded/ojdbc7.jar
  2. Create a user for OOZIE and grant it permissions.
    using the Oracle database admin utility:
    # sqlplus sys/root as sysdba
    CREATE USER [OOZIE_USER] IDENTIFIED BY [OOZIE_PASSWORD];
    GRANT ALL PRIVILEGES TO  [OOZIE_USER];
    GRANT CONNECT, RESOURCE TO [OOZIE_USER];
    QUIT;
    Where [OOZIE_USER] is the Oozie user name and [OOZIE_PASSWORD] is the Oozie user password.