Install and start Oracle 11g.

Create the Oozie Oracle user.

For example, using the Oracle SQL*Plus command-line tool:

$ sqlplus system@localhost
Enter password: ******
SQL> create user oozie identified by oozie default tablespace users temporary tablespace temp;
User created.
 
SQL> grant all privileges to oozie;
Grant succeeded.
 
SQL> exit
$ 

Create an Oracle database schema for Oozie to use:

	Note
	In the JDBC URL property, replace localhost with the hostname where Oracle is running and replace oozie with the TNS name of the Oracle database.

Add the Oracle JDBC driver JAR to Oozie. Copy or symlink the Oracle JDBC driver JAR in the /var/lib/oozie/ directory:

ln -s ojdbc6.jar /usr/hdp/current/oozie-server/lib

	Note
	You must manually download the Oracle JDBC driver JAR file.

Modify the following properties in oozie-env.sh to match the directories created:

export JAVA_HOME=/usr/java/default 
export OOZIE_CONFIG=${OOZIE_CONFIG:-/usr/hdp/2.2.9.0-$BUILD/oozie/conf} 
export OOZIE_DATA=${OOZIE_DATA:-/var/db/oozie} 
export OOZIE_LOG=${OOZIE_LOG:-/var/log/oozie} 
export CATALINA_BASE=${CATALINA_BASE:-/usr/hdp/2.2.9.0-$BUILD/oozie} 
export CATALINA_TMPDIR=${CATALINA_TMPDIR:-/var/tmp/oozie} 
export CATALINA_PID=${CATALINA_PID:-/var/run/oozie/oozie.pid} 
export OOZIE_CATALINA_HOME=/usr/lib/bigtop-tomcat 
export OOZIE_CLIENT_OPTS="${OOZIE_CLIENT_OPTS} -Doozie.connection.retry.count=5" 
export CATALINA_OPTS="${CATALINA_OPTS} -Xmx2048m -XX:MaxPermSize=256m" 
export JAVA_LIBRARY_PATH=/usr/lib/hadoop/lib/native/Linux-amd64-64 

On your Oozie server, create the config directory, copy the configuration files, and set the permissions:

rm -r $OOZIE_CONF_DIR; 
mkdir -p $OOZIE_CONF_DIR; 

Copy all the config files to $OOZIE_CONF_DIR directory.

Set appropriate permissions:

chown -R $OOZIE_USER:$HADOOP_GROUP $OOZIE_CONF_DIR/../ ;
chmod -R 755 $OOZIE_CONF_DIR/../ ; 

where: