How to Change Applications R12 Passwords using Applications Schema Password Change Utility (FNDCPASS)

Oracle Applications provides a command line utility, FNDCPASS, to change/reset Oracle Applications schema passwords. This utility changes the password registered in Oracle Applications tables, changes the schema password in the database and can also change user passwords.
Note: You cannot change a schema name, such as APPLSYS or GL, after a product is installed, with FNDCPASS. Ensure that the entire Oracle Applications system has been shut down before changing any schema passwords. All users should log out and the Applications system should be down before running this utility.
If Oracle Applications user passwords are being changed then the relevant users should not be logged in.
Before changing any passwords, you should make a backup of the tables FND_USER and FND_ORACLE_USERID

A). To change the APPS and APPLSYS schema password:
Use the following command to change passwords for schemas 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.

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
Note: The SYSTEM token is used when changing the APPLSYS 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 0 Y ORACLE < username> < new_password>
Note: The ORACLE token is used when changing an Oracle Applications schema 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
Note: The ALLORACLE token is used when changing all ORACLE schema passwords.

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>
Note: The USER token is used when changing an Oracle Applications user 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
Using the FNDCPASS Utility:
Here is an example of changing an Oracle user's password, where is the Oracle schema name.
1. Use the FNDCPASS utility to change the password.
FNDCPASS < APPS username>/< APPS password> 0 Y \
< SYSTEM username>/< SYSTEM password> ORACLE < username> < new_password>
When changing the APPS or APPLSYS passwords, replace ORACLE with SYSTEM.
Note: Passwords for APPLSYS and the APPS schemas -- including the MRC schema -- must be the same. If you change the password for one, FNDCPASS automatically changes the others.


2. Update configuration files.
If you changed the APPS schema password (and APPLSYS) or the APPLSYSPUB password, update the following configuration files using AutoConfig (do not manually edit these files). They are used when connecting to Oracle Applications.
If you changed the APPS (and APPLSYS) password, update the password in this file:
• ORACLE_HOME/reports/server/CGIcmd.dat
If you changed the APPLSYSPUB password, update the password in these files:
• FND_TOP/resource/appsweb.cfg
• OA_HTML/bin/appsweb.cfg
• INST_TOP/admin/fnd/12.0.0/secure/< host_name>_< dbname>.dbc
Note: When changing APPS (or APPLSYS) and APPLSYSPUB passwords, do not restart the system until the entire password change process has been completed


3. Verify the new password.
If you changed the password for APPS (and APPLSYS), restart all concurrent managers, then log on to Oracle Applications to test the new password.

Related Posts by Categories