Load Balancing in Oracle 9i Forms Application

[yagish]

Hi Techies,

Am really new with the Oracle 9i Forms and am searching for a way to
perform Load Balancing in Oracle 9i Forms Application. Its not a J2EE
application, so cannot go the OC4J way.
I need Load Balancing at 2 levels -

1) Load Balancing of the Forms Server
2) Load Balancing of the Database

This means, a request from a client is forwarded to the Forms Server
having minimum load. And, Forms Server further communicates to the
database with the minimum load.( The databases are synchronized )

I need some pointers, on "How" can this be done.

Please suggest some ways, and feel free to ask any further questions.

Thanks.

Yagish Sharma

[sybrandb]

ya****@msn.com (yagish) wrote in message news:<8d**************************@posting.google. com>...

Hi Techies,

Am really new with the Oracle 9i Forms and am searching for a way to
perform Load Balancing in Oracle 9i Forms Application. Its not a J2EE
application, so cannot go the OC4J way.
I need Load Balancing at 2 levels -

1) Load Balancing of the Forms Server
2) Load Balancing of the Database

This means, a request from a client is forwarded to the Forms Server
having minimum load. And, Forms Server further communicates to the
database with the minimum load.( The databases are synchronized )

I need some pointers, on "How" can this be done.

Please suggest some ways, and feel free to ask any further questions.

Thanks.

Yagish Sharma

What problem are you trying to solve?
A crappy application? A crappy database?
Or a combination of the two?
You do not really want seriously to go for this scenario, do you?
Or are you just being adventurous?

Please look up the word 'Load Balancing' on the Oracle documentation
site (evidently you didn't do that little to resolve your own problem)
or specify more clearly why on earth, other than for career limiting
purposes, and indulging to live in a mess, you want this.

Sybrand Bakker
Senior Oracle DBA

[Ana C. Dent]

ya****@msn.com (yagish) wrote in
news:8d**************************@posting.google.c om:

Hi Techies,

Am really new with the Oracle 9i Forms and am searching for a way to
perform Load Balancing in Oracle 9i Forms Application. Its not a J2EE
application, so cannot go the OC4J way.
I need Load Balancing at 2 levels -

1) Load Balancing of the Forms Server
2) Load Balancing of the Database

This means, a request from a client is forwarded to the Forms Server
having minimum load. And, Forms Server further communicates to the
database with the minimum load.( The databases are synchronized )

I need some pointers, on "How" can this be done.

Please suggest some ways, and feel free to ask any further questions.

Thanks.

Yagish Sharma

Keep in mind that "Load Balancing of the Forms Server"
only occurs upon initial login. None of the other Forms
servers would have any history of your session after logon.

One way is to use Oracle's WebCache.
Another is a hardware solution such as Big IP from F5.