Configuring Oracle for Ranger - Hortonworks Data Platform

Ranger Ambari Installation

Also available as:

PDF

Contents

loading table of contents...

Configuring Oracle for Ranger

On the Oracle host, install the appropriate JDBC .jar file.
- Download the Oracle JDBC (OJDBC) driver from http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html.
- For Oracle Database 11g: select Oracle Database 11g Release 2 drivers > ojdbc6.jar.
- For Oracle Database 12c: select Oracle Database 12c Release 1 driver > ojdbc7.jar.
- Copy the .jar file to the Java share directory. For example:
  cp ojdbc7.jar /usr/share/java
  Note
  Make sure the .jar file has the appropriate permissions. For examle:
  chmod 644 /usr/share/java/ojdbc7.jar
You can use the Oracle root user to create the Ranger databases.
Optionally, you can also create a non-root user to use to create the Ranger databases. For example, you would use the following series of commands to create the RANGERDBA user and grant it permissions using SQL*Plus, the Oracle database administration utility:
```
# sqlplus sys/root as sysdba
CREATE USER $RANGERDBA IDENTIFIED BY $RANGERDBAPASSWORD; 
GRANT SELECT_CATALOG_ROLE TO $RANGERDBA;
GRANT CONNECT, RESOURCE TO $RANGERDBA; 
QUIT;
```
Use the following command format to set the jdbc/driver/path based 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}
```
For example:
```
ambari-server setup --jdbc-db=oracle --jdbc-driver=/usr/share/java/ojdbc6.jar
```