PL/SQL connection configuration in Oracle non-cluster:
DB1_193 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 59.208.39.193) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = bester)
)
)
Non-cluster java connection url
Url = jdbc: oracle: thin: @ 127.0.0.1: 1521: bester
PL/SQL connection configuration in an Oracle cluster:
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)
)
)
Java program connection url in the oracle Cluster
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 )))