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.StoreService.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>