Connection String for 2 node 11g RAC database - Client Side Vs Server side
Hi,
We have a 2 node 9i RAC database. Here is the configuration in the application server to connect to 9i RAC database
jdbc:oracle:oci:@(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE = ON)
(FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = pdb1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = pdb2)(PORT = 1521)) )
(CONNECT_DATA =
(SERVICE_NAME = ACTPROD)
(FAILOVER_MODE=
(METHOD=BASIC)
we are migrating the database to 11g .We have configured the system and have created the database service "ACTPROD"
For 11g, do we need to keep the above OCI connection string? Would not it mean that we are using Client side load balancing / fail over instead of using server side load balancing and
We have a 2 node 9i RAC database. Here is the configuration in the application server to connect to 9i RAC database
jdbc:oracle:oci:@(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE = ON)
(FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = pdb1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = pdb2)(PORT = 1521)) )
(CONNECT_DATA =
(SERVICE_NAME = ACTPROD)
(FAILOVER_MODE=
(METHOD=BASIC)
we are migrating the database to 11g .We have configured the system and have created the database service "ACTPROD"
For 11g, do we need to keep the above OCI connection string? Would not it mean that we are using Client side load balancing / fail over instead of using server side load balancing and
0