oracle10g数据库test采用 集群配置,两个实例:test1@192.168.1.1 以及test2@192.168.1.2
部署的服务单独访问任一个实例均启动成功。
但是采用集群url方式就提示Network adapter could not establish the connection
集群数据库url为:
jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))(LOAD_BALANCE = yes) ) (CONNECT_DATA = (SERVICE_NAME = test) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = PRECONNECT) (RETRIES = 20) (DELAY = 60)) ) )
说明:还部署了其他服务进行集群访问的,均正常,就最新的服务器上最新部署的服务不可访问。
可以参考以下链接
http://jlwangjinshuang-163-com.iteye.com/blog/1100874
Java连接oracle数据--数据库在改为集群之后URL的相应调整
OracleJavaJDBC
Java连接URL变更方式如下:
原方式:
Java代码 收藏代码
jdbc.url=jdbc:oracle:thin:@111.117.12.1:1521:test
改为集群后的方式:
Java代码 收藏代码
jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST =111.117.12.1)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST =111.117.12.2)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST =111.117.12.3)(PORT = 1521))(LOAD_BALANCE=yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = test)))