生活随笔
收集整理的這篇文章主要介紹了
应用程序连接Oracle rac的URL写法
小編覺得挺不錯的,現在分享給大家,幫大家做個參考.
http://blog.csdn.net/hu_shengyang/article/details/7043271
Oracle RAC 集群示意圖
RAC，全稱real application clusters，譯為“實時應用集群”， 是Oracle新版數據庫中采用的一項新技術，
?是高可用性的一種，也是Oracle數據庫支持網格計算環境的核心技術。
應用程序連接Oracle rac的URL寫法一例 ：
[sql] view plaincopyprint?
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）
[sql] view plaincopyprint?
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写法的全部內容，希望文章能夠幫你解決所遇到的問題。
如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。
