Friday, January 29, 2010

Changing APPS Schema Password

Hi All,

Yesterday i changed my Production box APPS (Default Password).

I want to share the step which i used for changing APPS Schema password.

1. Shutdown Application Servcies
$INST_TOP/admin/scripts/adstpall.sh

2. using FNDCPASS utility change the APPS schema password
login to APPLMGR user.
eg:
FNDCPASS [logon] 0 Y [system/password] SYSTEM [username] [new_password]

$FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS NEWPASS

NOTE: here i am changing the APPS Schema Default Password (Default password of apps schema is "apps" & default password of SYSTEM (ORACLE USER) is "manager")

Whenever we change the APPS schema password then APPLSYS password will also change by system. APPS or APPLSYS are same user.

3. run "adautocfg.sh" on dbTier as well as appsTier with NEW PASSWORD
3.1 logon on dbTier
$ORACLE_HOME/appsutil/admin/[SID_HOSTNAME]/adautocfg.sh apps/newpass

3.2 logon on appsTier
$INST_TOP/admin/scripts/adautocfg.sh apps/newpass

4. start APPLICATION services and login to application with new password.

5. In case of any doubt or query feel free to ask or mail @ star_taj @ yahoo. com

1 comment:

eSeal said...

Hi Mohammed

Thanks for the post.

Oracle Applications