11 Replies Latest reply: Mar 22, 2006 11:38 AM by 439126 RSS

    How to change the password of SYSMAN user ?

    464332
      I have change the password of SYSMAN with this order :
      alter user sysman identified by *****;
      Then I restart OEM : emctl start dbconsole,
      SYSMAN is locked and so OEM does not work any more.
      I think that there is a simple method for it

      Configuration :
      Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
      on Windows Server 2003 Standard Edition

      Thank you for your help

      Message was edited by:
      Pascal Mottay
        • 1. Re: How to change the password of SYSMAN user ?
          mnazim-Oracle
          stop the dnconsole and issue the following command
          alter user sysman identified by ********** account unlock
          start the dbconsole and try to connect with dbconsole and let me know the result.
          • 2. Re: How to change the password of SYSMAN user ?
            464332
            I've try this and when I restart OEM, the SYSMAN user become Locked.
            I think OEM try to connect with the old password and so locked the user.
            • 3. Re: How to change the password of SYSMAN user ?
              mnazim-Oracle
              unlock the account alter user sysman account unlock and repeat the steps as mentioned above and let me know the result.
              • 4. Re: How to change the password of SYSMAN user ?
                464332
                thank you but this is not the right method.
                In 9i version there is a script for change the sysman password.
                For the 10g I look for the solution...
                • 5. Re: How to change the password of SYSMAN user ?
                  439126
                  Read the 10g grid documentation (according to your release), there is a procedure in there for changing the sysman password, I suggest you follow that.

                  Bazza
                  • 6. Re: How to change the password of SYSMAN user ?
                    rodneyli
                    To change the Sysman password:
                    1. Stop the OMS instances that are associated with the repository
                    a. opmnctl stopall

                    2. Change the sysman password in the database:
                    a. Logon to sqlplus as a dba user
                    b. Issue the command: alter user sysman identified by newpassword;
                    c. Exit Sqlplus

                    3. On each management server host, cd to the OMS $ORACLE_HOME/sysman/config directory
                    a. backup the emoms.properties file
                    b. edit the emoms.properties file and modify the parameters;
                    eml.mntr.emdRepPwd=new_password
                    oracle.sysman.eml.mntr.emdRepPwdEncrypted=FALSE

                    NOTE: When you restart the OMS, the FALSE setting will change to TRUE and the password will become encrypted in the file

                    4. Still on Management Repository host, cd to the AGENT_HOME/bin and stop the agent:
                    ./emctl stop agent
                    5. Next, cd to the AGENT_HOME/sysman/emd directory
                    a. Edit the targets.xml file and modify the oracle_emrep target definition with the following in bold:
                    <Target TYPE="oracle_emrep" NAME="Management Services and Repository" VERSION="1.0">
                    <Property NAME="MachineName" VALUE="host.us.oracle.com"/>
                    <Property NAME="Port" VALUE="1521"/>
                    <Property NAME="SID" VALUE="sid"/>
                    <Property NAME="UserName" VALUE="552f2080d6d8c3c6" ENCRYPTED="TRUE"/>
                    <Property NAME="password" "newpassword" ENCRYPTED"FALSE"/>
                    ..
                    ..
                    b. Save the file. The TRUE value will change to FALSE and the newpassword will become encrypted when you restart the Agent.

                    6. Issue the command (from the Agent O_H/bin):
                    ./emctl start agent

                    7. Restart each of the OMS's
                    emctl start oms

                    8.Start the OMS instances that are associated with the repository
                    opmnctl startall
                    • 7. Re: How to change the password of SYSMAN user ?
                      439126
                      Give a man a fish rodney, and he will eat for a day.

                      Teach them how and WHERE to fish, and they will eat for the rest of their days...
                      • 8. Re: How to change the password of SYSMAN user ?
                        439126
                        Ugonic, you raise a fair point, perhaps I was a litle terse!!

                        The original question is however easily found in the documentation. If If someone had an issue finding the particular section, then yes, I'd post a link. But the poster never made clear their version clear originally (the original post has been edited since) so posting a set of instructions for the wrong version or a link to the worng version, could have been potentially harmful.

                        I'd stick to my guns, someone administering a sysman password (probably a dba) should know where to find the documentation. If they do not, it begs the question why they're being let loose with a sysman account.

                        So yes Ugonic, most of the time I'd agree, but it depends on the question being asked. I've tried to help people on this forum, some of the grid docs are a little thin in places but people must also be willing to help themselves.

                        Bazzza
                        • 9. Re: How to change the password of SYSMAN user ?
                          464332
                          For the db10g standalone EM, there is no file emoms.properties in the the oracle_home\sysman\config directory
                          This file is in the oracle_home\hostname_sid\sysman\config directory

                          thank you rodnely for your help
                          • 10. Re: How to change the password of SYSMAN user ?
                            rodneyli
                            Thanks for the clarification Pascal.
                            A plus,
                            Rodney
                            • 11. Re: How to change the password of SYSMAN user ?
                              439126
                              This just highlights the issue of posting adhoc instructions when the original poster has submitted incomplete information. No harm done in this case, but if the documentation was followed, there'd be no issue at all.

                              I'll get off my soap box...


                              Bazza