Jump to Navigation

173 - Change password for Oracle EBS

The password of "APPS", "APPLSYS" & "APPLSYSPUB" schemas can be changed by using the FNDCPASS utility.

To show its syntax is :

# FNDCPASS
Usage: 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
........

 

To change the APPS and APPLSYS password :

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

NOTE : Changing the APPLSYS password automatically changes the APPS password to match as these two must always agree.

To change an Oracle user password :

# FNDCPASS apps/apps 0 Y system/manager ORACLE GL      GL

To change application userpassword :

# FNDCPASS apps/apps 0 Y system/manager USER   VISION  WELCOME
# FNDCPASS apps/apps 0 Y system/manager USER   USER01  WELCOME

 

 

Oracle:


Main menu 2

Story | by Dr. Radut