在Oracle安装目录下appAdministratorproduct11.2.0dbhome_1NETWORKADMIN下找到listener.ora文件,编辑对应项为:
LISTENER =(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.77)(PORT = 1521))
)
)
)
192.168.1.77为主机IP地址。