Oracle Applications Schema Password Change Utility – (FNDCPASS)

3 Comments

Changing passwords periodically helps ensure database security. Oracle Applications provides a command line utility, FNDCPASS, to set Oracle Applications schema passwords. In addition to changing the schema password in the database, this utility changes the password registered in Oracle Applications tables (FND Tables). This utility can also change Applications End User passwords.

FNDCPASS changes

  • Oracle Applications Database System Users (APPS, APPLSYS)
  • Oracle Applications Product Schema Passwords (GL, AR, AP, etc,)
  • Oracle Applications End User Account Passwords (SYSADMIN, OPERATIONS etc)

Note: the utility, FNDCPASS, cannot be used for changing the database SYSTEM and SYS users. Only users that are registered in FND meta data tables need to be changed using FNDCPASS. Normally, the APPS database user password and APPLSYS password need to be the same. When changing the APPLSYS password using FNDCPASS, the APPS password is also changed.

Syntax of FNDCPASS command:

FNDCPASS logon 0 Y system/password mode username new_password

Where logon is username/password[@connect]
System/password is password of the system account of that database
Mode is SYSTEM/USER/ORACLE
Username is the username where you want to change its password
new_password is the new password in unencrypted format

Example:

$ FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME

$ FNDCPASS apps/apps 0 Y system/manager ORACLE GL GL1

$ FNDCPASS apps/apps 0 Y system/manager USER VISION WELCOME

Note: The FNDCPASS has a new mode, “ALLORACLE”, in which all Oracle Application schema passwords can be changed in one call. Apply the patch (Patch No# 4745998) to have this option, if not available currently with your Apps.

Syntax:

FNDCPASS 0 Y ALLORACLE

Example:

$ FNDCPASS apps/apps 0 Y system/manager ALLORACLE WELCOME

To change APPS/APPLSYS password, we need to give mode as SYSTEM
To change product schema passwords, i.e., GL, AP, AR, etc., we need to give mode as ORACLE
To change end user passwords, i.e., SYSADMIN, OPERATIONS etc., we need give mode as USER

Note: Till 11.5.9 there is bug in FNDCPASS, which allows FNDCPASS to change APPS&APPLSYS passwords. Doing so will corrupt the data in FND meta data tables and cause to the application unusable. Because of that it is recommend taking backup of the tables FND_USER and FND_ORACLE_USERID before changing the passwords.

After changing the APPS/APPLSYS or APPLSYSPUB user, following extra manual steps needs to be done.

If you changed the APPS (and APPLSYS) password, update the password in these files:

  • iAS_TOP/Apache/modplsql/cfg/wdbsvr.app
  • ORACLE_HOME/reports60/server/CGIcmd.dat

If you changed the APPLSYSPUB password, update the password in these files:

  • FND_TOP/resource/appsweb.cfg
  • OA_HTML/bin/appsweb.cfg
  • FND_TOP/secure/HOSTNAME_DBNAME.dbc

Note: I would you suggest you to first try changing the passwords using FNDCPASS on your test Apps Instances, once you are done with this without any errors or issues then you can move this to production, and also request you to search in metalink for more information about FNDCPASS utility and it’s usage.

Note: With FNDCPASS you cannot decrypt the password, but can change the password only!

Following Google Searches Lead To This Post: Following utility is used to change the password of Apps user
change user password oracle 11
lost oracle password
11.5.9 fndcpass sysadmin
Oracle Financials Password change script
In Release 12 the base product schemas are locked except during patching
oracle applications Cannot complete applications logon
out of box username password from oracle apps sysadmin
how to use FNDCpass utility to change password
oracle applications recently used password
fndcpass apps wdbsvr.app
oracle applsys tables check changes
utility for for changing password of apps user in oracle apps 11i
fndcpass
how to check username password of apps schema in 10g oracle
oracle 11i change schema password
password policy Oracle applications 11i
how to reset the same password for oracle R12 sysadmin password
resetting oracle apps password using SQL
oracle password manager utility
how to change applsyspub password in oracle apps 11i
how to find sysadmin password in oracle
FNDCPASS to change applications login
Oracle CHNG PWD
SH schema password
How to chage script of fndcpass in apps
oracle schema password rule
change apps password in oracle apps
FNDCPASS to change apps password R12
oracle applications SYSADMIN not able to login
how to check when the password was reset for schema user in oracle
Oracle Apps+The page cannot be displayed
FNDCPASS was not able to decrypt password for
check if the password has been changed in the last 24 hours intext:oracle
appschangepassword oracle
fndcpass r12
sys password oracle application vision instance
what is password for sys in the vision instance
Do we need to change all users passwords using FNDCPASS
system password change using fndcpass syntax in R12
FNDCPASS apps/apps 0 Y system/manager ORACLE system system 1
how to change system/manager password using FNDCPASS
fndcpass command
FIND oracle apps password
how to change schema password in oracle
application schema
change passw FNDCPASS syntax
vision batabase login user and password
CHECK FOR LAST TIME ORACLE PASSWORD CHANGED
changing default passwords oracle applications
oracle change passwd
oracle apps schema
oracle applications schema
DECRYPT FND_ORACLE_USERID
HOW TO DECRYPT THE PASSWORD OF SCHEMA
default apps password VISION R12
how to change password in unix for oracle user
forget oracle password
Oracle Password Utility
fndcpass to change for all users
file has applsyspub password
oracle apps applsyspub password
oracle apps not logon only sysadmin logon
impact of changing oracle password on linux
Oracle apps password reset using sql
FNDCPASS was not able to decrypt password for APPLSYSPUB during applsys password
securing oracle passwords bash scripts
FNDCPASS was not able to decrypt password for APPLSYSPUB during applsys password change.
account is locked equity edge
how to change sysadmin password in oracle apps
vision database system password
default application users in oracle Apps vision operations
How To Use FNDCPASS to Change The Oracle Users, APPS, APPLSYS
hOW TO CREATE BASH FILE TO CHANGE PASSWORD USING FNDCPASS
how to check the applsyspub password changed
default R12 database system password
oracle r12 default sys account
change apps users utility
cannot complete applications logon
fnd_user can not change password
FNDCPASS apps/apps 0 Y system/manager USER
how to change apps password in r12
FNDCPASS for sysadmin password in 11i
FNDCPASS was not able to decrypt password for APPLSYSPUB during applsys password change
FNDCPASS SYSADMIN
How to findout URL info for Oracle Applications 11i
oracle application manager user password
apps password changed from backend
r12 sys password
oracle schema last connect
changing the apps password on oracle apps release 12
default user name and password for schema
FNDCPASS was not able to decrypt password for user ‘SYSADMIN’ during applsys
passward+fnd_user table
which user i have to login to change the sysadmin password
how to change the color of application R12
how to reset sysadmin password using FNDCPASS on R12
11i sysadmin password
FNDCPASS was not able to decrypt password for APPLSYSPUB
default passwords on oracle financials
oracle 10g “forget password”
Use FNDCPASS to change oracle application user password
apps applsys password database application oracle 10
default password dba in vision instance
user can not login oracle application
how to find password for oracle in linux
change application cover color in oracle apps
how to change oracle apps themes color
fndcpass 11i
how to change system/manager password in oracle apps
find password for oracle apps schema
How to reset the Admin password from backend in apps
oracle apps fndcpass reset user password
oracle fndcpass
check last password change oracle
ALLORACLE WITH FNDCPASS
fndcpass to change apps and sysadmin passwd
What is APPLSYSPUB
fndcpass all oracle
AOL schema
chage oracle 11i schema passords
how to change oracle system account passwords
find schema password in oracle
change applsyspub password
how to check when the password was changed in oracle for system
oracle 11i FNDCPASS end user
oracle 11i FNDCPASS sysadmin end user
oracle “FNDCPASS sysadmin”
changing oracle schema password
R12 fndcpass
forget password schema
FNDCPASS-CANNOT DECRYPT (USER=APPLSYSPUB)
fndcpass in r12
change FND password
command to reset the apps user password + fnd_user
oracle find out who changed the password
oracle find out password changed
fndcpass change apps password
command to reset the application user account password + fnd_user
how to change password for schema in oracle applications
reset oracle application password using 11i
FNDCPASS For Applications 11.0 in Unix
how to make sysadmin password valid in oracle
oracle change password FNDCPASS
find last change of password in oracle apps
Shell scripting for chaging password for all schema?
change APPS password in oracle apps R12
oracle change password applsyspub
oracle vision sample schema
R12 change APPS password using FNDCPASS
default password of sysadmin in oracle
r12 apps password
sysadmin password change +R12
can we lock the user accounts using FNDCPASS
how to change default page after oracle apps login
connect to oracle sh schema
appsweb.cfg change apps
oracle change schema password
default vision system password
reset sql password from oracle applications
oracle change password command
how to reset oracle application passwords
oracle applications 11i password decryption
FNDCPASS Oracle R12
oracle financials schema
oracle apps password fnd_user
change sys password 11i
how to SET PASSWORD FOR A SCHEMA
11i how to find sysadmin password
after changing the apps password in R12 where we need change in file system
how to reset oracle schema password
12i username password
passwrod change SYS SYSTEM table sysadm
ORACLE system password change vs SYSADM
ORACLE SYS system password VS SYSADM
changing sys password in oracle apps
oracle sysadmin locked
Oracle Application11I:page can not be displayed
oracle change password
FNDCPASS alloracle
change sysadmin password in 11i
default APPS password VISON E-Business
lost apps oracle application password
how to change sysadmin password 12i
reset ‘SYSTEM’ ORACLE schema:
schema for AOL in oracle apps
change oracle application management sysadmin password
password reset script oracle
Oracle Vision instance sql
change admin pwd in Oracle apps
R12 apps account locked after password change
reset password oracle applications
APPLSYS schema name in oracle application r12
list of users can be changed via fndcpass in 11i
FNDCPASS utility
“FNDCPASS-CANNOT DECRYPT”
applsys schema name
forgot apps password +R12
oracle last password change 10g
FNDCPASS was not able to decrypt password
reset oracle apps password does not prompt user for change password
change password oracle schema
Vision instance APPS password
Vision instance default usernames
Vision Instance default apps password
script to change password of a user in oracle apps
change user fndcpass
oracle apps windows “sys password”
fndcpass change sysadmin
change oracle APPS password
oracle applications password vision sysadmin
oracle last time password changed
oracle r12 change the sysadmin password
oracle r12 fndcpass
how to change all product schemas passwords in oracle 11i
FNDCPASS+password was not changed
oracle apps default sysadmin password vision
cannot remember oracle sysadmin password
Oracle function check for password change
fndcpass log file location
unable to change user passwords with FNDCPASS in oracle apps 11i
FNDCPASS was not able to decrypt password for user ‘APPS’ during applsys password change
fndcpass to change fnd user password
fndcpass in oracle apps
when sysadmin password last changed apps
changing apps password for vision instance database
forgot apps password r12 fndcpass
oracle application apps locked
fndcpass apps password
fndcpass apps
oracle decrypting sys.user$
oracle apps reset the password
fndcpass change apps
oracle financials last password change
policy not to set recently used password to sysadmin in oracle
fndcpass changind all schema passwords
fndcpass changing all schema passwords
how can change sysadmin password in oracle application R12
reset oracle 10g sys password
Steps to change apps password in R12
Oracle 11i change user password
why we need change the apps password from fndcpass
last password change oracle
Changing the security mode oracle 11i
sql script change apps password R12i
oracle apps R12 apps account getting locked often
fndcpass reset password
“vision instance database”
change APPS passwrod
Oracle application user password reset
oracle 11 changing schema names
apps password change in r12
reset oracle apps password
fndcpass utility change apps password
oracle schema user password forgot
find user name and password for oracle schema
FNDCPASS in R12 + change sysadmin password
“FNDCPASS was not able to decrypt password for user ‘APPLSYS’ during applsys”
changing UNIX oracle password
oracle apps r12 sysadmin default password
reset passwrod oracle
last time change password oracle
oracle financials sysadmin
how to find out oracle users password
oracle password applsys
default user password vision base oracle applications
change user color in oracle 11i\
11.5.9 fndcpass
Oracle SH schema
applsys users in oracle 12
how to change applsyspub password without using FNDCPASS 11i
unable to change the sysadmin password using FNDCPASS
what schema for fnd_user
FNDCPASS apps/apps 0 Y
log file of apps password change in oracle apps
Schema for AOL
what is sysadmin password in apps
how to change a password for a oracle schema
how to change password for schema in oracle
R12 FNDCPASS apps
fndcpass + all
how to connect to oracle 11i sys user
change password oracle apps sys, system, apps
oracle 11i default passwords
fndcpass schema password
FNDCPASS was not able to decrypt password for user ‘APPS’ during applsys
sysadm password change in r12 apps
How to reset the password for a schema in Oracle 10g
obtaining schema passwords from unix
oracle change password bulk
oracle set password for all users
oracle password changer
default system passwords for apps
oracle apps reset password fndcpass
resetting sysadmin in R12
Users function not available to this responsibility oracle apps
oracle sysadmin default password 12i VISION
all oracle application utilities
oracle applsys password
how to change GL password
how to decrypt schema passwords from a dba user
fndcpass+wdbsvr.app
How to change oracle server forgot username/password
application to change database password in oracle
fndcpass all users
getting reset password when trying to Login to oracle finacial application
r12 applsyspub account locked
fndcpass to change apps password
Oracle Apps Sysadmin default password
how to change hostname of oracle apps 11i
oracle apps R12 : default login url
not able to login as sysadmin user in oracle apps
what are the changes to be done when hostname is changed in oracle applications on windows
“function not available to this responsibility”
change sysadmin password in oracle applications
change sysadmin password in R12 oracle applications
utility to change PW in oracle
oracle password ars
fndcpass SECURITY-UNABLE TO CONNECT TO SYSTEM
FNDCPASS apps/apps 0 Y system/manager ORACLE all oracle
change apps password fndcpass
Tags: 

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>