HI Ravi, Thank you for your reply.
I am trying to execute above procedure, but, i am getting below error... Please help me to resolve this. [root@sv2lxbdp2mstd01 ~]# /var/lib/ambari-server/resources/scripts/configs.sh get http://10.193.154.215:8080/ BDP2_DEV oozie-site oozie.conf [ERROR] "oozie-site" not found in server response. [ERROR] Output of `curl -k -s -u admin:admin "http:// http://10.193.154.215:8080/:8080/api/v1/clusters/BDP2_DEV?fields=Clusters/desired_configs"` is: [ERROR] Thanks, Shaik On 5 February 2015 at 14:02, Ravi Mutyala <[email protected]> wrote: > 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 >>> >> >> >
