3.1. For Derby:

In the temporary directory, locate the following file and modify the properties. Search for TODO variables in the files for the properties to replace.

Modify the following properties in the oozie-site.xml file:

<property> 
     <name>oozie.base.url</name> 
     <value>http://$oozie.full.hostname:11000/oozie</value> 
     <description>Enter your Oozie server hostname.</description>
</property>
 
<property> 
     <name>oozie.service.Store­Service.jdbc.url</name> 
     <value>jdbc:derby:$OOZIE_DATA_DIR/$soozie.db.schema.name-db;create=true</value>
</property>

<property> 
     <name>oozie.service.JPAService.jdbc.driver</name> 
     <value>org.apache.derby.jdbc.EmbeddedDriver</value> 
</property>
 
<property> 
     <name>oozie.service.JPAService.jdbc.driver</name> 
     <value>org.apache.derby.jdbc.EmbeddedDriver</value> 
</property>
 
<property> 
     <name>oozie.service.JPAService.jdbc.username</name> 
     <value>$OOZIE_DBUSER</value> 
</property>
 
<property> 
     <name>oozie.service.JPAService.jdbc.password</name> 
     <value>$OOZIE_DBPASSWD</value> 
</property>
 
<property>
     <name>oozie.service.WorkflowAppService.system.libpath</name>
     <value>/user/$OOZIE_USER/share/lib</value>
</property>