oracle服务器IP改变后,监听进程无法启动,需要修改相应的配置文件:

1、服务器端$ORACLE_HOME/network/admin/listener.ora修改address的host即可。监听进程负责监听网络上发来请求,然后响应,修改后重新启动LISTENER。即:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.178.40.196)(PORT = 1521))
)
)

2、客户端tnsnames.ora修改address的host即可,客户端无需重启。路径C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN,这个路径会随版本和安装点变化。即:

DL580 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.178.41.253)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)