How to use FNDCPASS

To change an Oracle Applications schema password (other than APPS/APPLSYS):-

[oracle@sujeet scripts]$ FNDCPASS apps/WELCOME 0 Y system/manager ORACLE GL GL1

Log filename : L390641.log

Report filename : O390641.out

To change the APPS and APPLSYS schema password:-

1.) Stop all application services.
2.) Start only database and database listener.

 [oracle@sujeet scripts]$ FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME

Log filename : L390640.log

Report filename : O390640.out

 You have new mail in /var/spool/mail/oracle

 SQL> conn applsys/WELCOME

 Connected.

 SQL> conn apps/WELCOME

Connected.

Note:- Check the FNDCPASS logfile for any error. If the password has changed successfully then run 
autconfig in application tier. Otherwise do not run autconfig. 

To change an Oracle Applications user's password:-

USER:-vision,operations,sysadmin..

[oracle@sujeet scripts]$ FNDCPASS apps/WELCOME 0 Y system/manager USER VISION WELCOME

Log filename : L390642.log

Report filename : O390642.out

 [oracle@sujeet scripts]$ FNDCPASS apps/WELCOME 0 Y system/manager USER operations WELCOME

Log filename : L390643.log

Report filename : O390643.out

[oracle@sujeet scripts]$ FNDCPASS apps/WELCOME 0 Y system/manager USER sysadmin WELCOME

Log filename : L390644.log

Report filename : O390644.out

To change all ORACLE schema passwords:-

 [oracle@sujeet ~]$ cd /oracle/PROD/apps/apps_st/appl/

[oracle@sujeet appl]$ . APPSPROD_sujeet.env

 [oracle@sujeet appl]$ FNDCPASS apps/apps 0 Y system/manager ALLORACLE sujeet

Log filename : L390638.log

 Report filename : O390638.out

To change an Oracle Applications schema password (other than APPS/APPLSYS):-

[oracle@sujeet scripts]$ FNDCPASS apps/WELCOME 0 Y system/manager ORACLE GL GL1

Log filename : L390641.log

Report filename : O390641.out