@saravanan gopalsamy Great to know that your issue is resolved. It will be wonderful if you can click on the "Accept" button on this thread to mark this comment as answered, that helps community users to quickly find out the correct answer. ... View more

Thankyou @mqureshi the /etc/hosts file was not updated properly ... View more

@saravanan gopalsamy Sure, The Database queries should definitely work well as it leaves no foot print in the database of the service that we wanted to delete and completely cleans all the entries related to that mentioned service from the Database completely. You will need to restart AmbariServer after making the database changes. ... View more