How to change the password of the Database User SYSMAN when the database is hosting a DB Control Repository.
On Unix
1.Stop the DB Control
On Unix $ emctl stop dbconsole
On WindowsOpen a Command Window and type**> emctl stop dbconsole
2.Check that the DB Control is stoppedOn Unix
$ emctl status dbconsole
On WindowsOpen a DOS Command Window and type**> emctl status dbconsole
3.Connect to the database as a user with DBA privilege with SQL*Plus and execute:
SQL> alter user sysman identified by ;
4.Check the new password
SQL> connect sysman/[@database_alias]
5.Go to $ORACLE_HOME/host_sid/sysman/config do the following :
- Save the file emoms.properties to emoms.properties.orig
- Edit the file emoms.properties
- Search for the line beginning with:
oracle.sysman.eml.mntr.emdRepPwd=
Replace the encrypted value by the new password value
Example:
oracle.sysman.eml.mntr.emdRepPwd=rainbow - Search for the line:
oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE
Replace TRUE by FALSE
6.Restart the DB Control
On Unix
$ emctl start dbconsole Open a DOS Command Window and type**> emctl start dbconsole 7.Check that the password has been encrypted
- Edit the file $ORACLE_HOME/host_sid/sysman/config/emoms.properties
- Search for the line beginning with:
oracle.sysman.eml.mntr.emdRepPwd=
Check that the password is encrypted - Search for the line beginning with:
oracle.sysman.eml.mntr.emdRepPwdEncrypted=
Check that the value is TRUE
I Publish the same lesson but on 11g .
Thank you Osama mustafa
Technology Geek 
Can you assist me with reseting a sysdba password? I dont have any credentials for Java only for the windows system.Thanks in advance!
LikeLike