Skip to content

Changing Oracle Applications Users password

Oracle provides a utility called FNDCPASS that allows you to change passwords in batch mode.

It is highly advisable to back up the FND_ORACLE_USERID table and the FND_USER table before changing passwords for important users like apps

Format of FNDCPASS command:

 


Examples:

A) 

 

The above example would be used to change the applsys password. By specifying SYSTEM parameter, FNDCPASS expects the next argument in the command to be the applsys name and the password we want for the applsys user.

This command will also Re-encrypt all of the passwords in the FND_USER and FND_ORACLE_USERID table based on the new applsys password.

Remember that APPLSYS’s password and APPS’s password always have to be identical.

 

B)

Here parameter ORACLE with AP passes Oracle as a parameter, telling FNDCPASS that it is an Oracle user ID and password so it will update and re-encrypt the password in the FND_ORACLE_USERID table and run the alter user identified by script at the database level.

 

C) 

Here we are changing password of Normal EBS user password example SYSADMIN.

[Post Views: 2653]

Brijesh Gogia

I’m an experienced Oracle Applications DBA with more than a decade of full-time DBA experience. I have gained a wide knowledge of the Oracle software stack and have worked on several big projects for multi-national companies. I enjoy working with the leading-edge technology and have passion for database performance and stability. Thankfully my work allows me time for researching new technologies (and to write about them).
  
You can connect with me on LinkedIn.

Be First to Comment

Leave a Reply

Required fields are marked *