Resetting sysadmin password in E-Business Suite 11i

Ever changed the sysadmin password in E-Business Suite 11i and forgot it? Has a DBA left your company without documenting the password? Even worse, what if someone willfully changed the password for destructive purposes?

I once had a client restore a year-old backup on to a test serve, but no one in the organization remembered the password, the password documentation was destroyed and the DBA at that time had long since resigned.

To avoid this problem, I came up with an idea to change a user's password to something I would know, for instance "password of Oracle" or "welcome," via the application and copying the ENCRYPTED_FOUNDATION_PASSWORD for that user to the sysadmin password. Then I ran across the script below on MetaLink, which I think you will find useful.

update FND_USER         set
ENCRYPTED_FOUNDATION_PASSWORD ='
2DF3E509EB6A33F9607959C0976E25D997166FAB694ACDDAE466414791A44411',
ENCRYPTED_USER_PASSWORD='
D2FCA9810D86BCA9BE944D3E2E7A4A9E6CDF89AAD633179B701774083F907C13'
where user_name='SYSADMIN';