Re: Oracle 10g R2 RAC server side load balancing

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

zigzagdna_at_yahoo.com wrote:
> On Jun 18, 10:45 am, Frank van Bortel <frank.van.bor..._at_gmail.com>
> wrote:
> http://download-uk.oracle.com/docs/cd/B14117_01/network.101/b10775/ad...
> And just above that:
>
> The following example shows a tnsnames.ora file configured for client
> load balancing:
>
> sales.us.acme.com=
> (DESCRIPTION=
> (ADDRESS_LIST=
> (LOAD_BALANCE=on)
> (ADDRESS=(PROTOCOL=tcp)(HOST=sales1-server)(PORT=1521))
> (ADDRESS=(PROTOCOL=tcp)(HOST=sales2-server)(PORT=1521)))
> (CONNECT_DATA=
> (SERVICE_NAME=sales.us.acme.com)))
>
> So, yes - there is a need for a client side
> change, too, but just the network configuration.

> Frank:
> You are talking about client load balancing, all that does is round
> robbin or so - it sends 50% connections to one server., 50% to other.
> Oracle intrdouced sever side load balancing based on load advaisory
> etc. That is quite different from what yo are talking about. That is
> why confsuion. I have to contact Oracle metalink support.

> Oracle documantaion confuses the issue:
> For client, you must be using the connection pool. Connection pool is
> nothing od od with what you show in tnsnsames.ora.

Correct - missed the RAC stuff in the header.

• -- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGeBQCLw8L4IAs830RAmxkAJ4osJCaNKsrislAGeTnOjRdjeKM1QCgnhK1 8QyfZYiANUx2rUTEw5N2T3I=
=XBjc
-----END PGP SIGNATURE----- Received on Tue Jun 19 2007 - 12:36:02 CDT