4 Replies Latest reply: Jan 17, 2013 8:52 AM by TSharma-Oracle RSS

    Changing sysman password

    985089
      Hi , Can somebody please post the steps of changing the password of sysman user in Grid?
        • 1. Re: Changing sysman password
          TSharma-Oracle
          Which version of Grid you are using? Method is different for different versions.

          Also, please follow the doc to post the posts on this forum.
          • 2. Re: Changing sysman password
            985089
            Sorry, we are using 10.2.0.5
            • 3. Re: Changing sysman password
              TSharma-Oracle
              Steps for Changing the SYSMAN Password in 10.2.0.5 and 11.1 Grid Control

              When using 10.2.0.5 or 11.1 OMS, 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
              Example of output for OMS 10.2.0.5 running on Windows:



              C:\app\oracle\oms10g>emctl config oms -change_repos_pwd -change_in_db
              Oracle Enterprise Manager 10g Release 5 Grid Control
              Copyright (c) 1996, 2009 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.
              Changing monitoring credentials ...
              Monitoring credentials changed successfully.
              Updating emoms.properties....
              emoms.properties updated successfully....
              Please bounce OMS.
              Successfully changed repository password.
              If you have multiple OMS's in your environment, please run this cmd on all of them

              Note:

              1. The above command

              - will prompt you for the current password and the new password.
              - will modify the sysman password in the repository database, in the emoms.properties configuration file / WLS Credential store and the monitoring credentials for the 'OMS and Repository' target.
              - will ask you to bounce the OMS once the command is completed successfully
              - for 11G, the command will modify the password for sysman and sysman_mds users in the repository database, modify the password in the credential store and change the monitoring credentials for the 'OMS and Repository' target.

              2. The '-change_in_db' parameter is optional and is used to change the SYSMAN password in the repository database.

              - If the sysman password is manually modified in the repository database, this option does not need not be specified.
              - When this parameter is specified, the command will prompt for the current sysman password.
              - If the current sysman password is lost / unknown then:



              a.Log in to your Repository database as SYS and run:


              SQL> ALTER USER SYSMAN IDENTIFIED BY <newpassword>;
              SQL> ALTER USER SYSMAN_MDS IDENTIFIED BY <newpassword>;
              Where <newpassword> is the new password you want for SYSMAN and SYSMAN_MDS.


              The password MUST BE THE SAME for SYMAN and SYMAN_MDS.

              b.From a command prompt run:

              $ cd $OMS_HOME/bin
              $ ./emctl config oms -change_repos_pwd
              Provide <newpassword> when prompted.


              3. If using multiple OMS, then execute the above command on one of the OMS.
              On the Additional OMS, execute:



              $ <OMS_HOME>/bin
              $ ./emctl config oms -change_repos_pwd
              • 4. Re: Changing sysman password
                EdStevens
                982086 wrote:
                Sorry, we are using 10.2.0.5
                there is a doc on MOS that details how to change the password for SYSMAN and DBSNMP. I don't have the reference handy, but it shouldn't be too hard to locate with the search facility on MOS - that's how I found it in the first place.

                Briefly, what is required is not only the normal ALTER USER command, but also going into an xml config file where the encrypted pswd is stored, changing it to the new unecrypted password as well as another flag to indicated that the indicated password is not encrypted, then restarting dbconsole. The process of restarting reads the config file, sees that the password is not encrypted, calculates an encrypted value and updates the config file replacing the unencrypted form with the encrypted form.