RE: Load Balancing

Hi Oliver,  

here is a trick that i would try  

Disable all listener level loadbalcing by commenting out remote_listener init ora param
on both db servers and change the tns names on the middleter forms/reports servers as follows  

• for 1:1 load balancing

PROD=

        (DESCRIPTION= 
            (LOAD_BALANCE=YES)
            (FAILOVER=YES)
            (ADDRESS_LIST=


                (ADDRESS=(PROTOCOL=tcp)(HOST=server1-vip)(PORT=1521))

                (ADDRESS=(PROTOCOL=tcp)(HOST=server2-vip)(PORT=1521))

            )
            (CONNECT_DATA=


                (SERVICE_NAME=PROD)

            )
        )
 

• for 2:1 load balancing

PROD=

        (DESCRIPTION= 
            (LOAD_BALANCE=YES)
            (FAILOVER=YES)
            (ADDRESS_LIST=


                (ADDRESS=(PROTOCOL=tcp)(HOST=server1-vip)(PORT=1521))

                (ADDRESS=(PROTOCOL=tcp)(HOST=server1-vip)(PORT=1521))

                (ADDRESS=(PROTOCOL=tcp)(HOST=server2-vip)(PORT=1521))

            )
            (CONNECT_DATA=


                (SERVICE_NAME=PROD)

            )
        )
 

• for 3:2 load balancing

PROD=

        (DESCRIPTION= 
            (LOAD_BALANCE=YES)
            (FAILOVER=YES)
            (ADDRESS_LIST=


                (ADDRESS=(PROTOCOL=tcp)(HOST=server1-vip)(PORT=1521))

                (ADDRESS=(PROTOCOL=tcp)(HOST=server1-vip)(PORT=1521))

                (ADDRESS=(PROTOCOL=tcp)(HOST=server1-vip)(PORT=1521))

                (ADDRESS=(PROTOCOL=tcp)(HOST=server2-vip)(PORT=1521))

                (ADDRESS=(PROTOCOL=tcp)(HOST=server2-vip)(PORT=1521))

            )
            (CONNECT_DATA=


                (SERVICE_NAME=PROD)

            )
        )

 

Vasu Balla
Apps DBA - The Pythian Group
www.pythian.com  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Oliver Jost
Sent: Wednesday, October 08, 2008 5:46 PM To: oracle-l_at_freelists.org
Subject: Load Balancing

Hi All,

   If anyone could shed some light I'd appreciate it... I have a 2-node (10gR2/Solaris 9) cluster in which one node has weaker cpu (both have 12 cpu, stronger has 8xUltraSPARC IV+ [1.5 GHz] while the weaker has 8xUltraSPARC IV [1.2 GHz]). The load balancing was favouring the weaker node (e.g. higher active sessions, higher load, new sessions connecting while the stronger node putters along). The sessions have a relatively even spread, however, due to capacity the weaker node is the bottleneck. I'd like to balance server-side but am running into difficulties. Oracle docs state OCI release 2 is required for server-side to work. I believe our middle tier is running an up to date OAS 10.1.2.0.2 (forms/reports, Solaris10). I'm not clear on the middle tier but I believe it uses release 1 for OCI. I'd like to configure the listener to balance by load (I have not been successful in our test environment, working with Oracle on bug or middle tier issues, not resolved yet) so when the weaker server experiences a higher load new connections go to the more powerful server rather than just load balance client-side (2 nodes, 50/50). I do have some options via the middle tier and/or services. The ideal would be minimize configuration changes while maintaining HA.  

Any suggestions (hints, tips, pointers to docs) are welcome.  

 Thanks,
   Oliver

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