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
I understand the process of changing the sysman password and its encryption.
My question has to deal with why the password would “spontaneously” unencrypt during a reboot? I have noticed this happens sporadically – if there is a another server on the network with the exact saem hostname as the one I am working on… It’s a Lab environment and I deal with multiple images… Sometimes there is a need to have another server on teh network with the same hostname.
I open the emoms.properties file and the password has unecrypted and it in the clear again…
Please help!