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