You may want to change the password of SYSMAN user time to time because of security policies. OMS uses sysman account to login into the repository DB and if there is a mismatch in the password at the DB level and the configuration files, the OMS cannot start and function properly. So whenever you change the password of SYSMAN on the repository database of EM Grid Control, you need to update the configuration files.
Before 10.2.0.5, this was a manual process. You should stopp all the agent monitoring the Repository DB and the OMS instances that are associated with the repository:
Then you enter the password into the emoms.properties by changing the following lines:
Then you connect to the repository DB and change the SYSMAN password:
After you changed the password on the repository DB, you start the agent and OMS instances:
Last step is, to login to the Grid Control Console and find the failing agent and in the Monitoring Configuration page, update the value in the field “Repository password”.
If you are using 10.2.0.5+ (including 11.1) Enterprise Grid Control, all the above steps can be performed by executing a single command:
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
Enter Repository User's Current Password :
Enter Repository User's New Password :
Changing password in backend ...
Password changed in backend successfully.
Updating repository password in Credential Store...
Repository password in Credential Store updated successfully.
Bounce the OMS.
Successfully changed repository password.
If you have multiple OMS’s in your environment, run this command on all of them.