How to change the password of the 10g database user sysman

	Doc ID:	259379.1	Type:	BULLETIN
	Modified Date :	12-MAR-2008	Status:	PUBLISHED

PURPOSE
-------

How to change the password of the database user sysman

 
SCOPE & APPLICATION
-------------------
All database administrators using the Enterprise Manager 10G DB Control
(also known as RDBMS 10G Standalone dbconsole)


How to change the password of the 10g database user sysman
----------------------------------------------------------

The Oracle user sysman is the schema of the standalone repository 
of the 10G Enterprise Manager DB Control.

To ensure that you change the sysman password in the right database,
you must check that the environment variable ORACLE_SID is set.
You must also check that the environment variable ORACLE_HOME is set 
and that the path includes the correct $ORACLE_HOME/bin.

To change the password of the user sysman you must strictly 
follow the steps below, otherwise you 10g Standalone dbconsole used to manage
your 10g database will not function properly.

1. Stop the standalone dbconsole
   on Unix
   $ emctl stop dbconsole
   on Windows
   Stop the Windows Service Oracle<oracle_home_name>DBConsole
   Or
   Open a DOS Command Window and type
   C> emctl stop dbconsole

2. Check that the standalone dbconsole is stopped
   on Unix
   $ emctl status dbconsole
   on Windows
   Check the status of the Windows Service Oracle<oracle_home_name>DBConsole
   Or
   Open a DOS Command Window and type
   C> 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 <new_password> ;

4. Check the new password
   SQL> connect sysman/<new_password>[@database_alias]

5. Go to $ORACLE_HOME/host_sid/sysman/config
   5.1 Save the file emoms.properties to emoms.properties.orig
   5.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

6. Restart the standalone dbconsole
   on Unix
   $ emctl start dbconsole
   on Windows
   Start the Windows Service Oracle<oracle_home_name>DBConsole
   Or
   Open a DOS Command Window and type
   C> emctl start dbconsole

7. Check that the password has been encrypted
   Edit the file emoms.properties
   7.1 Search for the line beginning with:
       oracle.sysman.eml.mntr.emdRepPwd=
       Check that the password is encrypted
   7.2 Search for the line beginning with:
       oracle.sysman.eml.mntr.emdRepPwdEncrypted=
       Check that the value is TRUE