Qracle集群中PL/SQL和Java程序连接方式

Qracle集群中PL/SQL和Java程序连接方式

Oracle非集群中PL/SQL连接配置：
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集群中PL/SQL连接配置：

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 =
(SERVER = DEDICATED)
(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 =(SERVER = DEDICATED)(SERVICE_NAME = bester)))