TEST
Powered by Blogger.
Responsive Ad
Responsive Ad

Author Profile

About Me

Start Sharing

Start Sharing

Drive Traffic on Social Platforms

Blog Archive

Blog Journey

Blog Journey

Learn how to start a perfect Blog

Work Smart, Not Hard - Let's See

Make your Blogging experience faster and easiest …
Work Smart, Not Hard - Let's See
Design by - Blogger Templates | Distributed by Free Blogger Templates

Made with Love by

Material UI Template is Designed Theme for Giving Enhanced look Various Features are available Whic…

Random Posts

Ads Section

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 - Tuesday, 10 March 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