Hostname change at Linux with Oracle DB

Hostname change at Linux with Oracle DB

24OCT

If you have to change a host name then following steps should have done for Oracle DB and OEM to work properly.

1. Change the host name properly:
   /etc/hosts
/etc/sysconfig/network
2. Change the hostname in tnsnames.ora and listener.ora:
   $ORACLE_HOME/network/admin/tnsnames.ora
$ORACLE_HOME/network/admin/listener.ora
3. Change the hostname in emd.properties:
   $ORACLE_HOME/sysman/config/emd.properties
4. Reboot
5. Restart the listener manually:
   lsnrctl stop
lsnrctl start
lsnrctl status
6. Recreate EM repository:
   emca -deconfig dbcontrol db -repos drop
emca -config dbcontrol db -repos create