Oracle集群（RAC）及 jdbc 连接双机数据库

2019独角兽企业重金招聘Python工程师标准>>>

Oracle集群（RAC）及 jdbc 连接双机数据库 博客分类： java

oracle集群url配置

 

 

 

oracle集群中plsql和java程序连接方式非集群中plsql连接配置：

 

  www.2cto.com  

 

　　DB1_193 =

 

　　(DESCRIPTION =

 

　　(ADDRESS_LIST =

 

　　(ADDRESS = (PROTOCOL = TCP)(HOST = 59.208.39.193)(PORT = 1521))

 

　　)

 

　　(CONNECT_DATA =

 

　　(SERVICE_NAME = bester)

 

　　)

 

　　)

 

　　非集群中java连接的url

 

　　url=jdbc:oracle:thin: @127.0.0.1 :1521:bester

 

　　oracle集群中plsql连接配置：

 

　　db_1_2 =

 

　　(DESCRIPTION =

 

　　(ADDRESS = (PROTOCOL = TCP)(HOST = 59.208.39.193)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 59.208.39.195)(PORT = 1521))

 

　　(LOAD_BALANCE=yes)

 

　　(CONNECT_DATA =

 

　

 

　　(SERVICE_NAME = bester)

 

　　)

 

　　)

 

　　oracle集群中java程序连接的url

　　datasource.url=jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST =59.208.39.193)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST =59.208.39.195)(PORT = 1521))(LOAD_BALANCE=yes)(CONNECT_DATA =(SERVICE_NAME = bester)))

转载于:https://my.oschina.net/xiaominmin/blog/1598075