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.
