Labels

Search This Blog

Monday, April 30, 2012

Change Apps Password For Oracle EBS 11i and R12 with FNDCPASS

Oracle E-Business Suite provides a command line utility called FNDCPASS to change passwords.
4 mode is avaliable for FNDCPASS, details below
Note: To use this command line utility set application enviroment file (for example APPSORA.env)

  1. SYSTEM ==> To change the APPS and APPLSYS schema password
  2. ORACLE ==> To change single Application Schema password (other than APPS/APPLSYS) 
  3. ALLORACLE === To change all ORACLE schema passwords
  4. USER ==> To change Oracle Applications user password

1. Usage: FNDCPASS <logon> 0 Y <system/password> SYSTEM <username> <new_password>
    Example:  FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME
    Note:  Passwords for APPLSYS and the APPS schemas must be the same.
              If you change the password for one, FNDCPASS automatically changes the others.
             Change password for APPS and APPLSYS when concurrent manager is down.
    After changing APPLSYS and APPS password in 11i should change hardcoded password manually in wdbsvr.app file under $IAS_ORACLE_HOME/Apache/modplsql/cfg. Also recommend to run autoconfig
Also there are some files to modify listed below but for new versions of 11.5.x is not necessary

  • $FND_TOP/resource/wfmail.cfg
  • $COMMON_TOP/admin/scripts/<context_name>/adcmctl.sh
  • $AD_TOP/admin/template/CGIcmd.dat
  • $OA_HTML/bin/appsweb.cfg
2. Usage: FNDCPASS <logon> 0 Y <system/password> ORACLE <username> <new_password>

     Example: FNDCPASS apps/apps 0 Y system/manager ORACLE AP passwd1

3. Usage: FNDCPASS <logon> 0 Y <system/password> ALLORACLE <new_password>
    Example: FNDCPASS apps/apps 0 Y system/manager ALLORACLE WELCOME
    Note: Usernames must appear in the FND_USER or FND_ORACLE_USERID tables.
             FNDCPASS utility and ALLORACLE functionality was designed for applications users/schemas.
             Other users passwords must be manually changed(Examle: ABM,CSS,DBSNMP,EVM,SYS,etc.)

4. Usage: FNDCPASS <logon> 0 Y <system/password> USER <username> <new_password>
    Example : FNDCPASS apps/apps 0 Y system/manager USER SYSADMIN WELCOME


Oracle Support Document ID :  437260.1 , 1306938.1









1 comment:

  1. How to win at a casino - JT Hub
    The best 동해 출장마사지 part of a casino game is knowing what to expect to win in a casino 성남 출장마사지 game 보령 출장샵 before 천안 출장마사지 the game begins. Here's how 김포 출장샵 you can play the game

    ReplyDelete