Fandom

How To Wiki

Oracle Applications HOWTO: change apps password

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

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.

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

Also on Fandom

Random Wiki