Re: RAC and db connections

wagen123_at_yahoo.com wrote:
> Oracle10g 10.2.0.3 (64 bit)
> RHEL 4.3 (64 bit)
> 4 node RAC cluster
>
> Often we see all db connections from the application/client go to one
> node ONLY, even though the ALL nodes are relatively idle. Even if we
> make an explicit connection to an instance on a specific node it gets
> redirected to another node (local listener is setup).
>
> How do I determine why the connections are being routed to the other
> nodes? What is causing this and how to fix it?
>
> ex. of the connection string from the client
> TEST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = node1v)(PORT = 1521))
> (ADDRESS = (PROTOCOL = TCP)(HOST = node2v)(PORT = 1521))
> (ADDRESS = (PROTOCOL = TCP)(HOST = node3v)(PORT = 1521))
> (ADDRESS = (PROTOCOL = TCP)(HOST = node4v)(PORT = 1521))
> (LOAD_BALANCE = yes)
> (FAILOVER = ON)
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = SRVR)
> (FAILOVER_MODE =
> (TYPE = SELECT)
> (METHOD = BASIC)
> (RETRIES = 180)
> (DELAY = 5)
> )
> )
> )
>
> Thanks for any pointers.
> wagen

My guess is that you don't have a RAC cluster but rather the appearance of one.

Run cluster verify (cluvfy) and see what is happening.

How was the service SRVR defined?

Are you sure it is pointing at the database and not a single instance.

What happens if you take the instance that is getting all of the connections off-line?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org