Wednesday, August 22, 2007

How To Change the Apps Password

The passwords of APPS and APPLSYS must be identical.
So you just need to change APPLSYS password not APPS , by changing APPLSYS
password , APPS password assumes the same value

(i)
Shutdown the Applications Tier services on each of the Nodes
Database Tier Services must be up and running
Any node where APPL_TOP , 8.0.6 and iAS ORACLE_HOME are present is part
of the Application tier
Any node where RDBMS ORACLE_HOME is present is part of the Database tier

(ii)
Then . issue the commands at the Unix command line similar to the following on any Node
of Oracle Applications where the executable FNDCPASS is present in $FND_TOP/bin

To change the APPLSYS password:
FNDCPASS apps/apps_schema_password 0 Y system/system_schema_password SYSTEM APPLSYS new_password
Ex: FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS CITRIX123

To change an Oracle user password:
FNDCPASS apps/apps_schema_password 0 Y system/system_schema_password
ORACLE apps_database_user new_password

Example

FNDCPASS apps/apps 0 Y system/manager ORACLE GL GL_TEST

(iii)
Run Autoconfig on each of the Nodes wherever Application Tier is installed

(iv)

Bring up the Application Tier services on each of the Nodes

2 comments:

electronic signature in word said...

As you mentioned that you just need to change APPLSYS password not APPS , by changing APPLSYS
password , APPS password assumes the same value.By this do you mean that if APPLSYS password is changed then APPS automatically assume the new password

Unknown said...

Yes APPLSYS password and apps password is same.