欢迎来到博达网站群学习网!
设为首页 | 加入收藏
当前位置: 首页 >> 知识库 >> 部署类 >> 数据库 >> 正文

VSB链接Oracle集群方法说明

发布时间:2016-08-03    浏览次数:

现象

客户提供Oracle集群,需要在站群中配置链接多个数据库实例

解决方法:

在站群后台,数据库连接池中,修改URL连接参数,参考:

jdbc.url=jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.255.18)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.255.19)(PORT = 1521))(LOAD_BALANCE = yes)(FAILOVER = yes))(CONNECT_DATA = (SERVER = DEDICATED)(INSTANCE_ROLE = PRIMARY)(FAILOVER_MODE = (TYPE = SESSION)(METHOD = BASIC))(SERVICE_NAME = jwdb)))

红色部分表示IP、端口、SID