Login Fails After Changing The 'GUEST' Password To Either Mixed / Lowercase

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Explanation:


1. Please run the following SQL to check the GUEST password:
select fnd_profile.value('GUEST_USER_PASSWORD') from dual;
select fnd_web_sec.validate_password('GUEST','<Your Password Here>') from dual;
select fnd_message.get from dual;

select
user_id,
user_name,
to_char(start_date, 'DD-MON-RRRR') start_date,
decode(end_date,NULL,'*** NULL ***',to_char(end_date, 'DD-MON-RRRR') ) end_date,
decode(encrypted_foundation_password, 'EXTERNAL', 'EXTERNAL', 'LOCAL_LOGIN')
encrypted_foundation_password,
decode(encrypted_user_password,'EXTERNAL', 'EXTERNAL', 'LOCAL_LOGIN') encrypted_user_password,
decode(user_guid,NULL, '*** NULL ***',user_guid) user_guid
from fnd_user
where user_name = 'GUEST'
order by user_name

2. Please check the dbc files ( $FND_SECURE/*.dbc)

3. Please check the XML context file from apps tier:
$APPL_TOP/admin/<Context>.xml




GUEST password should match on the locations on the past 3 points


Solution:


1. Shutdown application services.

2. Please run the following as apps from SQL Plus:

exec fnd_user_pkg.EnableUser(username=>'GUEST');
commit;

3.


cd $ORA_CONFIG_HOME/10.1.3/j2ee/oacore/config/
vi oc4j.properties
earch for LONG_RUNNING_JVM=true, replace for LONG_RUNNING_JVM=false.
Save the changes and bounce oacore container as follows:
cd $INST_TOP/admin/scripts
adoacorectl.sh stop
<wait some minutes>
adoacorectl.sh start


3. Please start the services, and check if the application is now accessible.


References:


Login Fails After Changing The 'GUEST' Password To Either Mixed / Lowercase In R12 (Doc ID 602425.1)
R12: One Stop Shop for all Login Issue after 'GUEST' Password Changes (Doc ID 744098.1)

Get Oracle Certifications for all Exams
Free Online Exams.com