现象:
客户提供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