OraFAQ Forum: RAC & Failsafe » RAC

Home » Server Options » RAC & Failsafe » RAC - tns entries (Oracle, 11g, solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RAC - tns entries [message #538349]

Thu, 05 January 2012 07:15

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

John Watson
Messages: 8960
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.

Report message to a moderator

Re: RAC - tns entries [message #538365 is a reply to message #538351]

Thu, 05 January 2012 09:40

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?

Report message to a moderator

Re: RAC - tns entries [message #538367 is a reply to message #538365]

Thu, 05 January 2012 09:49

John Watson
Messages: 8960
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.

Report message to a moderator

Previous Topic:	Issue while shutting down ASM instance in 11gR2
Next Topic:	Memory usage increasing on Oracle RAC

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 05:04:07 CST 2024