Database Networking (MOSC)

MOSC Banner

Services and tnsnames in RAC environment

edited Feb 19, 2009 3:05AM in Database Networking (MOSC) 3 commentsAnswered
  Hi

we have 3 questions and would appreciate if anyone can answer these for us


1. we have created a service "ISF" on our RAC database

select * from dba_services

NAME      NETWORK    FAILOVER    FAILOVER  FAILOVER    FAILOVER     GOAL         ENABLED
                NAME          METHOD      TYPE           RETRIES      DELAY
============================================================================
SYS$BACKGROUND                                                                                   NONE           NO
SYS$USERS                                                                                               NONE           NO
isf             isf                                                                                               NONE           NO

when we created the ISF service, following entry was added to the tnsnames.ora file on both db nodes
ISF =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = db1-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = db2-vip)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = isf)
      (FAILOVER_MODE =

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