How to Change application passwords in R12
Changing passwords frequently helps ensure database
security, Oracle Applications provides a command line utility, FNDCPASS,
to change/reset Oracle Applications schema passwords. This utility changes
the password registered in Oracle Applications tables, changes the schema
password in the database and can also change user passwords.
Autoconfig needs to be run after changing 'APPLSYSPUB' or
'GUEST' user password
1.
Changing Apps password
Syntax:
1. FNDCPASS apps/apps 0 Y
system/manager SYSTEM APPLSYS WELCOME
2. FNDCPASS apps/apps 0 Y
system/manager ORACLE GL
GL1
3. FNDCPASS apps/apps 0 Y
system/manager USER VISION
WELCOME
4. FNDCPASS apps/apps
0 Y system/manager ALLORACLE
Note:
The SYSTEM token is used when changing the APPLSYS password.
The ORACLE token is used when changing a SINGLE Applications schema password.
The ALLORACLE token is used when
changing ALL Applications schema passwords.
The USER token is used when changing
an Applications USER password.
FNDCPASS apps/apps 0
Y system/manager SYSTEM
APPLSYS WELCOME
User: APPLSYS
PASSWORD : cloneapps
Once password changed run autoconfiq with new user password
2.Changing Frontend User Password
FNDCPASS apps/cloneapps 0 Y system/system123 USER sysadmin
sysadmin
User: sysadmin Password sysadmin
Once password changed after Run autoconfic in database and
application side
Note:
0 & Y are flags for FNDCPASS
0 is request id (request ID 0 is assigned to request ID's which are not submitted via Submit Concurrent Request Form)
'Y' indicates that this method is directly invoked from the command-line and not from the Submit Request Form.
0 is request id (request ID 0 is assigned to request ID's which are not submitted via Submit Concurrent Request Form)
'Y' indicates that this method is directly invoked from the command-line and not from the Submit Request Form.
I wish to show thanks to you just for bailing me out of this particular trouble. As a result of checking through the net and meeting techniques that were not productive, Same as your blog I found another one Oracle Cloud Applications .Actually I was looking for the same information on internet for Oracle Cloud Applications Consultant and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.
ReplyDelete