|
| Friday, April 3, 2009 |
| FNDCPASS utility |
Changing Application, Oracle, and the APPLSYS/APPS Passwords
An application user is a user that is defined in the E-Business Suite. For example, an AP Specialist using Oracle Financials is defined as an application user. An Oracle user is a database user only and is a schema owner of modules that are used in the application; for example, AP, GL, and BEN. At times it is necessary to change passwords for application users, Oracle users, or the APPS and APPLSYS passwords.
How to change the APPS and APPLSYS password by using the FNDCPASS utility?
FNDCPASS utility is used to change the password of EBS. This utility changes in three ways
1. System passwords which are APPS and APPLSYS.
2. Oracle database user passwords (INV, GL, AP, AR etc)
3. Application users passwords (SYSADMIN, etc)
PROCEDURE to run FNDCPASS
· On application tier logon as oracle user.
· set environment ($ . /$APPL_TOP/APPSORA.env)
· run FNDCPASS utility as following
$ FNDCPASS apps/apps 0 y system/manager SYSTEM APPLSYS welcome
In addition to executing the FNDCPASS command to change the APPS password, the autoconfig utility must be run or the APPS password must be manually changed in the following files:
• $ORACLE_HOME/listener/cfg/wdbsvr.app
• adcmctl.sh
• $OA_HTML/bin/appsweb.cfg
• $AD_TOP/admin/template/CGIcmd.dat (if in use)
Changing Application User Password using FNDCPASS utility
To change the user password like sysadmin we have to use USER mod with FNDCPASS command
$ FNDCPASS apps/apps 0 Y system/manager USER sysadmin welcome
Changing the Oracle User password using FNDCPASS utility
To change the oracle password like GL we have to use ORACLE mod with FNDCPASS command
$ FNDCPASS apps/apps 0 Y system/manager ORACLE GL gl123Labels: FNDCPASS utility |
posted by Srinivasan .R @ 4:41 AM  |
|
|
|
|
|
