How to configure Oozie to use Oracle

Question

Hi. I have recently installed Oozie and I want to use Oracle for it. What configuration should I make to make Oozie use Oracle?

Answer 1

You have to mention the following properties in the oozie-site.xml file to make Oozie use Oracle: 

    <property>
        <name>oozie.service.JPAService.jdbc.driver</name>
        <value>oracle.jdbc.OracleDriver</value>
    </property>
    <property>
        <name>oozie.service.JPAService.jdbc.url</name>
        <value>jdbc:oracle:thin:@//myhost:1521/oozie</value>
    </property>
    <property>
        <name>oozie.service.JPAService.jdbc.username</name>
        <value>oozie</value>
    </property>
    <property>
        <name>oozie.service.JPAService.jdbc.password</name>
        <value>oozie</value>
    </property>