Change the Password of SYSMAN
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:
cd <agent_home>/bin
emctl stop agent
cd <oms_home>/opmn/bin
opmnctl stopall
Then you enter the password into the emoms.properties by changing the following lines:
oracle.sysman.eml.mntr.emdRepPwd=<newpassword>
oracle.sysman.eml.mntr.emdRepPwdEncrypted=FALSE
Then you connect to the repository DB and change the SYSMAN password:
ALTER USER SYSMAN IDENTIFIED BY <newpassword>
After you changed the password on the repository DB, you start the agent and OMS instances:
cd <agent_home>/bin
emctl start agent
cd <oms_home>/opmn/bin
opmnctl startall
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:
cd <oms_home>/bin
emctl config oms -change_repos_pwd -change_in_db
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.
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:
cd <agent_home>/bin
emctl stop agent
cd <oms_home>/opmn/bin
opmnctl stopall
Then you enter the password into the emoms.properties by changing the following lines:
oracle.sysman.eml.mntr.emdRepPwd=<newpassword>
oracle.sysman.eml.mntr.emdRepPwdEncrypted=FALSE
Then you connect to the repository DB and change the SYSMAN password:
ALTER USER SYSMAN IDENTIFIED BY <newpassword>
After you changed the password on the repository DB, you start the agent and OMS instances:
cd <agent_home>/bin
emctl start agent
cd <oms_home>/opmn/bin
opmnctl startall
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:
cd <oms_home>/bin
emctl config oms -change_repos_pwd -change_in_db
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.