This discussion is archived
4 Replies Latest reply: Jan 17, 2013 6:52 AM by TSharma-Oracle RSS

Changing sysman password

985089 Newbie
Currently Being Moderated
Hi , Can somebody please post the steps of changing the password of sysman user in Grid?
  • 1. Re: Changing sysman password
    TSharma-Oracle Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Sorry, we are using 10.2.0.5
  • 3. Re: Changing sysman password
    TSharma-Oracle Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points