Oracle Technologies Blog


Posts Tagged ‘APPS password’

R12 – Changing APPS password

Posted by Srikrishna Murthy Annam on September 24, 2009

Changing APPS password

There are some situations where you may need to change the apps password. Some times you may or may not know the apps password. And some times the password may be reset if it is corrupted.

Action Steps ( when you know the old apps password )
1) Shutdown all the MT services
2) Change apps password using FNDCPASS
FNDCPASS apps/[oldpasswd] 0 Y system/pwd SYSTEM APPLSYS <new_pwd>
3) Run autoconfig
4) Startup all the MT services

Action Steps ( when you forgot/dont know the apps password)
Follow metalink Note 160337.1 to change the apps password and then run autoconfig.

Encrypted Passwords details :

SQL> select oracle_username,encrypted_oracle_password from fnd_oracle_userid where oracle_username IN (‘APPS’, ‘APPLSYS’,’APPLSYSPUB’);
SQL> select encrypted_foundation_password, encrypted_user_password from fnd_user where user_name = ‘SYSADMIN’;

Posted in Oracle Apps R12 | Tagged: , , | 1 Comment »