Database - RAC/Scalability (MOSC)

MOSC Banner

server side load balancing / fail over vs client side on 2 node RAC

edited Nov 4, 2009 6:54PM in Database - RAC/Scalability (MOSC) 1 commentAnswered

Hi 

We have a 2 node RAC (10g Release 2) on Linux
Appended below is the result from the query against dba_services
SQL> select name,failover_method,failover_type,failover_retries,goal,enabled from dba_services

NAME            FAILOVER_METHO FAILOVER_TYPE  FAILOVER_RETRIES GOAL         ENA
--------------- -------------- -------------- ---------------- ------------ ---
SYS$BACKGROUND                                                 NONE         NO
SYS$USERS                                                      NONE         NO
app                                                            NONE         NO


In the tnsnames.ora on the application server, the entry is as follows

APP =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node-1-VIP)(PORT = 1555))
    (ADDRESS = (PROTOCOL = TCP)(HOST = node-2-VIP)(PORT = 1555))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = app)

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