Modify the Oracle instance listener IP address in the Windows environment.
configuration file path:<oracle_home>\network\admin
such as: C:\Oracle11gR2\product\11.2.0\dbhome_1\NETWORK\ADMIN
First, modify the configuration file: Listener.ora
# Listener.ora Network Configuration file:d:\oracle11gr2\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration tools. Sid_list_listener=(Sid_list=(Sid_desc=(Sid_name=Clrextproc) (Oracle_home= D:\Oracle11gR2\product\11.2.0\dbhome_1) ( Program=Extproc) (Envs="Extproc_dlls=only:d:\oracle11gr2\product\11.2.0\dbhome_1\bin\oraclr11.dll")) (Sid_desc=(Sid_name=ORCL) (Oracle_home= D:\Oracle11gR2\product\11.2.0\dbhome_1)) ) LISTENER=(Description_list=(DESCRIPTION=(ADDRESS= (PROTOCOL = IPC) (KEY =EXTPROC1521)) (ADDRESS= (PROTOCOL = TCP) (HOST =192.168.1.100) (PORT =1521))) Adr_base_listener= D:\Oracle11gR2
Modify the address of the host in the Listener node in the Listener.ora configuration file from localhost to the IP address.
Also, be sure to add a Sid_desc node description to the Sid_list node. Otherwise, the following error message will be reported when the service is started.
Second, modify the configuration file: Tnsnames.ora
Modify the address in the Tnsnames.ora configuration file to be an IP address:
# Tnsnames.ora Network Configuration file:d:\oracle11gr2\product\11.2.0\dbhome_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools. LISTENER_ORCL=(ADDRESS= (PROTOCOL = TCP) (HOST = localhost) (PORT =1521)) Oraclr_connection_data=(DESCRIPTION=(Address_list=(ADDRESS= (PROTOCOL = IPC) (KEY =EXTPROC1521)) ) (Connect_data=(SID=Clrextproc) (PRESENTATION=RO)) ) ORCL=(DESCRIPTION=(ADDRESS= (PROTOCOL = TCP) (HOST =192.168.1.100) (PORT =1521)) (Connect_data=(SERVER=dedicated) (Service_Name=ORCL)) )
With the above configuration, after restarting the Oracle Listener and instance service, you can connect via IP address on other computers.
Modify Oracle Instance listener IP address under Windows environment