Shell Scripts

This summary is not available. Please click here to view the post.

Issue FRM-92120

Overview

Every time we come across issues, we need to persistently explore for resolutions. The purpose of this document is to serve as a ready reference if, in future, similar issues are to be dealt with. We shall update this document whenever we encounter further issues.

Issue FRM-92120

OA_JAVA/oracle/forms/registry/Registry.dat is missing.


Resolution

Check locks – $dbsql/swait.sql. Most of the sessions have been blocking here. Kill the blocker session (in this case it is the gather stat session).

Issue APP-FND-1508

Failed to connect when logging into the applications

Resolution:

Eg. Incase of devl1c1(target) refresh from devl1 (source), we get above error in devl1c1.

Refer metalink note# 143685.1
select profile_option_id, level_id, level_value, profile_option_valuefrom fnd_profile_option_valueswhere profile_option_id in (1889, 1995); delete from fnd_profile_option_valueswhere profile_option_value = 'devl1' and PROFILE_OPTION_ID='1995'; commit;
Issue HTTP 404

File not found.
After the SSO page comes up, and we enter the SSO ID and password, the HTTP 404 - File not found Issue comes up.

Resolution

Check if we have the jsp file in the $OA_HTML/US directory in the webtiers.
cd $OA_HTML/US
ls –ltr *jsp
should list _sso.jsp (eg biotest_sso.jsp)
If it doesn’t exist, copy it from one of the existing files to the above name, and edit the dbnames and the appropriate host names.
Make sure the sso username/password has not expired.
The _sso.jsp should have read privileges by applmgr (typically it should be owned by applmgr).

Issue APP-FND-01516




Resolution: This is because of incorrect dbc file. Go to the $FND_TOP/secure
vi the .dbc

The following is the sample contents of a dbc file

GUEST_USER_PWD=GUEST/ORACLE
APPL_SERVER_ID=13440068FFD70DE5E0440003BA0F95FE20458879981461781913317611235134
FND_JDBC_BUFFER_DECAY_INTERVAL=300
APPS_JDBC_DRIVER_TYPE=THIN
FND_JDBC_BUFFER_MIN=1
GWYUID=APPLSYSPUB/PUB
FND_JDBC_BUFFER_MAX=5
APPS_JDBC_URL=jdbc\:oracle\:thin\:@(DESCRIPTION\=(LOAD_BALANCE\=YES)(FAILOVER\=YES)(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=tcp)(HO
ST\=BIOERPORA2D.health.ge.com)(PORT\=1521)))(CONNECT_DATA\=(SID\=biodevc)))
FND_JDBC_STMT_CACHE_FREE_MEM=TRUE
FND_JDBC_STMT_CACHE_SIZE=200
TWO_TASK=biodevc
FND_MAX_JDBC_CONNECTIONS=500
FND_JDBC_USABLE_CHECK=false
FNDNAM=APPS
FND_JDBC_PLSQL_RESET=false
DB_PORT=1521
FND_JDBC_CONTEXT_CHECK=true
FND_JDBC_BUFFER_DECAY_SIZE=5
DB_HOST=bioerpora2d.health.ge.com

Make sure the fields above contain the correct entries.
Invariably, the issue occurs because of incorrect entry for the field APPL_SERVER_ID. Query the server_id from fnd_nodes for the corresponding node, and put the appropriate server id in this dbc file.

Once the .dbc has been edited with the correct values, copy this file to .dbc file.

Note: If there is no dbc file at all in $FND_TOP/secure, the dbc file can be copied from the autconfig repository [/orashr/applmgr/autoconfig_repository// ]