To set your Oracle E-Business Suite (EBS) R12 Forms server (form_server1) to use specific
proxy settings and connection modes, you will need to adjust the formsweb.cfg file located on
your server. The formsweb.cfg file controls various settings for the Oracle Forms applet.
Here’s a step-by-step guide to configure the formsweb.cfg file with the specified settings:
Step-by-Step Guide:
1. Locate the formsweb.cfg File
The formsweb.cfg file is typically located in the following directory:
bash
Copy code
$INST_TOP/ora/10.1.3/forms/server/formsweb.cfg
Replace $INST_TOP with your actual instance top directory.
2. Edit the formsweb.cfg File
Open the formsweb.cfg file in a text editor. You will need appropriate permissions to edit this
file.
bash
Copy code
vi $INST_TOP/ora/10.1.3/forms/server/formsweb.cfg
3. Configure the Proxy Settings
Locate the section in the formsweb.cfg file that corresponds to your form_server1
configuration. If you have multiple configurations, ensure you are editing the correct one. Add or
modify the following parameters to set the proxy settings and connect modes.
Add or modify these lines under the specific configuration section for form_server1:
ini
Copy code
# Set proxyHost and proxyPort to null and 0 respectively
proxyHost=null
proxyPort=0
# Set connectMode to HTTP and native
connectMode=HTTP, native
4. Ensure the Settings Are Active
To apply these settings, ensure that they are placed under the appropriate configuration section.
Oracle EBS uses sections within formsweb.cfg to apply different settings for different
environments or forms. Here's an example of how this might look in context:
ini
Copy code
[form_server1]
# Other configurations for form_server1
proxyHost=null
proxyPort=0
connectMode=HTTP, native
# End of configurations for form_server1
5. Save and Close the File
After making the changes, save the file and close the text editor. In vi, you can do this by
pressing Esc to enter command mode, then typing :wq and pressing Enter.
6. Restart the Forms Services
For the changes to take effect, you need to restart the Oracle Forms services. You can do this by
running the following commands:
bash
Copy code
cd $INST_TOP/admin/scripts
./adstpall.sh apps/<apps_password>
./adstrtal.sh apps/<apps_password>
Replace <apps_password> with your actual apps user password.
Additional Information
Forms Environment Variables:
In some cases, you might also need to configure the default.env file to reflect these proxy
settings. This file is typically found in the same directory as formsweb.cfg:
bash
Copy code
$INST_TOP/ora/10.1.3/forms/server/default.env
Make sure any related environment variables are correctly set or referenced.
Test the Configuration:
After restarting the services, test the Oracle Forms application to ensure that it’s using the
specified proxy settings and connection modes. Open the Java console in your browser to
confirm the proxy settings and connection mode being used.
Troubleshooting:
1. Check Logs: If there are issues, check the Forms logs typically located in
$INST_TOP/logs/ora/10.1.3/j2ee/forms/default_group_1 for detailed error
messages.
2. Java Console: Use the Java console on the client-side to inspect how the applet is
connecting and to view any error messages related to the proxy or connection mode.
3. Browser Cache: Clear the browser and Java cache to ensure that no old settings are
being used.
Summary of Configuration:
proxyHost=null sets no proxy host.
proxyPort=0 sets the proxy port to zero, effectively disabling proxy usage.
connectMode=HTTP, native allows the Forms applet to connect using both HTTP and
native protocols.
This configuration should help in aligning your EBS R12 Forms server with the required proxy
and connection settings. If you encounter specific errors or need further assistance, please
provide additional details.
