Re: Does Parallel Server Load Balance ?

OPS by itself doesn't do load balancing. If you want load balancing you need to set up your TNSNames.ora file with a description list which contains your node information. One byproduct of using this configuration is that all users will connect to the surviving nodes if a node goes down. Downfalls are TNSPing will not work and when you connect you won't know which node your connected to unless you query v$parameter and check which thread you're using. Search your online Oracle documentation for "listener load balancing" for an example of how this is done.

Bob

In article <89gr0n$uq3$1_at_nnrp1.deja.com>,   b_aggy_at_hotmail.com wrote:
> Hi People,
>
> Does Parallel Server distribute connections accross the Oracle
> instances on clustered nodes automatically? Or is it that users still
> connect to a particular Oracle instance. Does it in fact do any sort of
> load balancing accross nodes ?
>
> Rick.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Mar 02 2000 - 00:00:00 CST