Using Oozie with Oracle - Hortonworks Data Platform

Apache Ambari Administration

Also available as:

PDF

Contents

loading table of contents...

Using Oozie with Oracle

To set up Oracle for use with Oozie:

Steps

On the Ambari Server host, install the appropriate JDBC driver file.
1. Download the Oracle JDBC (OJDBC) driver from http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html.
2. For Oracle Database 11g: select
```
Oracle Database 11g Release 2 drivers > ojdbc6.jar
```
3. For Oracle Database 12c: select
```
Oracle Database 12c Release 1 drivers > ojdbc7.jar
```
4. Make sure the .jar file has the appropriate permissions. For example:
```
chmod 644 ojdbc7.jar
```
5. Execute the following command, adding the path to the downloaded .jar file:
```
ambari-server setup --jdbc-db=oracle --jdbc-driver=/path/to/downloaded/ojdbc7.jar
```
Create a user for Oozie and grant it permissions.
Using the Oracle database admin utility, run the following commands:
```
# sqlplus sys/root as sysdba
```
```
CREATE USER <OOZIEUSER> IDENTIFIED BY <OOZIEPASSWORD>;
```
```
GRANT ALL PRIVILEGES TO <OOZIEUSER>;
```
```
GRANT CONNECT, RESOURCE TO <OOZIEUSER>;
```
```
QUIT;
```
Where <OOZIEUSER> is the Oozie user name and <OOZIEPASSWORD> is the Oozie user password.