@Adrián Gil Ping me on LinkedIn I could help you remotely ... View more

@Farhana Khan Any updates on this issue? ... View more

@Adrián Gil Let's discard the ALIAS what I suggest is completely remove it and have your /etc/hosts look like this 10.61.2.10       bigdatapruebas.es        ::1                     localhost ip6-localhost ip6-loopback  ff02::1                 ip6-allnodes  ff02::02                ip6-allrouters Stop the ambari-server and agent # ambari-server stop # ambari-agent stop Create a file host_names_changes.json file with hostnames changes. Contents of the host_names_changes.json # Ambari host name change {   "bigdata" : {       "old_name_here" : "bigdatapruebas.es"   } } Update the host name for the various components # Hive grant all privileges on hive.* to 'hive'@'bigdatapruebas.es' identified by 'hive_password'; grant all privileges on hive.* to 'hive'@'bigdatapruebas.es' with grant option; # Oozie grant all privileges on oozie.* to 'hive'@'bigdatapruebas.es' identified by 'oozie_password'; grant all privileges on oozie.* to 'hive'@'bigdatapruebas.es' with grant option; # Ranger grant all privileges on ranger.* to 'hive'@'bigdatapruebas.es' identified by 'ranger_password'; grant all privileges on ranger.* to 'hive'@'bigdatapruebas.es' with grant option; # Rangerkms grant all privileges on rangerkms.* to 'hive'@'bigdatapruebas.es' identified by 'rangerkms_password'; grant all privileges on rangerkms.* to 'hive'@'bigdatapruebas.es' with grant option; Change these 3 values in /etc/ambari-server/conf/ambari.properties to the new hostname server.jdbc.rca.url= server.jdbc.url=jdbc= server.jdbc.hostname= Edit the ambari-agent.ini under server replace the hostname with new Ambari hostname [server] hostname=bigdatapruebas.es url_port=8440 secured_url_port=8441 connect_retry_delay=10 max_reconnect_retry_delay=30 Start the ambari-agent # ambari-agent start Start the Ambari # ambari-server start Open the web browser http://bigdatapruebas.es:8080 Start all components Please revert ... View more

@Adrián Gil You succeeded but encountering heartbeat lost because your /etc/hosts entry is wrong 🙂 I really can't understand how you can connect 🙂 The below entry is wrong and shouldn't resolve that somehow explains why you had difficulty in running the host_names_changes.json bigdata@bigdata:~$ sudo cat /etc/hosts 10.61.2.10              bigdatapruebas.es bigdata.adurizenergia.es bigdata.es bigdata Should be the /etc/host entry should be exactly the output of $ hostname -f bigdatapruebas.es So your /etc/hosts should look like below $ sudo cat /etc/hosts 10.61.2.10       bigdatapruebas.es But if you had an FQDN like bigdata.endesa.es the entry could be IP FQDN ALIAS $ sudo cat /etc/hosts IP FQDN ALIAS ------------------------------------------------ 10.61.2.10       bigdata.endesa.es      bigdata With the above entry in the /etc/hosts, you can access ambari successfully in 2 ways http://bigdata.endesa.es:8080 and http://bigdata:8080 Please do the necessary changes and revert ... View more

@Shesh Kumar I am happy this compilation has helped give you a better understanding If you found this answer addressed your question, please take a moment to log in and click the "accept" link on the answer. That would be a great help to Community users to find the solution quickly for these kinds of errors. Happy Hadooping ... View more

@Shesh Kumar Sorry for that I think the option is only when you have attained a certain level of mastery Guru about 600 points I see you have 63 points Post it as an idea then a moderator might promote it to a KB or HCC reference and give you points for that unfortunately I am not a HWX employee. HTH ... View more

@Adrián Gil What values do you have in /etc/host? Can you share a redacted version of your /etc/hosts and the output of $ hostname -f The below shows that you are trying to change to a value which is no different from the older value 🙂 Detail: Key (host_name)=(bigdata.es) already exists. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)          at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)          at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)  ERROR: duplicate key value violates unique constraint "uq_hosts_host_name"    Detail: Key (host_name)=(bigdata.es) already exists. Error Code: 0  Call: UPDATE hosts SET host_name = ? WHERE (host_id = ?)bind => [2 parameters bound] Please revert ... View more