We need to change apps password manually, if you forgot and can’t check it in wdbsvr.app at $IAS_ORACLE_HOME/Apache/modplsql/cfg .
Please remember that the APPLSYS and APPS passwords alwayshave to be the same. Always change both at the same time. When changing thesepasswords, it is important to change the APPLSYS password first and the APPS later.
please back up the FND_ORACLE_ID and FND_USER tables before beginning.
1. Have all users log out of applications.
2. Shutdown the concurrent managers. (You can’t shutdown using adcmctl.sh if you don’t know apps password so use frontend)
3. Log in to applications as System Administrator.
4. Navigate to Security> Oracle> Register
5. Query up all available Oracle Ids.
(NOTE: do not log out of this session of Applications until you have verifiedthat all the following steps have been completed successfully).
6. At the same time, login to SQL*PLUS as the SYSTEM user.
7. In the applications session, enter the new password for APPLSYS. Re-enter (Same time do it in SQLPLUS ,after finishing Application part))the same password when asked to re-enter the password to confirm.
8. Save the change.
Note: At this point of the procedure you will see a “Caution” dialog box which states the following:
“You are changing the APPLSYS password. Doing so will affect the whole system”.
NOTE: The first character of the APPLSYS password MUST NOT BE a numeric.Use only alpha characters for the first character in the APPLSYS password.all APPS schema passwords to match the APPLSYS password.
9. In the same applications session, change the APPS password.
Note: Re-query the form (query - run) every time after changing the APPSpassword. If it is not re-queried and the APPS password is changed again, it isimpossible to continue.
10. In the SQL*Plus session, issue the following statements to change thepasswords in the database, where ‘XXX’ is the password assigned to thatuser in the previous steps:
sql>ALTER USER APPLSYS IDENTIFIED BY XXX;sql>ALTER USER APPS IDENTIFIED BY XXX;“Remember don’t log out from the application yet”
11. Open a NEW session in applications, WITHOUT CLOSING THE PREVIOUS SESSION,and log in.
If log in is successful, the change was successful. Otherwise, repeat steps 5onward, ensuring the same password is used for both APPLSYS and APPS, in bothapplications and SQL*Plus.
Followed the Metalink Doc Note:160337.1But no need to change the password for APPLSYSPUB and in metalink note they did not mention about autoconfig..
The most important thing … Please run autoconfig. so that change will effect the entire system.
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment