Pages

Wednesday, February 6, 2013

Change APPS y APPLSYS password

FNDCPASS apps/apps 0 Y system/manager ALLORACLE WELCOME
FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME

A). To change the APPS and APPLSYS schema password:
http://mtalmasri.blogspot.com.es/2012/01/changing-apps-password-using-fndcpass.html
Use the following command to change passwords for schema that are used by shared components of Oracle Applications.

FNDCPASS <logon> 0 Y <system/password> SYSTEM <username> <new_password>
FNDCPASS uses the following arguments when changing the APPLSYS password. When specifying the SYSTEM token, FNDCPASS expects the next arguments to be the APPLSYS username and the new password.
How to Change Applications Passwords using Applications Schema Password Change Utility (FNDCPASS or AFPASSWD) [ID 437260.1]


logon                           The Oracle username/password.
system/password     The username and password for the SYSTEM DBA account.
username                   The APPLSYS username. For example, 'applsys'.
new_password         The new password.
This command does the following:

Validates APPLSYS.
Re-registers password in Oracle Applications.
Changes the APPLSYS and all APPS passwords (for multi-APPS schema installations) to the same password.
Because everything with a Privilege Level [set to any of ('E', 'U', 'D')] in the FND_ORACLE_USERID table must always have the same password, FNDCPASS updates these passwords as well as APPLSYS's password.
For example, the APPS password will be updated when the APPLSYS password is changed.
ALTER USER is executed to change the ORACLE password for the above ORACLE users.
For instance, the following command changes the APPLSYS password to 'WELCOME'.

FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME