question Re: Migrating Oozie database from Oracle to MySql. in Archives of Support Questions (Read Only)

Migrating Oozie database from Oracle to MySql.

joshua_adeleke — Tue, 05 Jul 2016 16:06:00 GMT

I created the oozie user and database on MySql. In the process of migrating it, Oozie server won't start and i encountered the error "Runtime Exception during Services Load. Check your list of 'oozie.services' or 'oozie.services.ext' E0103: Could not load service classes, Cannot load JDBC driver class 'com.mysql.jdbc.Driver' org.apache.oozie.service.ServiceException: E0103: Could not load service classes, Cannot load JDBC driver class 'com.mysql.jdbc.Driver'". Any clue on what might be wrong or do I need to remove the Oozie service completely to migrate the DB? Note that I tested the connection while changing DB details in the config and it confirmed connection was ok. @Artem Ervits @Benjamin Leonhardi

Re: Migrating Oozie database from Oracle to MySql.

sshimpi — Tue, 05 Jul 2016 17:04:56 GMT

@Joshua Adeleke

Can you try this -

1, download the mysql-connector-jar from: https://dev.mysql.com/downloads/connector/j/here 2. Copy the mysql-connector-java.jar to /usr/hdp/current/oozie-server/libext and /usr/hdp/current/oozie-server/libtools # cp mysql-connector-java.jar /usrhdp/current/oozie-server/libext 3. Prepare the oozie.war by: # sudo su -l oozie -c "/usr/hdp/current/oozie-server/bin/oozie-setup.sh prepare-war -d /usr/hdp/current/oozie-server/libext"

Re: Migrating Oozie database from Oracle to MySql.

joshua_adeleke — Tue, 05 Jul 2016 17:25:27 GMT

Thank you @Sagar Shimpi. The mysql-connector-java.jar exist already. I have been using Hive with MySQL on the same node. Is it possible for the mysql-connector-java.jar to have issues and the DB connection test to be OK in Ambari Web UI?-

rw-r--r--. 1 oozie hadoop 819803 Jul 5 10:14 mysql-connector-java.jar

Re: Migrating Oozie database from Oracle to MySql.

joshua_adeleke — Wed, 06 Jul 2016 16:16:37 GMT

The oozie server starts for less than a minute and stops thereafter. I'm still looking for a fix as this critical issue.

2016-07-06 08:03:37,483 FATAL Services:514 - SERVER['server'] Runtime Exception during Services Load. Check your list of 'oozie.services' or 'oozie.services.ext' 2016-07-06 08:03:37,487 FATAL Services:514 - SERVER['server'] E0103: Could not load service classes, Cannot load JDBC driver class 'com.mysql.jdbc.Driver' org.apache.oozie.service.ServiceException: E0103: Could not load service classes, Cannot load JDBC driver class 'com.mysql.jdbc.Driver'

Re: Migrating Oozie database from Oracle to MySql.

joshua_adeleke — Wed, 06 Jul 2016 17:23:34 GMT

IT's working fine now. Thank you @Sagar Shimpi

Re: Migrating Oozie database from Oracle to MySql.

kharade_ajay — Tue, 08 Aug 2017 14:02:42 GMT

Copy mysql-connector-java.jar jar file into /usr/hdp/current/oozie-server/oozie-server/webapps/oozie/WEB-INF/lib folder, this will solved problem