Client Side Load Balancing? TNSNAMES ?

From: <nigel_tufnel_at_my-dejanews.com>
Date: Mon, 07 Dec 1998 13:32:18 GMT
Message-ID: <74gld2$fck$1@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 - 07:32:18 CST