Using Ranger and RangerKMS with Oracle
Before setting up Ranger and RangerKMS with an existing Oracle database, obtain the appropriate drivers and .jar files, create a Ranger/RangerKMS user with sufficient permissions, and load the Ranger/RangerKMS database schema.
Determine the appropriate Oracle database version and obtain the release drivers and .jar file.
| Oracle Database Version | Drivers | File |
|---|---|---|
| Oracle Database 19c | Oracle Database 19c drivers | ojdbc11.jar |
Steps for Ranger KMS
Install the appropriate JDBC .jar file on the Oracle host.
Download the Oracle JDBC (OJDBC) driver from JDBC and UCP Downloads page .
- For Oracle Database 19C: select
Oracle Database 23ai (23.8.0.25.04) JDBC Driver>ojdbc11.jar.
- For Oracle Database 19C: select
Copy the .jar file to the Java share directory.
cp ojdbc11.jar /usr/share/java/Make sure the .jar file has the appropriate permissions. For example:
chmod 644 /usr/share/java/ojdbc11.jar- Create the Oozie databases using the Oracle database administrator. You can use the following series of commands to create the
RANGERDBAuser and grant permissions using SQL*Plus.
ORCLPDB1 refers to the Pluggable Database (PDB) within the multitenant Oracle Container Database (CDB) named ORCLCDB, introduced above oracle 12c, and any operations such as creating or dropping tablespaces within this context apply specifically to the ORCLPDB1 PDB.
# sqlplus sys/root as sysdbasqlplus / as sysdbaSQL*Plus: Release 19.0.0.0.0 - Production on Fri May 9 04:27:05 2025Version 19.3.0.0.0Copyright (c) 1982, 2019, Oracle. All rights reserved.Connected to:Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionVersion 19.3.0.0.0SQL> alter session set container=ORCLPDB1;Session altered.SQL> CREATE TABLESPACE rangerdba DATAFILE '/opt/oracle/oradata/ORCLCDB/ORCLPDB1/rangerdba.dbf' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED; 2 3 4 5 6Tablespace created.SQL> CREATE USER rangerdba IDENTIFIED BY rangerdba DEFAULT TABLESPACE rangerdba TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON rangerdba;User created.SQL> GRANT CONNECT, RESOURCE TO rangerdba;Grant succeeded.SQL> GRANT CREATE SESSION, CREATE TABLE, CREATE SEQUENCE TO rangerdba; 2 3 4 5Grant succeeded.SQL>GRANT CREATE VIEW TO rangerdba;Grant succeeded.
- Set the
jdbc/driver/pathbased 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}.
ambari-server setup --jdbc-db=oracle --jdbc-driver=/usr/share/java/ojdbc11.jar- Start the Ranger installation.
Steps for RangerKMS
Create the RangerKMS databases using the Oracle database administrator. You can use the following series of commands to create the RANGERKMS user and grant permissions using SQL*Plus.
ORCLPDB1 refers to the Pluggable Database (PDB) within the multitenant Oracle Container Database (CDB) named ORCLCDB, introduced above oracle 12c, and any operations such as creating or dropping tablespaces within this context apply specifically to the ORCLPDB1 PDB.
# sqlplus sys/root as sysdbasqlplus / as sysdbaSQL*Plus: Release 19.0.0.0.0 - Production on Fri May 9 04:27:05 2025Version 19.3.0.0.0Copyright (c) 1982, 2019, Oracle. All rights reserved.Connected to:Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionVersion 19.3.0.0.0SQL> alter session set container=ORCLPDB1;Session altered.SQL> CREATE TABLESPACE rangerkms DATAFILE '/opt/oracle/oradata/ORCLCDB/ORCLPDB1/rangerkms.dbf' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED; 2 3 4 5 6Tablespace created.SQL> CREATE USER rangerkms IDENTIFIED BY rangerkms DEFAULT TABLESPACE rangerkms TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON rangerkms;User created.SQL> GRANT CONNECT, RESOURCE TO rangerkms;Grant succeeded.SQL> GRANT CREATE SESSION, CREATE TABLE, CREATE SEQUENCE TO rangerkms; 2 3 4 5Grant succeeded.SQL>GRANT CREATE VIEW TO rangerkms;Grant succeeded.