You have to go using configs.sh for this one (not through UI yet) 1. /var/lib/ambari-server/resources/scripts/configs.sh get <ambari server> <cluster name> oozie-site oozie.conf 2. modify the file (oozie.conf to oozie.conf.new) with you mysql DB. 3 ./var/lib/ambari-server/resources/scripts/configs.sh set <ambari server> <cluster name> oozie-site oozie.conf.new
Example values for mysql. oozie.service.JPAService.create.db.schema = true <if you need it to create schema> oozie.service.JPAService.jdbc.driver = com.mysql.jdbc.Driver oozie.service.JPAService.jdbc.username = oozie oozie.service.JPAService.jdbc.password = <password> oozie.service.JPAService.jdbc.url = jdbc:mysql://mysql.server.host:3306/oozie Thanks On Wed, Feb 4, 2015 at 11:11 PM, Hadoop Solutions <[email protected]> wrote: > Attached Screenshot.... > > [image: Inline images 2] > > On 5 February 2015 at 12:42, Hadoop Solutions <[email protected]> > wrote: > >> Hello, >> >> I am new to Ambari, while installing HDP2.2 through Ambari, by mistake i >> have selected wrong database for Oozie. >> >> After deploying, i am unable to change the DB from Ambari. All radio >> buttons are blocked in config page. >> >> Please let me know how to change Oozie DB Derby to MySQL. >> >> Regards, >> Shaik >> > >
