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:
- Stop Database Listener and Service
- Go to installation directory
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) (ADDRESS = (PROTOCOL = TCP)(HOST = <new_host_name>)(PORT = 1521)) ) )
XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =<new_host_name>(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) )