Saturday, April 20, 2013

How to reconfigure Oracle Express listeners after changing hostname

After the computer has hostname changed, the Oracle Express 11 may not work as its configuration still point to old hostname. Hostname may be changed when the machine's network work status is changed. For example, I used NAT mode for my virtual machine. After I change its NIC to have Bridge mode, the hostname may be changed. Here is my steps to reconfigure Oracle Express listeners to bind on new hostname.

  1. Run “hostname” to get your server's new hostname from DNS server.
  2. Run “cd /u01/app/oracle/product/11.2.0/xe/network/admin”
  3. Replace “localhost.localdomain” in file listener.ora with your new hostname.
  4. Replace “localhost.localdomain” in file tnsnames.ora with your new hostname.
  5. tnsping yurNewHostName and see XE instance is running.

No comments:

Post a Comment