RAC - tns entries [message #538349] |
Thu, 05 January 2012 07:15 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8932 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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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?
|
|
|
|