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

APP-FND-01542 Solved

——————–

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

About these ads

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: