How to change the password of the Database User SYSMAN when the database is hosting a DB Control Repository.
1.Stop the DB Control
On Unix
$ emctl stop dbconsole
On Windows
Open a Command Window and type
**> emctl stop dbconsole
2.
Check that the DB Control is stopped
On Unix
$ emctl status dbconsole
On Windows
Open 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