HOW TO RESET SYSADMIN PASSWORD

How to Reset only the SYSADMIN Password

PROBLEM DESCRIPTION 
------------------- 
You have forgotten the SYSADMIN applications password and cannot login.
 You know the apps and applsys passwords but does not want to follow the steps to 
reset all passwords since resetting applsys would require re-registering all applications user passwords. 

How can you reset only the SYSADMIN password? 

SOLUTION DESCRIPTION 
-------------------- 
The applsys password provides the basis for all user passwords 
so resetting applsys will require re-registering all user passwords. 
If there are any other users with System Administrator privileges, then they can reset 
the SYSADMIN user's password from within applications. 
Otherwise SYSADMIN can be reset without affecting other users as follows: 
1. Log in to SQL*Plus as applsys 
2. Backup FND_USER and FND_ORACLE_USERID tables using 
create table FND_USER_BAK as select * from FND_USER; 
create table FND_ORACLE_USERID_BAK as select * from FND_ORACLE_USERID; 
3. update FND_USER 
set ENCRYPTED_FOUNDATION_PASSWORD 
='2DF3E509EB6A33F9607959C0976E25D997166FAB694ACDDAE466414791A44411', 
ENCRYPTED_USER_PASSWORD
='D2FCA9810D86BCA9BE944D3E2E7A4A9E6CDF89AAD633179B701774083F907C13' 
where user_name='SYSADMIN'; 
sql>commit; 

The SYSADMIN password is now set to WELCOME.