应用程序连接Oracle rac的URL写法
来源:互联网 发布:淘宝购物车宝贝失效 编辑:程序博客网 时间:2024/05/21 22:48
http://blog.csdn.net/hu_shengyang/article/details/7043271
Oracle RAC 集群示意图
RAC,全称real application clusters,译为“实时应用集群”, 是Oracle新版数据库中采用的一项新技术,
是高可用性的一种,也是Oracle数据库支持网格计算环境的核心技术。
应用程序连接Oracle rac的URL写法一例 :
- jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dc1.bpsb.com.cn)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = dc2.bpsb.com.cn)(PORT = 1521))(LOAD_BALANCE = yes)(FAILOVER = on))(CONNECT_DATA =(SERVICE_NAME = bpscrac)))
jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dc1.bpsb.com.cn)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = dc2.bpsb.com.cn)(PORT = 1521))(LOAD_BALANCE = yes)(FAILOVER = on))(CONNECT_DATA =(SERVICE_NAME = bpscrac)))
这是网络上的一段oracle rac的url连接以及客户端tnsnames.ora的示例----与Oracle RAC相关的连接配置写法实例:(地址--http://www.linuxidc.com/Linux/2010-08/27947.htm)
- 1. 应用程序连接Oracle rac的URL写法
- jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.52)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.51)(PORT = 1521))(LOAD_BALANCE = yes)(FAILOVER = yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = kms)(FAILOVER_MODE=(TYPE = SELECT)(METHOD = BASIC)(RETIRES = 180)(DELAY = 15))))
- 2. 客户端连接Oracle rac时的tnsnames.ora写法
- ZJGLDB2 =
- (DESCRIPTION =
- (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.52)(PORT = 1521))
- (CONNECT_DATA =
- (SERVER = DEDICATED)
- (SERVICE_NAME = kms)
- (INSTANCE_NAME = kms2)
- )
- )
- ZJGLDB1 =
- (DESCRIPTION =
- (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.51)(PORT = 1521))
- (CONNECT_DATA =
- (SERVER = DEDICATED)
- (SERVICE_NAME = kms)
- (INSTANCE_NAME = kms1)
- )
- )
- LISTENERS_KMS =
- (ADDRESS_LIST =
- (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.51)(PORT = 1521))
- (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.52)(PORT = 1521))
- )
- KMS =
- (DESCRIPTION =
- (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.51)(PORT = 1521))
- (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.52)(PORT = 1521))
- (LOAD_BALANCE = yes)
- (FAILOVER = yes)
- (CONNECT_DATA =
- (SERVER = DEDICATED)
- (SERVICE_NAME = kms)
- (FAILOVER_MODE =
- (TYPE = SELECT)
- (METHOD = BASIC)
- (RETRIES = 180)
- (DELAY = 5)
- )
- )
- )
- 应用程序连接Oracle rac的URL写法
- 应用程序连接Oracle rac的URL写法
- jdbc应用程序连接Oracle rac的URL写法:
- 与Oracle Rac相关的连接配置写法实例
- 连接oracle的rac方式
- jdbc连接oracle rac的连接串
- java连接mysql数据的url写法
- ORACLE连接字符串的写法
- java thin 连接oracle url的几种写法
- oracle url的几种写法
- 关于ORACLE连接RAC不稳定的问题
- Oracle RAC 环境下的连接管理
- Oracle RAC 环境下的连接管理
- Oracle Rac 下的连接管理
- Oracle RAC 环境下的连接管理
- WEBLOGIC连接Oracle RAC 的负载均衡
- OCI连接RAC的oracle设置
- Oracle RAC 环境下的连接管理
- jsp5 javabean
- 内存数据库H2使用
- git log
- 问题七十八: Armstrong数。
- vmware centos ADSL共享上网设置
- 应用程序连接Oracle rac的URL写法
- 设计模式总结3——行为模式
- UI 设计师在给 iOS 或 Android 开发者提供资源图的时候需要注意哪些细节?
- android onkeydown 事件
- JAVA笔记(1)
- Spring HttpInvoke实现,以及效率提升! 博客分类: Spring
- 数学之路(2)-数据分析-R基础(11)
- javascript 函数讲解
- WinForm中的DataGridView子窗体刷新父窗体备忘