Oracle database server changes the computer name, causing the listener service to not open a workaround

1. Modify Listener.ora and Tnsnames.ora files

File path is: C:\Oracle\Instanclient_11_2\network\admin

　　

# Listener.ora Network Configuration file:c:\oracle\instantclient_11_2\network\admin\listener.ora# Generated by Oracle configuration Tools. Sid_list_listener=(Sid_list=(Sid_desc=(Sid_name=Clrextproc) (Oracle_home= C:\app\Administrator\product\11.2.0\dbhome_1) ( Program=Extproc) (Envs= "Extproc_dlls=only:c:\app\administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")) LISTENER=(Description_list=(DESCRIPTION=(ADDRESS= (PROTOCOL = TCP) (HOST = win-ebrv4jci3as) (PORT = 1521)) (ADDRESS= (PROTOCOL = IPC) (KEY =EXTPROC1521)) )) Adr_base_listener= C:\app\Administrator

# Listener.ora Network Configuration file:c:\oracle\instantclient_11_2\network\admin\listener.ora# Generated by Oracle configuration Tools. Sid_list_listener=(Sid_list=(Sid_desc=(Sid_name=Clrextproc) (Oracle_home= C:\app\Administrator\product\11.2.0\dbhome_1) ( Program=Extproc) (Envs= "Extproc_dlls=only:c:\app\administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")) LISTENER=(Description_list=(DESCRIPTION=(ADDRESS= (PROTOCOL = TCP) (HOST = win-ebrv4jci3as) (PORT = 1521)) (ADDRESS= (PROTOCOL = IPC) (KEY =EXTPROC1521)) )) Adr_base_listener= C:\app\Administrator

2. Modify "Net Manager"

Oracle database server changes the computer name, causing the listener service to not open a workaround