Re: RAC Re: Load balancing

Hi David,

It certainly seems to be true from the documentation point of view!

i haven't tried it myself and i just can't find a RAC database to test it...though most of documents you can see would suggest load_balance=on.

i guess your setup may not be working due to the 'services' parameter in init.ora/spfile. Just check it once again, make it consistent for all instances. you don't need to user alter system commands to add services. ensure that local_listener parameter is also present for each RAC instance and it is resolvable in tnsnames.ora.

Have you got entries for the individual RAC instances in tnsnames.ora? well, i guess you might have read Metalink notes for configuring this....

lsnrctl services <listener_name> should give you the details of the connection(s) per instance.

cheers
anand

On 09/12/05, David Sharples <davidsharples_at_gmail.com> wrote:
>
> Thanks, but in the docs here
> http://download-west.oracle.com/docs/cd/B10501_01/rac.920/a96597/psscadtl.htm#16638
>
> it says load_balance can be set to on, yes or true - is that incorrect?
>
>
> On 12/9/05, Anand Rao <panandrao_at_gmail.com> wrote:
> >
> > You need use load_balancing=ON :-)
> >
> > ensure that the tnsnames.ora is exactly the same on client and server
> > side.
> >
> > set the init.ora/spfile parameter service_names correctly on all
> > instances.
> >
>

--
http://www.freelists.org/webpage/oracle-l