CHECKING THE GUEST USER PASSWORD IN ORACLE 

1. Check Value in DBC File

grep -i GUEST_USER_PWD $FND_SECURE/hostname_SID.dbc
GUEST_USER_PWD=GUEST/ORACLE

2. Check profile option value

sqlplus apps/passwd
SQL> select fnd_profile.value(’GUEST_USER_PWD’) from dual;
FND_PROFILE.VALUE(’GUEST_USER_PWD’)
——————————————————————————–
GUEST/ORACLE

The output of step 1 and step 2 must be same
In our case it is ORACLE

3. Guest user connectivity check

sqlplus apps/passwd
SQL> select FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE') from dual;
FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE')
——————————————————————————–-----
Y

The output should return Y 

RESET THE GUEST USER PASSWORD :

By mistake if somebody changed the GUEST password, the application will become not accessible.

To make sure the password is changed.

SQL> select fnd_web_sec.validate_login(‘GUEST’,'ORACLE’) from dual ;
FND_WEB_SEC.VALIDATE_LOGIN(‘GUEST’,'ORACLE’)
——————————————————————————–
N

Reset the password using FNDCPASS

1. Bring down the applications services.
2. Change the GUEST password using

FNDCPASS APPS/<Password> 0 Y SYSTEM/<Password> USER GUEST ORACLE

If FNDCPASS does not work. login using forms launcher….
http://<hostname>:<port>/dev60cgi/f60cgi
look for the profile… Sign-on Password Length to 12
Save the changes… Then run FNDCPASS again

Make sure now, the password is valid.

SQL>  select fnd_web_sec.validate_login(‘GUEST’,'ORACLE’) from dual ;
FND_WEB_SEC.VALIDATE_LOGIN(‘GUEST’,'ORACLE’)
——————————————————————————–
Y

Bounce the DB and Application Services….


Set back the profile option sign-on password length back to 8 from 12.