Configure a Ranger DB: Oracle

How to configure your Oracle database instance for Ranger.

A MySQL/Oracle/PostgreSQL/Amazon RDS database instance must be running and available to be used by Ranger.

If you are using Amazon RDS, see “Configure an Amazon RDS Database Instance for Ranger: Prerequisites”.

On the Oracle host, install the appropriate JDBC .jar file.
1. 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.
2. Copy the .jar file to the Java share directory.
  cp ojdbc7.jar /usr/share/java/
  
  Make sure the .jar file has the appropriate permissions. For example: chmod 644 /usr/share/java/ojdbc7.jar
The Oracle database administrator should be used to create the Ranger databases. The following series of commands could be used 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;
```
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}.
```
ambari-server setup --jdbc-db=oracle --jdbc-driver=/usr/share/java/ojdbc6.jar
```

“Start the Ranger Installation”