My Oracle Support Banner

How to Query the Oozie Backing Database and Dump the Oozie Schema on Oracle Big Data Appliance V2.2.1 (Doc ID 1582156.1)

Last updated on JUNE 15, 2017

Applies to:

Big Data Appliance Integrated Software - Version 2.2.0 to 2.2.0 [Release 2.2]
Linux x86-64

Goal

To overview how to query the backing Oozie Derby database on Oracle Big Data Appliance (BDA) V2.2.1 / CDH 4.3.  The note also overview how to dump the Oozie schema to a file.  This is for informational purposes only in case there is a need to look at the Derby database.

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Setup
 Stop the Oozie service from Cloudera Manager (CM)
 Access the backing Oozie Derby DB
 Dump the Oozie schema
 Start the Oozie service

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.