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.