Message-ID: <OFF5367E2A.937EE235-ON85256ADB.004E1083@e-BANK.local> From: Eric.Desai@ebancllc.com Date: Thu, 4 Oct 2001 10:13:16 -0400 Subject: RE: [suse-oracle] load balancing for RAC
Thanks David.
Do you have a good understanding on how load balancing actually works?
Whats giving it the smarts to determine which node should handle the
session?
I was running some test by logging into sqlplus multiple times from a
clients box.
7 sql session processes went to node 1 and only 2 sql session processes
went to node 2. That disproves the theory that the connection run in a
round robin fashion???
Thanks for any insight.
David Robertson
<david.robertson@per To: "'Eric.Desai@ebancllc.com'" <Eric.Desai@ebancllc.com>
sonic.com> cc:
Subject: RE: [suse-oracle] load balancing for RAC
10/04/2001 08:18 AM
Yes, Thank You, I was aware of those additional parameters, however, that
is
the default behavior for failover mode on a select statement. It's the
other parameters for the (method= ) that give you the query failover. But
unless this system is for a DSS application with very long running queries,
I wouldn't set them to anything else but basic. I'm glad to here that you
have RAC configured and running, I hope to work with RAC soon, most of my
experience is with OPS. Good Luck!
-----Original Message-----
From: Eric.Desai@ebancllc.com [mailto:Eric.Desai@ebancllc.com]
Sent: Wednesday, October 03, 2001 5:24 PM
To: David Robertson
Subject: RE: [suse-oracle] load balancing for RAC
Thanks David. It appears to be working. I queried v$session and it
appears to be working. Here's a couple of other params (for failover mode)
which I added to my tnsnames file.
test9i =
(DESCRIPTION =
(LOAD_BALANCE=ON)
(FAILOVER=ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = spock)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = tuvok)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = test9i)
(failover_mode=
(type=select)
(method=basic))
)
)
David Robertson
<david.robertson@per To:
"'Eric.Desai@ebancllc.com'" <Eric.Desai@ebancllc.com>
sonic.com> cc:
Subject: RE:
[suse-oracle] load balancing for RAC
10/03/2001 05:14 PM
For a Tnsnames use the following:
OPS =
(DESCRIPTION =
(load_balance=on)
(failover=on)
(ADDRESS = (PROTOCOL = TCP)(HOST = Ip Address or Alias)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = Ip Address or Alias)(PORT = 1521))
(CONNECT_DATA =
(service_name = Your.Service.Name)
)
)
Listener doesn't have anything different for each machine.
For MTS try:
mts_dispatchers = "(protocol=TCP) (disp=7) (host = Ip
Address for Listener)"
mts_max_dispatchers = 20
mts_servers = 10
mts_max_servers = 50
There is also an additional MTS parameter that I never added but wanted
too,
that had to do with the listener's communicating with each other. I'm sure
it's in the docs, but don't know right off the top of my head.
Hope this helps.
-----Original Message-----
From: Eric.Desai@ebancllc.com [mailto:Eric.Desai@ebancllc.com]
Sent: Wednesday, October 03, 2001 4:56 PM
To: suse-oracle@suse.com
Subject: [suse-oracle] load balancing for RAC
Does anyone have any sample listener.ora and tnsnames files which enable
load balancing on RAC?????
I'm also looking into which init.ora parameters need to be modified in
order to implement load balancing. I'm pretty sure MTS (not dedicated
servers) are needed to implement load balancing. Have any examples???
-- To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com For additional commands, e-mail: suse-oracle-help@suse.com
This archive was generated by hypermail 2.1.0 : Thu Oct 11 2001 - 14:55:27 PDT