A).To change the APPS and APPLSYS schema password:
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.
- 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.
B). To change an Oracle Applications schema password (other
than APPS/APPLSYS):
Use
this command to change the password of a schema provided by an individual
product in Oracle Applications.
FNDCPASS <logon> 0
Y <system/password> ORACLE <username> <new_password>
Use
the above command with the following arguments. When specifying the ORACLE
token, FNDCPASS expects the next arguments to be an ORACLE username and the new
password.
- logon The Oracle username/password.
- system/password The username and password for
the SYSTEM DBA account.
- username The Oracle username. For example, 'GL'.
- new_password The
new password.
For
example, the following command changes the GL user password to 'GL1'.
FNDCPASS apps/apps 0 Y
system/manager ORACLE GL GL1
C). To change all ORACLE schema passwords:
Use
this command to change the passwords of all schemas provided by Oracle
Applications products.
FNDCPASS <logon> 0
Y <system/password> ALLORACLE <new_password>
Use
the above command with the following arguments. When specifying the ALLORACLE
token, FNDCPASS expects the next argument to be the new password.
- logon The Oracle username/password.
- system/password The username and
password for the SYSTEM DBA account.
- new_password The new password.
For
example, the following command changes all ORACLE schema passwords to
"WELCOME":
FNDCPASS apps/apps 0 Y
system/manager ALLORACLE WELCOME
For additional information on the use of ALLORACLE, please reference NOTE 189367.1 - Best Practices for Securing the E-Business Suite
D). To change an Oracle Applications user's password:
Use
this command to change an individual Oracle Applications user's password.
FNDCPASS <logon> 0
Y <system/password> USER <username> <new_password>
Use
the above command with the following arguments. When specifying the USER token,
FNDCPASS expects the next arguments to be an Oracle Applications username and
the new password.
- logon The Oracle username/password.
- system/password The username and
password for the System DBA account.
- username The Oracle Applications username. For example, 'VISION'.
- new_password The
new password.
For
example, if you were changing the password for the user VISION to 'WELCOME',
you would use the following command:
FNDCPASS apps/apps 0 Y
system/manager USER VISION WELCOME
NOTE: Run autoconfig after you are done with changing the passwords.
Thanks,
Kaziul Islam Bulbul,
Dhaka Bangladesh
