看了下oracle的配置文件,发现上回的解决方法比较暴力
这里补充下比较普遍的解决方法:
1.找到oracle目录下tnsnames.ora和listener.ora相关配置文件.
2.修改HOST名,可以为IP地址或计算机名(与初始设置变化后就会导致no listener的error)
以listener.ora为例,
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:/oracle/product/10.1.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
)
修改localhost为当前IP地址或主机名即可.
3.重启相关服务.
注:若配置出错,可能导致appserver的无法启动,原因是已部署的项目涉及oracle连接.