如何修改Oracle服务IP地址

你好，
oracle数据库所在的机器更改IP地址后，发现无法连接，
解决这个问题，需要修改一下对应的文件：
F:\app\zhaohe\product\1120\dbhome_1\NETWORK\ADMIN\listenerora
F:\app\zhaohe\product\1120\dbhome_1\NETWORK\ADMIN\tnsnamesora
把其中对应的IP地址进行修改后再重新启动oracle就可以解决问题了；
注：重启实例服务、OracleOraDb11g_home1TNSListener后，稍等1分钟后即可。
listenerora
# listenerora Network Configuration File: F:\app\zhaohe\product\1120\dbhome_1\network\admin\listenerora
# Generated by Oracle configuration tools
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = F:\app\zhaohe\product\1120\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:F:\app\zhaohe\product\1120\dbhome_1\bin\oraclr11dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 19216815)(PORT = 1521))
)
)
ADR_BASE_LISTENER = F:\app\zhaohe
tnsnamesora
# tnsnamesora Network Configuration File: F:\app\zhaohe\product\1120\dbhome_1\NETWORK\ADMIN\tnsnamesora
# Generated by Oracle configuration tools
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = 19216815)(PORT = 1521))
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 19216815)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
注意：HOST位置要用机器名或机器的网络IP（如19216815）

以上就是关于如何修改Oracle服务IP地址全部的内容，包括:如何修改Oracle服务IP地址、、等相关内容解答，如果想了解更多相关内容，可以关注我们，你们的支持是我们更新的动力！