Change SYSMAN Password


SYSMAN : User in database used for Enterprise manager .


Be notice any failed with these steps you to recreate EM again .
Step-1

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

Step-2
emctl stop dbconsole
Step-3
edit emoms.properties ($ORACLE_HOME/localhost.domainname_sid/sysman/config/)
**emoms.properties:

FROM :

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

TO:

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

edit targets.xml files ($ORACLE_HOME/localhost.domainname_sid/sysman/emd/)
**targets.xml
FROM :
[Property NAME=”UserName” VALUE=”80ec9025e45b2d20″ ENCRYPTED=”TRUE”/]
[Property NAME=”password” VALUE=”94124d177df7c5d9″ ENCRYPTED=”TRUE”/]

TO :

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”/]

Step-4:
emctl start dbconsole 
Step-5 (in case sysman is locked)
Select Username , account_status from dba_users where username=upper(‘sysman’);
If its locked then
alter user sysman account unlock ;
Thank you
Osama Mustafa 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

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