HOME > > How to Manually Change the APPS, APPLSYS and APPLSYSPUB Password in Oracle Application

How to Manually Change the APPS, APPLSYS and APPLSYSPUB Password in Oracle Application

Anup - Wednesday, March 11, 2009
Step 1 Have all users log out of applications.

Step 2 Shutdown the concurrent managers.

Step 3 Log in to applications as System Administrator and Navigate to Security ----> Oracle-----> Register

Step 4 Query up all available Oracle Ids.

IMPORTANT : do not log out of this session of Applications until you have verified that all the following steps have been completed successfully.

Step 5 At the same time, login to SQL*PLUS with SYSTEM user.

Step 6 In the applications session, enter the new password for APPLSYS, APPS or APPLSYSPUB(Which you want to change) and Save the change.

IMPORTANT: At this point of the procedure you will see a "Caution" dialog box. The instructions contained in this dialog box are critical to successfully changing the APPLSYS & APPS passwords the dialog box does not indicate that you have made an error. Once you have read and understand the caution information you can simply click OK and proceed.

Step 7 In the SQL*Plus session, issue the following statements to change the passwords in the database.

sql>ALTER USER APPLSYS IDENTIFIED BY ;

sql>ALTER USER APPS IDENTIFIED BY ;

sql>ALTER USER APPLSYSPUB IDENTIFIED BY ;

Step 8 Log out of SQL*Plus.

Step 9 Open a NEW session in applications, WITHOUT CLOSING THE PREVIOUS SESSION, and log in.

IMPORTANT: If log in is successful, the change was successful. Otherwise, repeat onward, ensuring the same password is used for both APPLSYS and APPS, in both applications and SQL*Plus.

Step 10 Restart the concurrent managers.

Contact me

Get in Touch

Need to get touch with me? Please fill out the form with your enquiry.

Name
Anup Srivastav
Address
Lucknow - Utter Pradesh
Email
myindiandba@gmail.com
Message me