Hive and HCatalog require a database to use as a metadata store, but comes with embedded Derby database by default. MySQL 5.x is supported. You may provide access to an existing database, or install MySQL instance using the instructions provided here.
Oozie requires a database to use as a metadata store, but comes with embedded Derby database by default. MySQL 5.x is supported.