【原】java应用程序连接Oracle rac的URL写法

作者：david_zhang@sh 【转载时请以超链接形式标明文章】

链接：http://www.cnblogs.com/david-zhang-index/archive/2012/07/18/2597573.html

1.应用程序连接Oracle rac的URL写法：

 1 #Oracle(AMS)
 2 jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
 3 jdbc.url=jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.176.199)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.176.198)
 4 (PORT = 1521))(LOAD_BALANCE = yes)(FAILOVER = yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = kobra)(FAILOVER_MODE=(TYPE = SELECT)(METHOD = BASIC)(RET
 5 IRES = 180)(DELAY = 15))))
 6 jdbc.username=kms
 7 jdbc.password=kms
 8 
 9 
10 #Oracle(Addon-KOBRA)
11 jdbc1.driverClassName=oracle.jdbc.driver.OracleDriver
12 jdbc1.url=jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.176.199)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.176.198
13 )(PORT = 1521))(LOAD_BALANCE = yes)(FAILOVER = yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = kobra)(FAILOVER_MODE=(TYPE = SELECT)(METHOD = BASIC)(RE
14 TIRES = 180)(DELAY = 15))))
15 jdbc1.username=bond
16 jdbc1.password=bond

 备注：如果使用scap ip，可以将以下代码直接替换成scan ip，形式为：jdbc:oracle:thin:@scap ip：1521：kobra

1 (DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.176.199)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.176.198)
2 (PORT = 1521))(LOAD_BALANCE = yes)(FAILOVER = yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = kobra)(FAILOVER_MODE=(TYPE = SELECT)(METHOD = BASIC)(RET
3 IRES = 180)(DELAY = 15))))
4 (DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.176.199)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.176.198
5 )(PORT = 1521))(LOAD_BALANCE = yes)(FAILOVER = yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = kobra)(FAILOVER_MODE=(TYPE = SELECT)(METHOD = BASIC)(RE
6 TIRES = 180)(DELAY = 15))))

 2.客户端tnsnames.ora文件写法如下：

 1 ractest =
 2   (DESCRIPTION =
 3     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.176.199)(PORT = 1521))
 4     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.176.198)(PORT = 1521))
 5     (LOAD_BALANCE= yes)
 6     (FAILOVER= yes)
 7     (CONNECT_DATA =
 8       (SERVER = DEDICATED)
 9       (SERVICE_NAME = kobra)
10     )
11   )

备注：同样，可以将以下ip地址用sacn ip或域名替来替换

 1 ractest =
 2   (DESCRIPTION =
 3   (ADDRESS = (PROTOCOL = TCP)(HOST = scan-ip.localdomain)(PORT = 1521))
 4     (LOAD_BALANCE= yes)
 5     (FAILOVER= yes)
 6     (CONNECT_DATA =
 7       (SERVER = DEDICATED)
 8       (SERVICE_NAME = kobra)
 9     )
10   )
posted @ 2012-07-18 15:49  david_zhang@sh  阅读(13349)  评论(0)  编辑  收藏  举报