数据库连接串的问题。（如果是集群数据库的话）

最新推荐文章于 2023-11-24 18:35:41 发布

原创最新推荐文章于 2023-11-24 18:35:41 发布 · 326 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Oracle #JDBC #Java

oracle 专栏收录该内容

16 篇文章

订阅专栏

本文介绍如何正确配置 Oracle RAC (Real Application Clusters) 数据库的连接字符串，包括使用负载均衡和故障转移功能的具体参数设置。

连接字符串应该改成如下：
由

jdbc:oracle:thin://172.16.0.47:1521/warehouse?useUnicode=true&characterEncoding=utf-8

 jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.0.12)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.0.22)(PORT = 1521))(LOAD_BALANCE = yes)(FAILOVER = ON)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = rac)(FAILOVER_MODE=(TYPE = SELECT)(METHOD = BASIC)(RETIRES = 20)(DELAY = 15))))