APP-FND-01542

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

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
Backup The File:
cd /oapps/applmgr/VIS/inst/apps/VIS_black/appl/admin
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/app
s/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 and Test:
file:///oapps/applmgr/VIS/apps/tech_st/10.1.2/tools/web/html/runform.htm
Login
The error should be solved now.

APP-FND-01542 Solved

——————–