change SYSMAN password in Oracle 10g


I would like to share how to change SYSMAN password in Oracle 10g (10.1 & 10.2) and 11gR1.
Applies to:
Oracle RDBMS 10.1, 10.2 & 11.1
Solution:

(1) Ensure following environment variables are set correctly.
ORACLE_HOME
ORACLE_SID
PATH=$ORACLE_HOME/bin:$PATH
(2) Stop EM dbconsole.
UNIX/Linux:
$ emctl stop dbconsole
Windows:
- Stop the Windows Service OracleDBConsole
or
c:\> emctl stop dbconsole
(3) Check that the standalone dbconsole is stopped.
UNIX/Linux:
$ emctl status dbconsole
Windows:
- check status of Windows Service for OracleDBConsole
or
c:\> emctl status dbconsole
(4) Connect to database with SYS or SYSTEM:
SQL> alter user SYSMAN identified by newpassword ;
(5) Check connection with new password.
SQL> connect sysman/[@database_alias]
(6) Go to $ORACLE_HOME/_/sysman/config.
6.1 Save the file emoms.properties to emoms.properties.orig
6.2 Edit the file emoms.properties
a. Search for the line beginning with:
oracle.sysman.eml.mntr.emdRepPwd=
Replace the encrypted value by the new password value
b. Search for the line:
oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE
Replace TRUE by FALSE
(7) Restart the standalone dbconsole.
UNIX/Linux:
$ emctl start dbconsole
Windows:
Start the Windows Service OracleDBConsole
or
c:\> emctl start dbconsole
(8) Check that the password has been encrypted.
Edit the file emoms.properties
8.1 Search for the line beginning with:
oracle.sysman.eml.mntr.emdRepPwd=
Check that the password is encrypted
8.2 Search for the line beginning with:
oracle.sysman.eml.mntr.emdRepPwdEncrypted=
Check that the value is TRUE

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: