Installing HDP Manually
Also available as:
PDF
loading table of contents...

Configure Your Database for Oozie

  • For Derby:

    No database configuration is required.

  • For MySQL:

    echo "create database if not exists oozie;" | mysql -u root
    echo "grant all privileges on oozie.* to 'oozie'@'localhost' identified by 'oozie';" | mysql -u root
    echo "grant all privileges on oozie.* to 'oozie'@`hostname -f` identified by 'oozie';" | mysql -u root
  • For PostgreSQL:

    psql -U postgres -c "CREATE DATABASE oozie;"
    psql -U postgres -c "CREATE USER oozie WITH PASSWORD 'oozie';"
    psql -U postgres -c "GRANT ALL PRIVILEGES ON DATABASE oozie TO oozie;"
  • For Oracle:

    bash -l -c 'echo "create user oozie identified by oozie;" | sqlplus system/root@`hostname -f`' 
    bash -l -c 'echo "GRANT SELECT_CATALOG_ROLE TO oozie;" | sqlplus system/ root@`hostname -f`' 
    bash -l -c 'echo "GRANT CONNECT, RESOURCE TO oozie;" | sqlplus system/ root@`hostname -f`'