Configuring a Ranger or Ranger KMS Database: Oracle

How to configure an Oracle database instance for Ranger or Ranger KMS.

A supported version of Oracle must be running and available to be used by Ranger. See Database Requirements.

  1. On the Ranger host, install the appropriate JDBC .jar file.
    1. Download the Oracle JDBC (OJDBC) driver from https://www.oracle.com/technetwork/database/features/jdbc/index-091264.html.
      • For Oracle Database 12c: select Oracle Database 12c Release 1 driver > ojdbc7.jar.
    2. Copy the .jar file to the Java share directory.
      cp ojdbc7.jar /usr/share/java/

      Make sure the .jar file has the appropriate permissions. For example: chmod 644 /usr/share/java/ojdbc7.jar

  2. Log in to the host where the Oracle database is running and launch Oracle sqlplus:
    sqlplus sys/root as sysdba
  3. Create the Ranger database and user. Run the following commands:
    # sqlplus sys/root as sysdba
    CREATE USER rangeradmin IDENTIFIED BY rangeradmin; 
    GRANT SELECT_CATALOG_ROLE TO rangeradmin;
    GRANT CONNECT, RESOURCE TO rangeradmin; 
    QUIT;
Continue installing or upgrading your cluster.