Tuesday, July 28, 2009

How To Access Forms Directly In Oracle Applications R12

By default in Oracle Applications R12, users are not able to access Forms directly via the following url:
http://hostname.domain:port/forms/frmservlet
The following error would pop out:
APP-FND-01542: This Applications Server is not authorized to access this database.


The goal of this document is to allow users access to the Oracle Applications R12 directly via Forms especially in cases where access to the following url is not available:

http://hostname.domain:port/OA_HTML/AppsLogin
NOTE: Accessing Forms directly is not supported and should only be used for diagnostic and troubleshooting purposes.

Solution
1. Edit $CONTEXT_FILE which is located in $INST_TOP/appl/admin
2. ChangeSECUREtoOFF
Application Server Security Authentication can take one of the following values {ON, OFF, SECURE}.OFF - Server security is not checked. Any application server machine can access the database.ON - Some level of trust is required to access the database. Either the Application Server is registered with the database or the module and version ID are known to be trusted.SECURE - Full trust is required for access to the database. Only registered Application Server machines and trusted code modules may connect.

3. Run $INST_TOP/admin/scripts/adautocfg.sh to instantiate the changes
4. Users are now able to access Forms directly.

1 comment:

Unknown said...

besides other solutions for mssql database repair, I may recommend another program that quickly repairs corrupted documents