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