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.
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.
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:
Post a Comment