Thursday, October 9, 2008

How to change the SYSMAN password.




1.0 Stop the standalone dbconsole

on Unix

$ emctl stop dbconsole

on Windows

Stop the Windows Service OracleDBConsole or open a DOS Command Window and type:

C:\> emctl stop dbconsole

2.0 Check that the standalone dbconsole is stopped

on Unix

$ emctl status dbconsole

on Windows check the status of the Windows Service OracleDBConsole

or open a DOS Command Window and type:

C:\> emctl status dbconsole

3.0 Connect to the database as a user with DBA privilege with SQL*Plus and execute

SQL> alter user sysman identified by ;

4.0 Check the new password

SQL> connect sysman/[@database_alias]

5.0 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

1. 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.0 Restart the standalone dbconsole

on Unix

$ emctl start dbconsole

on Windows

Start the Windows Service OracleDBConsole or open a DOS Command Window and type:

C:\> emctl start dbconsole

7.0 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




No comments:

Post a Comment