Database - RAC/Scalability (MOSC)

MOSC Banner

Connection String for 2 node 11g RAC database - Client Side Vs Server side

edited Sep 7, 2010 10:52AM in Database - RAC/Scalability (MOSC) 3 commentsAnswered
  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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center