Monday, March 17, 2014

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

No comments:

Post a Comment

  How to Change Instance Type & Security Group of EC2 in AWS By David Taylor Updated April 29, 2023 EC2 stands for Elastic Compute Cloud...