Overcoming the Oracle Apps R12 Error APP-FND-01542 on 64 bit Redhat 5.5

Symptom:

Ever try to login to Oracle Apps R12, and get the error APP-FND-01542 on 64 bit Redhat 5.5?

APP-FND-01542
The applications servers is not authorized to access this database.

Here is how to solve it.


Cause:

In the CONTEXT_FILE, the setting, s_appserverid_authentication is set to SECURE.

Modes:
- ON : Partial
- SECURE : activates full server security (SECURE mode)
- OFF : deactivates server security


Solution:

Find the CONTEXT_FILE. In my case:

CONTEXT_FILE=/oapps/applmgr/VIS/inst/apps/VIS_black/appl/admin/VIS_black.xml

cd /oapps/applmgr/VIS/inst/apps/VIS_black/appl/admin

Backup the file:
cp VIS_black.xml VIS_black.xml_2012jan21


Look for the setting: s_appserverid_authentication
Ensure it is there:

cat /oapps/applmgr/VIS/inst/apps/VIS_black/appl/admin/VIS_black.xml | grep -i "appserverid_auth"
SECURE


Edit the file. Change the setting to OFF.

------------

Of course, only change the setting to OFF, if your environment security policies would allow it.

------------

Run the Script:
adautocfg.sh


You then need to "recompile" all the scripts that Oracle Apps uses.

Use the script: adautocfg.sh
Found in ADMIN_SCRIPTS_HOME

In my case:
ADMIN_SCRIPTS_HOME=/oapps/applmgr/VIS/inst/apps/VIS_black/admin/scripts


Shutdown the APPS middle tier.


As applmgr:

cd /oapps/applmgr/VIS/inst/apps/VIS_black/admin/scripts/
sh adautocfg.sh

Enter the password for APPS

It will then take a number of minutes to reconfigure all the scripts.


Enter the APPS user password:

The log file for this session is located at: /oapps/applmgr/VIS/inst/apps/VIS_black/admin/log/01221331/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /oapps/applmgr/VIS/inst/apps/VIS_black
A Classpath : /oapps/applmgr/VIS/apps/apps_st/comn/java/lib/appsborg2.zip:/oapps/applmgr/VIS/apps/apps_st/comn/java/classes

Using Context file : /oapps/applmgr/VIS/inst/apps/VIS_black/appl/admin/VIS_black.xml

Context Value Management will now update the Context file

Updating Context file...COMPLETED

Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring MSC_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring IGS_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.



--------------

It reconfigures 31 TOPs.

Check the activity in the log file. Almost 4000 lines long.

/oapps/applmgr/VIS/inst/apps/VIS_black/admin/log/01221331/adconfig.log

From the log, it also logs into the database with sqlplus

--------------

Restart The Apps Middle Tier.


Test.

file:///oapps/applmgr/VIS/apps/tech_st/10.1.2/tools/web/html/runform.htm

Login

The error should be solved now.

--------------------


Useful Links:

From 2007:
http://firokun.wordpress.com/2007/06/11/app-fnd-01542-this-application-server-is-not-authorized-to-access-this-system/

http://onlineappsdba.blogspot.com/2007/10/enabling-f60cgi-direct-login-in-oracle.html

From 2010:
http://appsdbaworkshop.blogspot.com/2010/12/app-fnd-01542-this-application-server.html