Ranger Ambari Installation
Also available as:
PDF

Configuring Oracle for Ranger

  1. On the Oracle host, install the appropriate JDBC .jar file.

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

    • For Oracle Database 11g: select Oracle Database 11g Release 2 drivers > ojdbc6.jar.

    • For Oracle Database 12c: select Oracle Database 12c Release 1 driver > ojdbc7.jar.

    • Copy the .jar file to the Java share directory. For example:

      cp ojdbc7.jar /usr/share/java

      [Note]Note

      Make sure the .jar file has the appropriate permissions. For examle:

      chmod 644 /usr/share/java/ojdbc7.jar

  2. You can use the Oracle root user to create the Ranger databases.

    Optionally, you can also create a non-root user to use to create the Ranger databases. For example, you would use the following series of commands to create the RANGERDBA user and grant it permissions using SQL*Plus, the Oracle database administration utility:

    # sqlplus sys/root as sysdba
    CREATE USER $RANGERDBA IDENTIFIED BY $RANGERDBAPASSWORD; 
    GRANT SELECT_CATALOG_ROLE TO $RANGERDBA;
    GRANT CONNECT, RESOURCE TO $RANGERDBA; 
    QUIT;
  3. Use the following command format to set the jdbc/driver/path based on the location of the Oracle JDBC driver .jar file. This command must be run on the server where Ambari server is installed.

    ambari-server setup --jdbc-db={database-type} --jdbc-driver={/jdbc/driver/path}

    For example:

    ambari-server setup --jdbc-db=oracle --jdbc-driver=/usr/share/java/ojdbc6.jar