Oracle provides a utility called FNDCPASS that allows you to change passwords in batch mode.
It is highly advisable to back up the FND_ORACLE_USERID table and the FND_USER table before changing passwords for important users like apps
Format of FNDCPASS command:
Usage: FNDCPASS logon 0 Y system/password mode username new_password
where logon is username/password[@connect]
system/password is password of the system account of that database
mode is SYSTEM/USER/ORACLE
username is the username where you want to change its password
new_password is the new password in unencrypted format
example FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME
FNDCPASS apps/apps 0 Y system/manager ORACLE GL GL1
FNDCPASS apps/apps 0 Y system/manager USER VISION WELCOME
FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS APPS4DBA
The above example would be used to change the applsys password. By specifying SYSTEM parameter, FNDCPASS expects the next argument in the command to be the applsys name and the password we want for the applsys user.
This command will also Re-encrypt all of the passwords in the FND_USER and FND_ORACLE_USERID table based on the new applsys password.
Remember that APPLSYS’s password and APPS’s password always have to be identical.
FNDCPASSapps/apps 0 Y system/manager ORACLE AP AP4DBA
Here parameter ORACLE with AP passes Oracle as a parameter, telling FNDCPASS that it is an Oracle user ID and password so it will update and re-encrypt the password in the FND_ORACLE_USERID table and run the alter user identified by script at the database level.
FNDCPASS apps/apps 0 Y system/manager USER SYSADMIN ADMIN4DBA
Here we are changing password of Normal EBS user password example SYSADMIN.
[Post Views: 2653]
You can connect with me on LinkedIn.
Latest posts by Brijesh Gogia (see all)
- Performance Tuning Basics 16 : Using SQL Tuning Health-Check Script (SQLHC) - April 1, 2018
- Physical and Logical Block Corruption in Oracle Database - March 10, 2018
- Performance Tuning Basics 15 : AWR Report Analysis - February 6, 2018