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
- Navigate:
- Edit:“listener.ora”
- Edit:“tnsnames.ora”
- Start the Listener and Service again
“\app\oracle\product\<oracle version>\server\NETWORK\ADMIN”
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) ) )