How to create the Oozie DB using the ooziedb sh command line tool

Question

Can anyone suggest how to create the Oozie DB using ooziedb.sh command line tool?

Answer 1

This is the command you can use:

$ bin/ooziedb.sh create -sqlfile oozie.sql -runValidate DB Connection

This is the output you going to get:

DONE
Check DB schema does not exist
DONE
Check OOZIE_SYS table does not exist
DONE
Create SQL schema
DONE
DONE
Create OOZIE_SYS table
DONE
Oozie DB has been created for Oozie version