Search This Blog

Tuesday, May 14, 2013

Changing host name inside Oracle XE configuration file


If you change oracle machine host name, the listener can’t run due to error in configuration.
So you need to configure it again manually as:

  1. Stop Database Listener and Service
  2. Go to installation directory
  3. Navigate:
    • “\app\oracle\product\<oracle version>\server\NETWORK\ADMIN”
  4. Edit:“listener.ora
    • LISTENER =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
      (ADDRESS = (PROTOCOL = TCP)(HOST = <new_host_name>)(PORT = 1521))
      )
      )
      
  5. Edit:“tnsnames.ora
    • XE =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST =<new_host_name>(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
      )
      )
      
  6. Start the Listener and Service again

No comments: