HDP 2.5 : Oozie issue

[#1]

I have installed HDP 2.5 components using Ambari. All the services started and working fine without any issue except Oozie.

Got the below error,

ERROR XBM0A: The database directory '/data/hadoop/oozie/data/oozie-db' exists. However, it does not contain the expected 'service.properties' file. Perhaps Derby was brought down in the middle of creating this database. You may want to delete this directory and try creating the database again. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.services.monitor.StorageFactoryService.vetService(Unknown Source) at org.apache.derby.impl.services.monitor.StorageFactoryService.access$900(Unknown Source) at org.apache.derby.impl.services.monitor.StorageFactoryService$10.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at org.apache.derby.impl.services.monitor.StorageFactoryService.createServiceRoot(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(Unknown Source) at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source) at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source) at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) at org.apache.derby.jdbc.Driver20.connect(Unknown Source) at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.apache.oozie.tools.OozieDBCLI.createConnection(OozieDBCLI.java:953) at org.apache.oozie.tools.OozieDBCLI.validateConnection(OozieDBCLI.java:959) at org.apache.oozie.tools.OozieDBCLI.createDB(OozieDBCLI.java:189) at org.apache.oozie.tools.OozieDBCLI.run(OozieDBCLI.java:128) at org.apache.oozie.tools.OozieDBCLI.main(OozieDBCLI.java:79)

[#2]

@Uvaraj Seerangan

By any chance did you try deleting the directory '/data/hadoop/oozie/data/oozie-db' and then tried starting it again?

Better to try moving '/data/hadoop/oozie/data/oozie-db' to some other directory and then try starting it,

[#3 · Accepted solution]

Backup the directory "/data/hadoop/oozie/data/oozie-db" to another directory and then remove it using the command:

rm -rf /data/hadoop/oozie/data/oozie-db

Then restart oozie from Ambari and try again

[#4]

@Uvaraj Seerangan - Please check answers given below and accept an appropriate answer once your issue is resolved.