使用中间件方式连接数据库时,很多都知道连接串的写法:
jdbc:oracle:thin:@192.168.3.98:1521:orcl
其中192.168.3.98为数据库服务器的ip地址
1521为listener的端口
orcl代表实例名
但是,当碰到oracle rac时,因为对于RAC,一个数据库有两个实例,很多人都不知道该怎么写,实际上,当碰到ORACLE RAC时,应该把两个oracle的vip都写到URL中,这样才能起到故障切换的功能,如下所示:
jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.2)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.4)(PORT = 1521))(LOAD_BALANCE = yes))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl)(FAILOVER_MODE =(TYPE = SELECT )(METHOD = BASIC)(RETRIES = 120)(DELAY = 5))))
其中,把10.10.10.2 , 10.10.10.4换成具体数据库的vip
orcl换成生产系统的数据库名 (非实例名,实例名为orcl1, orcl2)
jdbc:oracle:thin:@192.168.3.98:1521:orcl
其中192.168.3.98为数据库服务器的ip地址
1521为listener的端口
orcl代表实例名
但是,当碰到oracle rac时,因为对于RAC,一个数据库有两个实例,很多人都不知道该怎么写,实际上,当碰到ORACLE RAC时,应该把两个oracle的vip都写到URL中,这样才能起到故障切换的功能,如下所示:
jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.2)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.4)(PORT = 1521))(LOAD_BALANCE = yes))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl)(FAILOVER_MODE =(TYPE = SELECT )(METHOD = BASIC)(RETRIES = 120)(DELAY = 5))))
其中,把10.10.10.2 , 10.10.10.4换成具体数据库的vip
orcl换成生产系统的数据库名 (非实例名,实例名为orcl1, orcl2)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/786749/viewspace-510241/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/786749/viewspace-510241/