This is a premium alert message you can set from Layout! Get Now!

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

Anup
0
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.

Post a Comment

0 Comments

Please Select Embedded Mode To show the Comment System.*

Post a Comment
To Top