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

No comments:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...