Home » Server Options » RAC & Failsafe » RAC - tns entries (Oracle, 11g, solaris)
RAC - tns entries [message #538349] Thu, 05 January 2012 07:15 Go to next message
sathik
Messages: 196
Registered: August 2009
Location: INDIA
Senior Member
Hi,

I could not able to understand the SERVICE_NAME settings in the below tns entries. it is a RAC database.
Here eimap_any and eimtp_node2_3 are really pointing which instance? and how to check what are the instance registered in this eimap_any and eimap_node2_3 service_name?

eimap_any =
  (DESCRIPTION_LIST =
    (LOAD_BALANCE = OFF)
    (FAILOVER = ON)
    (DESCRIPTION =
      (ADDRESS_LIST =
        (LOAD_BALANCE = ON)
        (FAILOVER = ON)
        (ADDRESS = (PROTOCOL = TCP)(HOST = dyl079d001-oravip.nat.bt.com)(PORT = 61901))
        (ADDRESS = (PROTOCOL = TCP)(HOST = dyl079d002-oravip.nat.bt.com)(PORT = 61901))
        (ADDRESS = (PROTOCOL = TCP)(HOST = dyl079d003-oravip.nat.bt.com)(PORT = 61901))
##      (ADDRESS = (PROTOCOL = TCP)(HOST = dyl079d004-oravip.nat.bt.com)(PORT = 61901))
      )
      (CONNECT_DATA =
        (SERVICE_NAME = eimap_any)
        (FAILOVER_MODE =
          (TYPE = SESSION)
          (METHOD = BASIC)
          (RETRIES = 120)
          (DELAY = 5)
        )
      )
    )
  )


eimap_node2_3 =
  (DESCRIPTION_LIST =
    (LOAD_BALANCE = OFF)
    (FAILOVER = ON)
    (DESCRIPTION =
      (ADDRESS_LIST =
        (LOAD_BALANCE = ON)
        (FAILOVER = ON)
        (ADDRESS = (PROTOCOL = TCP)(HOST = dyl079d001-oravip.nat.bt.com)(PORT = 61903))
        (ADDRESS = (PROTOCOL = TCP)(HOST = dyl079d002-oravip.nat.bt.com)(PORT = 61903))
        (ADDRESS = (PROTOCOL = TCP)(HOST = dyl079d003-oravip.nat.bt.com)(PORT = 61903))
      )
      (CONNECT_DATA =
        (SERVICE_NAME = eimtp_node2_3)
        (FAILOVER_MODE =
          (TYPE = SESSION)
          (METHOD = BASIC)
          (RETRIES = 120)
          (DELAY = 5)
        )
      )
    )
  )


eimap_i01 =
  (DESCRIPTION_LIST =
    (LOAD_BALANCE = OFF)
    (FAILOVER = ON)
    (DESCRIPTION =
      (ADDRESS_LIST =
        (LOAD_BALANCE = ON)
        (FAILOVER = ON)
        (ADDRESS = (PROTOCOL = TCP)(HOST = dyl079d001-oravip.nat.bt.com)(PORT = 61901))
        (ADDRESS = (PROTOCOL = TCP)(HOST = dyl079d002-oravip.nat.bt.com)(PORT = 61901))
        (ADDRESS = (PROTOCOL = TCP)(HOST = dyl079d003-oravip.nat.bt.com)(PORT = 61901))
##      (ADDRESS = (PROTOCOL = TCP)(HOST = dyl079d004-oravip.nat.bt.com)(PORT = 61901))
      )
      (CONNECT_DATA =
        (SERVICE_NAME = eimap_i01)
        (FAILOVER_MODE =
          (TYPE = SESSION)
          (METHOD = BASIC)
          (RETRIES = 120)
          (DELAY = 5)
        )
      )
    )
  )

eimap_i02 =
  (DESCRIPTION_LIST =
    (LOAD_BALANCE = OFF)
    (FAILOVER = ON)
    (DESCRIPTION =
      (ADDRESS_LIST =
        (LOAD_BALANCE = ON)
        (FAILOVER = ON)
        (ADDRESS = (PROTOCOL = TCP)(HOST = dyl079d001-oravip.nat.bt.com)(PORT = 61901))
        (ADDRESS = (PROTOCOL = TCP)(HOST = dyl079d002-oravip.nat.bt.com)(PORT = 61901))
        (ADDRESS = (PROTOCOL = TCP)(HOST = dyl079d003-oravip.nat.bt.com)(PORT = 61901))
##      (ADDRESS = (PROTOCOL = TCP)(HOST = dyl079d004-oravip.nat.bt.com)(PORT = 61901))
      )
      (CONNECT_DATA =
        (SERVICE_NAME = eimap_i02)
        (FAILOVER_MODE =
          (TYPE = SESSION)
          (METHOD = BASIC)
          (RETRIES = 120)
          (DELAY = 5)
        )
      )
    )
  )

eimap_i03 =
  (DESCRIPTION_LIST =
    (LOAD_BALANCE = OFF)
    (FAILOVER = ON)
    (DESCRIPTION =
      (ADDRESS_LIST =
        (LOAD_BALANCE = ON)
        (FAILOVER = ON)
        (ADDRESS = (PROTOCOL = TCP)(HOST = dyl079d001-oravip.nat.bt.com)(PORT = 61901))
        (ADDRESS = (PROTOCOL = TCP)(HOST = dyl079d002-oravip.nat.bt.com)(PORT = 61901))
        (ADDRESS = (PROTOCOL = TCP)(HOST = dyl079d003-oravip.nat.bt.com)(PORT = 61901))
##      (ADDRESS = (PROTOCOL = TCP)(HOST = dyl079d004-oravip.nat.bt.com)(PORT = 61901))
      )
      (CONNECT_DATA =
        (SERVICE_NAME = eimap_i03)
        (FAILOVER_MODE =
          (TYPE = SESSION)
          (METHOD = BASIC)
          (RETRIES = 120)
          (DELAY = 5)
        )
      )
    )
  )

[Updated on: Thu, 05 January 2012 07:16]

Report message to a moderator

Re: RAC - tns entries [message #538351 is a reply to message #538349] Thu, 05 January 2012 07:48 Go to previous messageGo to next message
John Watson
Messages: 8916
Registered: January 2010
Location: Global Village
Senior Member
Hello - there is no fixed mapping between a service and an instance. This is the basis of RAC high availability. There are many ways to determine which instances are currently offering which services, probably the easiest is to query the gv$active_services view.
Rgds, John.
Re: RAC - tns entries [message #538365 is a reply to message #538351] Thu, 05 January 2012 09:40 Go to previous messageGo to next message
sathik
Messages: 196
Registered: August 2009
Location: INDIA
Senior Member
Thanks for the response.

So I can have many number of services in different name. Since all services are pointing all nodes, what is the use of having different services? OR will there be any restriction in instance level to use the particular services alone? if yes, where I can check that?
Re: RAC - tns entries [message #538367 is a reply to message #538365] Thu, 05 January 2012 09:49 Go to previous message
John Watson
Messages: 8916
Registered: January 2010
Location: Global Village
Senior Member
Time to do some reading:
http://docs.oracle.com/cd/B28359_01/rac.111/b28254/toc.htm#
chapter 4 in particular.
Previous Topic: Issue while shutting down ASM instance in 11gR2
Next Topic: Memory usage increasing on Oracle RAC
Goto Forum:
  


Current Time: Thu Feb 29 03:26:44 CST 2024