Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: tnsnames.ora file
Hi Doug,
And now for the rest...
(DESCRIPTION =
This defines a single description and is used within the
(DESCRIPTION_LIST =
entry. Sqlnet will then randomise which description is used. This could be
used when you want to load balance across multiple listeners or multiple
nodes.
(ADDRESS =
This defines a single address and is used within the
(ADDRESS_LIST =
entry. Sqlnet will try to connect to the first address within the address
list and if this fails will then try the next address and so on. This could
be used if you have multiple ports the listener is listening on or indeed
for multiple protocols, ie; try tcp/ip first and then spx.
Example;
orcl.world =
(DESCRIPTION_LIST=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(HOST = HOST1)
(PORT = 1521)
) (ADDRESS =
(COMMUNITY = spx.world)
(PROTOCOL = SPX)
(SERVICE = HOST1_LSNR)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(HOST = HOST1)
(PORT = 1526)
) (ADDRESS =
(COMMUNITY = spx.world)
(PROTOCOL = SPX)
(SERVICE = HOST1_LSNR)
)
Hope this helps.
Regards,
Daniel... Received on Thu Nov 12 1998 - 05:17:31 CST