orcal服务器遇上自动获取ip时遇到的问题解决 收藏
p自动获取的时候,或经常遇到ip改变的时候,oracl经常会出现服务器与客户端连接不上的问题,就是服务器可以启动,测试的时候一直提示 no listener,这个时候可以手动启动服务起的listener服务,一般在BIN目录下的TNSLSNR.EXE程序。就可以ip自动获取中可以客户端和服务器连接了. ip自动获取的时候 tnsnames中host不能用ip要用主机名如下。COMMISIO = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = JOMWAVE)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = commisio.mynet) ) ) COMMISIO_JOMWAVE = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = JOMWAVE)(PORT = 1521)) ) (CONNECT_DATA = (SID = commisio) (SERVER = DEDICATED) ) ) 主机名能作为host需要在listener。ora文件里配置下LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = JOMWAVE)(PORT = 1521)) ) ) 本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/Jomwave/archive/2008/06/13/2542958.aspx
p自动获取的时候,或经常遇到ip改变的时候,oracl经常会出现服务器与客户端连接不上的问题,就是服务器可以启动,测试的时候一直提示 no listener,这个时候可以手动启动服务起的listener服务,一般在BIN目录下的TNSLSNR.EXE程序。就可以ip自动获取中可以客户端和服务器连接了. ip自动获取的时候 tnsnames中host不能用ip要用主机名如下。COMMISIO = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = JOMWAVE)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = commisio.mynet) ) ) COMMISIO_JOMWAVE = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = JOMWAVE)(PORT = 1521)) ) (CONNECT_DATA = (SID = commisio) (SERVER = DEDICATED) ) ) 主机名能作为host需要在listener。ora文件里配置下LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = JOMWAVE)(PORT = 1521)) ) ) 本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/Jomwave/archive/2008/06/13/2542958.aspx
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货