Re: Oracle 10g R2 RAC server side load balancing

On Jun 17, 4:28 pm, zigzag..._at_yahoo.com wrote:
> On Jun 17, 2:58 pm, DA Morgan <damor..._at_psoug.org> wrote:
>
>
>
>
>
> > zigzag..._at_yahoo.com wrote:
> > > On Jun 17, 2:41 pm, DA Morgan <damor..._at_psoug.org> wrote:
> > >> zigzag..._at_yahoo.com wrote:
> > >>> I am on Windows 2003 server.
> > >>> In Oracle 10g r2, Oracle provides a load balancing advisory to
> > >>> distribute load
> > >>> among various noads when connections are made, i.e., a connection may
> > >>> be made
> > >>> to least loaded node. Oracle documentation also says somewhere that
> > >>> this feature is only available with clients which use ODP.NET, JDBC,
> > >>> OCI.
> > >>> 1. If my application is using PRO*C instead of OCI, then connections
> > >>> made by the application cannot utilize server side load balancing.
> > >> How do you use Pro*C and not use OCI?
>
> > >>> 2. Is it correct that my application code will not require any
> > >>> changes to take advantage of this feature?
> > >> Depends on whether your application is coded properly: We don't know.
> > >> --
> > >> Daniel A. Morgan
> > >> University of Washington
> > >> damor..._at_x.washington.edu (replace x with u to respond)
> > >> Puget Sound Oracle Users Groupwww.psoug.org
>
> > > 1. PRO*C is PRO*C - not sure whether Oracle pre-compiles it into OCI
> > > calls.
>
> > Are you seriously going to state that you wrote code in a tool without
> > determining what that tool is and does? April first was two months ago.
> > I thought it was only VB programmers that did that.
>
> > > 2. What do you mean applicaion is coded properly. I did not see
> > > anywwhere information that code has to be written in a certain way.
>
> > Not to be harsh but given your response to #1, above, I am not surprised.
>
> > > I am not utilizing TAF or OFN (?) events, simily making database
> > > connections ... I will think that one should not require any code
> > > changes at all.
>
> > OFN? Do you mean FCF or ONS? Either way load balancing is done at the
> > listener layer. Failover is done by TAF and FCF.
>
> > I am totally perplexed that anyone let you near an Oracle RAC cluster
> > with a tool like Pro*C and not a byte of understanding of what it is
> > you are messing with.
>
> > Did your CTO make a bet on whether Oracle is unbreakable?
> > --
> > Daniel A. Morgan
> > University of Washington
> > damor..._at_x.washington.edu (replace x with u to respond)
> > Puget Sound Oracle Users Groupwww.psoug.org-Hide quoted text -
>
> > - Show quoted text -
>
> http://download-east.oracle.com/docs/cd/B19306_01/rac.102/b28759/conf...
>
> This link dicusses Server Side Load balancing (that's what I am
> interested) and Run Time Load Balacing (which is also Server Side Load
> Balancing). Second one mentions about OCI, ODP,NET and JDBC ...
>
> I am assiming first one will work without requiring any code changes.- Hide quoted text -
>
> - Show quoted text -

Here is something on Oracle's web site, which totally confuses me. It looks like one may need to modify client code. If I have a packged application like SAP, Documentum I may not be able to use Server Side Load Balancing if they have not set it up.

How do I enable the load balancing advisory? The load balancing advisory requires the use of services and Oracle Net connection load balancing.
To enable it, on the server: set a goal (service_time or throughput, for ODP.NET enable AQ_HA_NOTIFICATIONS=>true, and set CLB_GOAL ) on your service.
For client, you must be using the connection pool. For JDBC, enable the datasource parameter FastConnectionFailoverEnabled.
For ODP.NET enable the datasource parameter Load Balancing=true. Received on Sun Jun 17 2007 - 16:21:22 CDT