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.
On the Ranger host, install the appropriate JDBC .jar file.
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 2 driver > ojdbc8.jar.
Copy the .jar file to the Java share directory.
cp ojdbc8-126.96.36.199.jar /usr/share/java/Make sure the .jar file has the appropriate permissions. For example:
chmod 644 /usr/share/java/ojdbc8-188.8.131.52
- Download the Oracle JDBC (OJDBC) driver from https://www.oracle.com/technetwork/database/features/jdbc/index-091264.html.
- 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
# sqlplus sys/root as sysdba CREATE USER rangeradmin IDENTIFIED BY rangeradmin; GRANT SELECT_CATALOG_ROLE TO rangeradmin; GRANT CONNECT, RESOURCE TO rangeradmin; QUIT;