RE: Improper Load Balancing

From: Freeman, Donald <dofreeman_at_state.pa.us>
Date: Thu, 22 Mar 2007 11:08:18 -0400
Message-ID: <51327ABA927BEF4B96590554CEA7832C29080C@enhbgpri05.backup>

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_at_perftuning.com] Sent: Thursday, March 22, 2007 10:35 AM
To: dofreeman_at_state.pa.us; oracle-l_at_freelists.org 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Freeman, Donald Sent: Thursday, March 22, 2007 7:55 AM
To: oracle-l_at_freelists.org
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

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

Received on Thu Mar 22 2007 - 10:08:18 CDT