Configure Your Database for Oozie
Most of the configuration steps for your database for Oozie were performed in the previous section. However, you still need to create the sqlfile to create the tables in the database and validate that the configuration and jdbc are correct.
Run the following command as oozie user:
/usr/hdp/current/oozie-server/bin/ooziedb.sh create -sqlfile /tmp/oozie.sql -run