oracle数据库更改IP地址后，发现无法连接。需要修改一下对应的文件： JAVA中文站社区门户9Kxh$f$]$S
network/admin/listener.ora JAVA中文站社区门户K@!F,[{#]
network/admin/tnsnames.ora JAVA中文站社区门户3H6m0A#c0T,L
把其中对应的IP地址进行修改后再重新启动oracle就可以解决问题了
'?Ex1~^PV[5QJ0例如 JAVA中文站社区门户)@ H5a4~slZ/_^
# listener.ora Network Configuration File: JAVA中文站社区门户-_ rZ"L1v(ze@
D:oracleproduct10.2.0db_1networkadminlistener.ora JAVA中文站社区门户5m4lx[/}
# Generated by Oracle configuration tools.
-_ N!A#@5Q'r0SID_LIST_LISTENER =
F[fLIR4liE7NH3I0(SID_LIST =
Z Py)ROh0(SID_DESC =
&Htg-j'd~-jn0(SID_NAME = PLSExtProc) JAVA中文站社区门户j4|bKz K'B4{(K+?
(ORACLE_HOME = D:oracleproduct10.2.0db_1)
x9q6hxW"IL0(PROGRAM = extproc) JAVA中文站社区门户q Z#t+lH$](M)n
)) JAVA中文站社区门户R+tD[f+@Y @
LISTENER =
hng7wS'}0(DESCRIPTION_LIST =
#gB aA?SVq-k0(DESCRIPTION =
Z,@omp w0(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
3t`6L BMF {6g-G0(ADDRESS = (PROTOCOL = TCP)(HOST = 4f3e06c379134a5) (PORT = 1521))
[h*Fl~~XM*wC0)) JAVA中文站社区门户sdjm e2fKlX~$K
注意：HOST位置要用机器名或机器的网络IP（如10.0.60.1）
rD,r!Y2@2b"Qv