RE: Improper Load Balancing
- From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
- To: "Bryan Thomas" <bthomas@xxxxxxxxxxxxxx>, "Freeman, Donald" <dofreeman@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 22 Mar 2007 11:08:18 -0400
Ah yes, sorry! Lost my mind there for a minute. Its Oracle 9.2.0.8
(latest security patch) on Windows 2003 Server.
LISTENERS_xPC =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XX.XX)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XX.XX)(PORT = 1521))
)
LISTENER_xPC1 =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XX.XX)(PORT = 1521))
LISTENER_xPC2 =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XX.XX)(PORT = 1521))
xPC =
(DESCRIPTION =
(LOAD_BALANCE = on)
(FAILOVER = on)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = tcp)(HOST = XXX.XXX.XX.XX)(PORT = 1521))
(ADDRESS = (PROTOCOL = tcp)(HOST = XXX.XXX.XX.XX)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PC)
(FAILOVER_MODE =
(TYPE = session)
(METHOD = basic)
)
)
)
PC1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XX.XX)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = pc)
(INSTANCE_NAME = pc1)
(SERVER=DEDICATED)
)
)
PC2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XX.XX)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = pc)
(INSTANCE_NAME = pc2)
)
)
_____
From: Bryan Thomas [mailto:bthomas@xxxxxxxxxxxxxx]
Sent: Thursday, March 22, 2007 10:35 AM
To: dofreeman@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Improper Load Balancing
Don,
Can you post your tnsnames file, oracle version, os version, client
version, etc? This may help.
Bryan Thomas
Senior Consultant and Practice Manager
Performance Tuning Corporation
www.perftuning.com <http://www.perftuning.com/>
_____
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Freeman, Donald
Sent: Thursday, March 22, 2007 7:55 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Improper Load Balancing
We are experiencing problems with the database connectivity from the
production web servers for the last 2-3 weeks. We are using Oracle RAC
in the production and there are 2 database servers. Somehow the
connection goes to one database server intermittently, not all the time.
But when it happens we see most of the connections going to the same
Oracle node i.e. second node. We are using Windows load balancing on the
web servers. Does anybody have any idea what might cause this?
Don Freeman
Database Administrator 1
Bureau of Information Technology
Pennsylvania Department of Health
(717) 703-5782
Other related posts:
