oracle数据库更改IP地址后,发现无法连接。需要修改一下对应的文件:
network/admin/listener.ora
network/admin/tnsnames.ora
把其中对应的IP地址进行修改后再重新启动oracle就可以解决问题了
例如
# listener.ora Network Configuration File:
D:oracleproduct10.2.0db_1networkadminlistener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:oracleproduct10.2.0db_1)
(PROGRAM = extproc)
))
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 4f3e06c379134a5) (PORT = 1521))
))
注意:HOST位置要用机器名或机器的网络IP(如10.0.60.1)
用localhost或者127.0.0.1会报错,原因不明
并且JDBC连接字符串要与HOST的名称保持一致
oracle修改IP
最新推荐文章于 2022-04-25 15:01:36 发布