Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 10g R2 RAC server side load balancing
On Jun 18, 10:45 am, Frank van Bortel <frank.van.bor..._at_gmail.com>
wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> 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.
> - --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.1 (MingW32)
>
> iD8DBQFGdpqcLw8L4IAs830RAi5MAJ963+pGKF5E9pOjWO9+kRguuQj0ngCfcovr
> vEapGexZuYxYNl3d0MsAuKs=
> =xY5D
> -----END PGP SIGNATURE-----
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.
Received on Mon Jun 18 2007 - 12:31:08 CDT