How to change and which Apps database users passwords can be changed in a Multi-Node Apps Installation

In 11i oracle applications, the following list shows which database users should be changed and which should not be changed

APPLSYS -  Y
APPLSYSPUB -  N
APPS -  Y
CTXSYS -  Y
DBSNMP -  Y
PORTAL30 - Y
PORTAL30_SSO - Y
PRODUCT_SCHEMAS (AMB_XTR) - Y
SYS - Y
SYSTEM - Y

The following database users passwords may be changed

MDSYS
ORDPLUGINS
ORDSYS
PORTAL30_DEMO
PORTAL30_PUBLIC
PORTAL30_SSO_PS
PORTAL30_SSO_PUBLIC

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

Shutdown the Applications Tier services on each of the Nodes
Database Tier Services must be up and running

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 WELCOME123

To change an Oracle user password:

FNDCPASS apps/apps_schema_password 0 Y system/system_schema_password

ORACLE apps_database_user new_password
Ex: FNDCPASS apps/apps 0 Y system/manager ORACLE GL GL_123

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

Bring up the Application Tier services on each of the Nodes

Related Posts by Categories