Resetting sysadmin password in E-Business Suite 11i

This script will help you reset your 11i sysadmin password.

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'; 

This was first published in April 2004

Dig deeper on Oracle E-Business Suite

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close