Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Client Side Load Balancing? TNSNAMES ?
Needs net 2.3.3 or above ...
Daniel...
nigel_tufnel_at_my-dejanews.com wrote in message
<74gld2$fck$1_at_nnrp1.dejanews.com>...
>Gentlefolk:
>
>I'm trying to create a TNSNAMES for an NT client that will randomly pick
from
>any number of listeners I have created on the server. I'm using SqlNet 2.1
>and Oracle 7.3.4
>
>No matter how I write the file the clients seem to always pick the first
>listener on the list.
>
>Is ther some trick I'm missing? Here is the structure I'm using. It's
from
>memory:
>
>DB00 =
> (DESCRIPTION_LIST=
> (DESCRIPTION=
> (ADDRESS_LIST=
> (ADDRESS=
> IP Address stuff here
> )
> )
> (CONNECT_INFO (forgot the name) = (SID=db00.world))
> )
> (DESCRIPTION=
> (ADDRESS_LIST=
> (ADDRESS=
> IP Address stuff here
> )
> )
> (CONNECT_INFO (forgot the name) = (SID=db00.world))
> )
>)
>I know my listeners work because If I change TNSNAMES to use one or the
other
>listener everything works fine, and if I use two machines, with different
>TNSNAMES files I can hit both listeners at once. This machine happens to
have
>2 ethernet cards each with it's own IP address.
>
>
>Any help is appreciated,
>
>
>Nigel
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Dec 07 1998 - 09:22:20 CST