Oracle Forms

Hi all,

I'm not sure if I should post this here or on the RAC forum but this is the issue;

Oracle Forms and Reports services, not the entire app server. Version 10.1.2.0.2, one server
Oracle database, RAC Version 11.1.0.6.0, 3 nodes
Instance=RMSTEST
Nodes = RMSTEST1, RMSTEST2, RMSTEST3

I can TNSPING RMSTEST w/o issue

When I have userid in formsweb.cfg = user/pw@RMSTEST we are being prompted when logging into forms and reports to supply the password for the RMSTEST instance, enter the password and we are in.

So we changed this in formsweb.cfg = user/pw@RMSTEST? (?= any of the nodes 1-3) and the password prompt is no longer being requested.

What do I need to do to have Forms and Reports connect to the RMSTEST cluster directly for it to determine which node to connect to instead of having an unbalanced node(s)?

Thanks,
Steve