VSB链接Oracle集群方法说明
2016-08-03 00:00
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
关注微信