Oracle集群（RAC）及 jdbc 联接双机数据库
Oracle集群（RAC）及 jdbc 连接双机数据库
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)))