Wikia

How To Wiki

Oracle Applications HOWTO: change apps password

1,794pages on
this wiki
Talk0

Go to Michael Dvorkin's user page

Prerequisites Edit

E-Business Suite 11.5.9, 11.5.10


Steps to change apps password Edit

1. Backup entire system

2. Stop concurrent manager

  cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME
  adcmctl.sh stop apps/<apps password>

3. Backup FND_ORACLE_USERID table

  sqlplus apps/<apps password>
  drop table FND_ORACLE_USERID_BAK;
  create table FND_ORACLE_USERID_BAK as select * from FND_ORACLE_USERID; 
  exit;

4. Change apps password

  $FND_TOP/bin/FNDCPASS apps/<old apps password> 0 Y system/<system password> SYSTEM APPLSYS <new apps password>

5. Change apps password in configuration files

  $IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app
  $IAS_ORACLE_HOME/listener/cfg/wdbsvr.app
  $ORACLE_HOME/listener/cfg/wdbsvr.app
  $FND_TOP/resource/wfmail.cfg
  $OA_HTML/bin/appsweb.cfg
  $AD_TOP/admin/template/CGIcmd.dat

Known Issues Edit

1. Symptom : Can not login to Oracle Applications

  Cause   : Invalid apps password in $IAS_HOME/Apache/modplsql/cfg/wdbsvr.app
  Solution: Change apps password in $IAS_HOME/Apache/modplsql/cfg/wdbsvr.app

Go to Michael Dvorkin's user page

Around Wikia's network

Random Wiki