Fandom

How To Wiki

Oracle Applications HOWTO: change apps password

1,797pages on
this wiki
Add New Page
Talk0 Share

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

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.