Make sure there are not Workflows in RUNNING or SUSPENDED status, otherwise the database upgrade will fail.
Shutdown Oozie and backup the Oozie database.
Copy the oozie-site.xml from your current setup.
Expand the new Oozie tarball in a new location.
Edit the new oozie-site.xml setting all custom properties values from the old oozie-site.xml
IMPORTANT: From Oozie 2.x to Oozie 3.x the names of the database configuration properties have changed. Their prefix has changed from =oozie.service.StoreService.*= to =oozie.service.JPAService.*=. Make sure you are using the new prefix.
After upgrading the Oozie server, the oozie-setup.sh MUST be rerun before starting the upgraded Oozie server.
Oozie database migration is required when there Oozie database schema changes, like upgrading from Oozie 2.x to Oozie 3.x.
Configure the oozie-site.xml with the correct database configuration properties as explained in the 'Database Configuration' section in Oozie Install .
Once oozie-site.xml has been configured with the database configuration execute the ooziedb.sh command line tool to upgrade the database:
$ bin/ooziedb.sh upgrade -runValidate DB Connection. DONE Check DB schema exists DONE Check OOZIE_SYS table does not exist DONE Verify there are not active Workflow Jobs DONE Create SQL schema DONE DONE Create OOZIE_SYS table DONE Upgrade COORD_JOBS new columns default values. DONE Upgrade COORD_JOBS & COORD_ACTIONS status values. DONE Table 'WF_ACTIONS' column 'execution_path', length changed to 1024 DONE Oozie DB has been upgraded to Oozie version '3.2.0' The SQL commands have been written to: /tmp/ooziedb-5737263881793872034.sql $
The new version of the Oozie server is ready to be started.
NOTE: If using MySQL or Oracle, copy the corresponding JDBC driver JAR file to the libext/ directory before running the ooziedb.sh command line tool.
NOTE: If instead using the '-run' option, the '-sqlfile
While older Oozie clients work with newer Oozie server, to have access to all the functionality of the Oozie server the same version of Oozie client should be installed and used by users.