Configuring a Ranger or Ranger KMS Database: Oracle

Prior to upgrading your cluster to CDP Private Cloud Base you must configure the Oracle database instance for Ranger by creating a Ranger database and user. Before you begin the transition, review the support policies of database and admin policy support for transactions.

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.
    2. Copy the .jar file to the Java share directory.
      sudo cp /tmp/ojdbc8-12.2.0.1.jar /usr/share/java/oracle-connector-java.jar
      Make sure the .jar file has the appropriate permissions. For example:
      sudo chmod 644 /usr/share/java/oracle-connector-java.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;
    GRANT CREATE SESSION,CREATE PROCEDURE,CREATE TABLE,CREATE VIEW,CREATE SEQUENCE,CREATE PUBLIC SYNONYM,CREATE ANY SYNONYM,CREATE TRIGGER,UNLIMITED TABLESPACE TO rangeradmin;
    ALTER USER rangeradmin DEFAULT TABLESPACE <tablespace>;
    ALTER USER rangeradmin quota unlimited on <tablespace>;
Continue installing or upgrading your cluster.