Change Server Authentication

APP-FND-01542 when logging directly into forms via the f60cgi in 11.5.10
Note:293609.1
Enabling f60cgi direct login
------------------------------
It is possible to login however this method should only be used when
debugging problems.
1. Backup and open $APPL_TOP/admin/<SID>_<hostname>.xml context file
2. Update the context variable:
s_appserverid_authentication
By default in 11.5.10, this is set to SECURE.
In previous 11i versions, this was set to OFF.
For debug purposes, you can use ON or OFF.
Modes:
- ON : Partial
- SECURE : activates full server security (SECURE mode)
- OFF : deactivates server security
3. Run Autoconfig to instantiate the change.
You should now be able to access forms directly again using the f60cgi call.
4. After you have finished your Forms debugging, please reset
s_appserverid_authentication to SECURE and re-run Autoconfig.
Alternative option
---------------------
Running Autoconfig is the preferred method of updating
s_appserverid_authentication.
If you are unable to run Autoconfig during troubleshooting, you can run the
the following commands instead from $FND_TOP/secure directory:
Disable:
java oracle.apps.fnd.security.AdminAppServer apps/apps \
AUTHENTICATION OFF DBC=host_visdemo1.dbc
Enable:
To activate basic server security, from the command line, enter:
jre oracle.apps.fnd.security.AdminAppServer apps/apps \
AUTHENTICATION ON DBC=<dbc file path>
To activate full server security (SECURE mode), from the command
line, enter:
jre oracle.apps.fnd.security.AdminAppServer apps/apps \
AUTHENTICATION SECURE DBC=<dbc file path>
Check the status:
java oracle.apps.fnd.security.AdminAppServer apps/apps \
STATUS DBC=host_visdemo1.dbc

 

The following are the different error messages when you are running OAF pages from Jdev with Authentication as "Secure". Resolution is "change it to OFF"

oracle.apps.fnd.framework.OAException: Application: FND, Message Name: SECURITY_APPL_SERVER_ID. (Could not lookup message because there is no database connection)

oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FNDSECURITY_APPL_SERVER_ID. (Could not lookup message because there is no database connection)

oracle.apps.fnd.framework.OAException: Application: FND, Message Name: SECURITY_INVALID_DBC_PARAMETER. Tokens: ROUTINE = AppsConnectionManager.makeGuestConnection; FILE = E:\jdev\jdevhome\jdev\dbc_files\secure\FATST.DBC; PARAMETER = GUEST_USER_PWD; (Could not lookup message because there is no database connection)

oracle.apps.fnd.framework.OAException: Application: FND, Message Name: AOLJ_JAVA_EXCEPTION. Tokens: MESSAGE = Not able to create new database connection: FNDSECURITY_APPL_SERVER_ID; (Could not lookup message because there is no database connection)

 

## Detail 0 ##
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.apps.fnd.common.PoolException: Not able to create new database connection: FNDSECURITY_APPL_SERVER_ID; (Could not lookup message because there is no database connection)

Patch driver files

Patch basically has a driver file for installation. Now a days patch comes with a unified(U) driver which is applied on all nodes in a multi-node set up and auto-patch(adpatch) automatically determines what action to take for the node.

Basically there are 3 drivers->

C--copy driver--to copy and update files, libraries, and/or Java--applied on all application tiers

D--database driver--commands to change database objects such as PL/SQL and table definitions, or to update or migrate data---applied on only the application tiers node  which had Admin server

G--generate driver--to generate forms, reports, messages, and/or graphics files---applied on all application tiers unless appl_top implements only the Admin server

Technorati Tags: patch,driver,adpatch

How to change all Applications user passwords

In apps, there are times when we want to force all the application users to change their passwords. In apps 11i, we have a concurrent request under System Administrator->

CP SQL*Plus Expire FND_USER Passwords

This concurrent request basically sets the fnd_user.password_date to null for all apps users. The users are thus prompted to change their passwords on next login.

Technorati Tags: change user passwords,expire passwords,front end users,apps,11i