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.
On the Ranger host, install the appropriate JDBC .jar file.
Log in to the host where the Oracle database is running and
launch Oracle sqlplus:
sqlplus sys/root as sysdba
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 TRIGGER,UNLIMITED TABLESPACE TO rangeradmin;
ALTER USER rangeradmin DEFAULT TABLESPACE <tablespace>;
ALTER USER rangeradmin quota unlimited on <tablespace>;