How to Change the Password of SYSMAN in EM Grid Control

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:

oracle.sysman.eml.mntr.emdRepPwd=<newpassword>
oracle.sysman.eml.mntr.emdRepPwdEncrypted=FALSE

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:

If you have multiple OMS’s in your environment, run this command on all of them.

Please share
  •  
  •  
  •  
  •  
  •  
  •  

AWS Big Data Specialist. Oracle Certified Professional (OCP) for EBS R12, Oracle 10g and 11g. Co-author of "Expert Oracle Enterprise Manager 12c" book published by Apress. Awarded as Oracle ACE (in 2011) and Oracle ACE Director (in 2016) for the continuous contributions to the Oracle users community. Founding member, and vice president of Turkish Oracle User Group (TROUG). Presented at various international conferences including Oracle Open World.

Leave Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.