Search This Blog

Sunday, July 22, 2007

How to Change SYSMAN User Password

My Signature Article
Tips:
Oracle Certification - Tips

DBA Preparation - Tips

Practical DBA - Tips


Carefully when change SYSMAN password
through below procedure we can change SYSMAN user password

1.connect to database server with SYSMAN user


SQL> conn sysman/sysman1@oem
Connected.
SQL> password
Changing password for SYSMAN
Old password:
New password:
Retype new password:
Password changed\



2. stop DBCONSOLE services

C:\>emctl stop dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.1.0.5.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://Localhost:5501/em/console/aboutApplication
The OracleDBConsoleoem service is stopping............
The OracleDBConsoleoem service was stopped successfully.


3. edit emoms.properties , targets.xml files
Located : emoms.properties ===$ORACLE_HOME/localhost.domainname_sid/sysman/config/
Located : targets.xml ========$ORACLE_HOME/localhost.domainname_sid/sysman/emd/


emoms.properties

oracle.sysman.eml.mntr.emdRepPwd="c7021fd3720a0f18" replace with PASSWORD
oracle.sysman.eml.mntr.emdRepPwdEncrypted="TRUE" replace with FALSE

oracle.sysman.eml.mntr.emdRepPwd=ORACLE
oracle.sysman.eml.mntr.emdRepPwdEncrypted=FALSE


targets.xml


[Property NAME="UserName" VALUE="80ec9025e45b2d20" ENCRYPTED="TRUE"/]

[Property NAME="password" VALUE="94124d177df7c5d9" ENCRYPTED="TRUE"/]



Replace username value with “SYSMAN” and password value with “SYSMAN PASSWORD”

[Property NAME="UserName" VALUE="SYSMAN" ENCRYPTED="TRUE"/]

[Property NAME="password" VALUE="ORACLE" ENCRYPTED="TRUE"/]



4. startup dbconsole services

C:\>set oracle_sid=oem

C:\>emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.1.0.5.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://taj.domainname.local:5501/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ...The OracleDBConsoleoe
m service is starting................
The OracleDBConsoleoem service was started successfully.


5.Unlock SYSMAN account

SQL> alter user sysman account unlock;

User altered.




15 comments:

Babu said...

Taj,

Very nice post.

But i have one doubt why don't set ENCRYPTED=FALSE in targets.xml ?

Babu

Babu said...

Can you explain me ??

Anonymous said...

Oracle makes it encrypted=true again. You are writing not encrypted so it is encrypted=false.

Mohammed Taj said...

Hello All,

Yes, oracle makes it encrypted=TRUE again during repository creation.

so we need to set "encrypted=FALSE" before repository creation.

Anonymous said...

Hi,

In fact in 11g in targets.xml the password stay in clear text. However after removing the username and password in targets.xml the console still works fine.

Regards.

Yann

Anonymous said...

Excellent post. Thanks!

Arun said...

great help! thanks a ton.

Anonymous said...

Great help. Thanks a ton.

Anonymous said...

not modify argets.xml...
run $ORACLE_HOME/bin/emca -deconfig dbcontrol db
and $ORACLE_HOME/bin/emca -config dbcontrol db

Anonymous said...

You are the best Mohammed.

Thank you very much

Anonymous said...

Thank you so much for this very useful post.
Fxr

Mohammed Taj said...

Thank you everyone ...


Taj.

halimdba said...

very helpful.

regards
Halim

Mohammed Taj said...

Thank you...

Anonymous said...

Thank god for your post. I was wondering though how you managed to find this solution. Could you enlighten us?