How to change the password for apps username in Oracle 11i

1. Just make sure that your Concurrent Manager is down. There should'nt be any running FNDLIBR process.

2. FNDCPASS apps/apps_old_pwd 0 Y system/system_pwd SYSTEM APPLSYS apps_new_pwd

3. Try new SQLPLUS connection with new apps password.

sqlplus apps/apps_new_pwd

4. Change apps password in the following file.

vi $IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app

5. Start the concurrent manager.

Note: Dont ever change oracle applications apps password through SQLPLUS. Always use the above procedure to change apps password.