Oracle Technologies Blog

By ASKM

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’;
Advertisements

One Response to “R12 – Changing APPS password”

  1. […] Changing APPS password […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: