JDBC连接Oracle RAC
来源:互联网 发布:宁波奥凯网络 编辑:程序博客网 时间:2024/05/22 06:44
1)JDBC连接的配置方式
,既然数据库本身已经支持了RAC,那么只要在JDBC连接字符串中将RAC的配置加上去即可, 根据资料和目前的业务需求,我们的针对HOST=10.87.25.37这台主机的数据库实例的JDBC连接字符串应该这样配置
URL="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=10.87.25.37)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)
(HOST=10.87.25.38)(PORT=1521))
(HOST=10.87.25.39)(PORT=1521))
(FAILOVER=on)(LOAD_BALANCE=off))
(CONNECT_DATA= (SERVICE_NAME=bidwb)))"
这个连接配置表示只支持failover,不支持loadbalance.根据蓝色字符串可以表示.即按照顺序,使用该JDBC字符串获取的连接,将根据配置的主机的先后顺序,依次进行failover
即如果在10.87.25.37数据库实例不能被访问,那么就转到10.87.25.38执行,如果10.87.25.38也数据库实例不能被访问,那么就转到10.87.25.39执行
同理
对于HOST=10.87.25.38这台主机的数据库实例的JDBC连接字符串应该这样配置
URL="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=10.87.25.38)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)
(HOST=10.87.25.39)(PORT=1521))
(HOST=10.87.25.37)(PORT=1521))
(FAILOVER=on)(LOAD_BALANCE=off))
(CONNECT_DATA= (SERVICE_NAME=bidwb)))"
对于HOST=10.87.25.39这台主机的数据库实例的JDBC连接字符串应该这样配置
URL="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=10.87.25.39)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)
(HOST=10.87.25.37)(PORT=1521))
(HOST=10.87.25.38)(PORT=1521))
(FAILOVER=on)(LOAD_BALANCE=off))
(CONNECT_DATA= (SERVICE_NAME=bidwb)))"
即只是各个Host的顺序不同
2)本地服务名连接的配置方式
对于HOST=10.87.25.37这台主机的数据库实例的本地服务名应该这样配置
37bidwb =
(DESCRIPTION =
(ADDRESS_LIST=
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.37)(PORT = 1521))
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.38)(PORT = 1521))
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.39)(PORT = 1521))
(FAILOVER = on)
(LOAD_BALANCE = off)
)
(CONNECT_DATA= (SERVICE_NAME = bidwb))
)
对于HOST=10.87.25.38这台主机的数据库实例的本地服务名应该这样配置
37bidwb =
(DESCRIPTION =
(ADDRESS_LIST=
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.38)(PORT = 1521))
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.39)(PORT = 1521))
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.37)(PORT = 1521))
(FAILOVER = on)
(LOAD_BALANCE =off)
)
(CONNECT_DATA= (SERVICE_NAME = bidwb))
)
对于HOST=10.87.25.39这台主机的数据库实例的本地服务名应该这样配置
37bidwb =
(DESCRIPTION =
(ADDRESS_LIST=
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.39)(PORT = 1521))
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.37)(PORT = 1521))
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.38)(PORT = 1521))
(FAILOVER = on)
(LOAD_BALANCE = off)
)
(CONNECT_DATA= (SERVICE_NAME =bidwb))
)
,既然数据库本身已经支持了RAC,那么只要在JDBC连接字符串中将RAC的配置加上去即可, 根据资料和目前的业务需求,我们的针对HOST=10.87.25.37这台主机的数据库实例的JDBC连接字符串应该这样配置
URL="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=10.87.25.37)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)
(HOST=10.87.25.38)(PORT=1521))
(HOST=10.87.25.39)(PORT=1521))
(FAILOVER=on)(LOAD_BALANCE=off))
(CONNECT_DATA= (SERVICE_NAME=bidwb)))"
这个连接配置表示只支持failover,不支持loadbalance.根据蓝色字符串可以表示.即按照顺序,使用该JDBC字符串获取的连接,将根据配置的主机的先后顺序,依次进行failover
即如果在10.87.25.37数据库实例不能被访问,那么就转到10.87.25.38执行,如果10.87.25.38也数据库实例不能被访问,那么就转到10.87.25.39执行
同理
对于HOST=10.87.25.38这台主机的数据库实例的JDBC连接字符串应该这样配置
URL="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=10.87.25.38)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)
(HOST=10.87.25.39)(PORT=1521))
(HOST=10.87.25.37)(PORT=1521))
(FAILOVER=on)(LOAD_BALANCE=off))
(CONNECT_DATA= (SERVICE_NAME=bidwb)))"
对于HOST=10.87.25.39这台主机的数据库实例的JDBC连接字符串应该这样配置
URL="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=10.87.25.39)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)
(HOST=10.87.25.37)(PORT=1521))
(HOST=10.87.25.38)(PORT=1521))
(FAILOVER=on)(LOAD_BALANCE=off))
(CONNECT_DATA= (SERVICE_NAME=bidwb)))"
即只是各个Host的顺序不同
2)本地服务名连接的配置方式
对于HOST=10.87.25.37这台主机的数据库实例的本地服务名应该这样配置
37bidwb =
(DESCRIPTION =
(ADDRESS_LIST=
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.37)(PORT = 1521))
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.38)(PORT = 1521))
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.39)(PORT = 1521))
(FAILOVER = on)
(LOAD_BALANCE = off)
)
(CONNECT_DATA= (SERVICE_NAME = bidwb))
)
对于HOST=10.87.25.38这台主机的数据库实例的本地服务名应该这样配置
37bidwb =
(DESCRIPTION =
(ADDRESS_LIST=
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.38)(PORT = 1521))
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.39)(PORT = 1521))
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.37)(PORT = 1521))
(FAILOVER = on)
(LOAD_BALANCE =off)
)
(CONNECT_DATA= (SERVICE_NAME = bidwb))
)
对于HOST=10.87.25.39这台主机的数据库实例的本地服务名应该这样配置
37bidwb =
(DESCRIPTION =
(ADDRESS_LIST=
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.39)(PORT = 1521))
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.37)(PORT = 1521))
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.38)(PORT = 1521))
(FAILOVER = on)
(LOAD_BALANCE = off)
)
(CONNECT_DATA= (SERVICE_NAME =bidwb))
)
0 0
- jdbc 连接 Oracle RAC
- JDBC连接Oracle RAC
- JDBC连接Oracle RAC
- jdbc 连接Oracle RAC
- jdbc连接oracle rac的连接串
- jdbc连接oracle rac连接串
- JDBC连接oracle RAC数据库配置
- jdbc thin 连接 rac数据源-JAVA-ORACLE
- JDBC连接oracle RAC数据库配置
- jdbc 连接 oracle rac
- JDBC连接oracle RAC数据库配置
- JDBC连接Oracle RAC的连接串配置
- JDBC连接Oracle RAC的连接串配置
- JDBC连接RAC
- Oracle集群(RAC)及 jdbc 连接双机数据库
- jdbc应用程序连接Oracle rac的URL写法:
- Oracle集群(RAC)及 jdbc 连接双机数据库
- jdbc连接遭遇RAC设备
- 自定义ExpandableListView
- Makefile中的符号说明
- (转载)C#线程(一)
- 黑马程序员——OC的Category和Protocol
- 8.26学习总结
- JDBC连接Oracle RAC
- STL map和unordered_map的区别
- HttpClient 4.3教程
- MMU初始化
- Dubbo入门基础与实例讲解
- gravity与layout_gravity的区别
- cs硕士妹子找工作经历【阿里人搜等互联网】
- 利用Struts进行图片上传
- Dual-SIM Phone