Thursday, August 16, 2012

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 


No comments:

Post a Comment