I fixed it finally by As oozie uses derby db - checking the db location to see if there are any lock files cd /hadoop/oozie/data/oozie-db ubuntu@ixxxxxxxxx:/hadoop/oozie/data/oozie-db$ ls dbex.lck db.lck log README_DO_NOT_TOUCH_FILES.txt seg0 service.properties tmp rm dbex.lck rm db.lck Then finally went to Ambari UI hortonworks restarted the oozie, works finally.. Futher information please relay on a single user to avoid problem in future purpose... ... View more

@ Kulkarni while running your script I am getting the following error in horton works sudo oozie job -oozie http://XXXXXXXXXXXXXXXXXXXXXX:11000/oozie -config /home/ubuntu/testing/shell/job.properties –submit While running I am getting following error Error: E0803 : E0803: IO error, E0603: SQL error in operation, <openjpa-2.2.2-r422266:1468616 fatal store error> org.apache.openjpa.persistence.RollbackException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred. FailedObject: org.apache.oozie.CoordinatorJobBean@5ee81cbc ... View more