Skip to Main Content
Forums

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What is recommended software Load Balancer for Forms/Reports 11g cluster?

Hi,

Assuming a hardware load-balancer is not available, what is the best / recommended software load balancing solution for a Forms/Report 11gR2 clustered environment?

The Forms Service Deployment Guide describes the use of Oracle Web Cache in "load balancer only" mode as an option, but also discourages its use in production/high-volume environments.

Are there any other supported software-only options that are suitable for 100-200 concurrent users?

Thanks for any suggestions,

John.

Comments

SH_INT
Answer

Why won't your finance team accept the approach of logic accounts? This is the obvious solution to your problem. In FDM or FDMEE you can only load on piece of data to one target intersection. If you want to load the same piece of data to multiple target intersections then you need to have that piece of data repeated in the source data nad then you will still need something in the source that could uniquely identify each of those copies so you could map appropriately. As mentioned that is one of the primary functions of logic accounts, other approaches are likely to be messy, more prone to error and a lot more difficult to audit.

Marked as Answer by MarkSmithHFM · Sep 27 2020
1 person found this helpful
MarkSmithHFM

Hi SH,

Thanks for your reply.

I agree with you 100% that logic accounts are the way to go here.  I was just trying to find out if there were any other approaches that would be relatively straightforward and easy to implement.

Other approaches would definitely not be elegant and would involve scripting and probably rewriting file or copying data records via scripts which to me are non-starters.

You reinforced my opinion.   I'll develop my solution using logic accounts.

Thanks,
Mark

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 19 2013
Added on Aug 22 2013
#11g, #cache, #cluster, #forms, #load, #moved-from-devops, #web
0 comments
255 views