How to Change DBSNMP Password in Oracle Database 10g and 11g?

 Change DBSNMP Password in Database 10g and 11g for DB Control

To change the password of the user DBSNMP you must strictly follow the steps below, otherwise the 10g or 11g DB Control used to manage your database will not function properly becouse database is monitored through the DB Control.

You can directly change SYS and SYSTEM user password after login as sysdba privilages.

> alter user SYS identified by new_password;
> alter user SYSTEM identified by new_password; 

but you need to follow below steps when change DBSNMP User Password.

This Post is useful to those who are using the DB Control to monitor their 10g or 11g Database.

if you not properly below steps then your EM may not work properly.

1. Stop the standalone dbconsole
   On Unix - DB Control Release up to 11.1.x

$ export ORACLE_SID=<database_sid>
$ emctl stop dbconsole

On Unix - DB Control Release 11.2.x and higher

$ export ORACLE_SID=<database_sid>
$ export ORACLE_UNQNAME=<value of the DB_UNIQUE_NAME database parameter>
$ emctl stop dbconsole

On Windows - DB Control Release up to 11.1.x

Stop the Windows Service OracleDBConsole<database_sid>
Or
Open a DOS Command Window and type
C> set ORACLE_SID=<database_sid>
C> set ORACLE_HOME=<oracle_home_name>
C> cd %ORACLE_HOME%/bin
C> emctl stop dbconsole

On Windows - DB Control Release 11.2.x and higher

Stop the Windows Service OracleDBConsole<database_sid>
Or
Open a DOS Command Window and type
C> set ORACLE_SID=<database_sid>
C> set ORACLE_UNQNAME=<value of the DB_UNIQUE_NAME database parameter>
C> set ORACLE_HOME=<oracle_home_name>
C> cd %ORACLE_HOME%/bin
C> emctl stop dbconsole

2. Check that the DB Control is stopped
   On Unix

$ emctl status dbconsole

On Windows

Check the status of the Windows Service OracleDBConsole
Or
Open a DOS Command Window, cd to the database $ORACLE_HOME\bin 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 dbsnmp identified by <new dbsnmp password> ;

4. Check the new password

SQL> connect dbsnmp/password[@database_alias]

5. Go to $ORACLE_HOME/host_sid/sysman/emd
1. Save the file targets.xml to targets.xml.orig
2. Edit the file targets.xml with your favorite text editor
1. Search for the line:
   <property name="password" value="<encrypted_string>" encrypted="TRUE">
2. Replace the encrypted value by the new password value
3. Replace TRUE by FALSE
3. Restart the standalone dbconsole
   On Unix - DB Control Release up to 11.1.x

$ export ORACLE_SID=<database_sid>
$ emctl start dbconsole

On Unix - DB Control Release 11.2.x and higher

$ export ORACLE_SID=<database_sid>
$ export ORACLE_UNQNAME=<value of the DB_UNIQUE_NAME database parameter>
$ emctl start dbconsole

On Windows - DB Control Release up to 11.1.x

Start the Windows Service OracleDBConsole<database_sid>
Or
Open a DOS Command Window and type
C> set ORACLE_SID=<database_sid>
C> set ORACLE_HOME=<oracle_home_name>
C> cd %ORACLE_HOME%/bin
C> emctl start dbconsole

On Windows - DB Control Release 11.2.x and higher

Start the Windows Service OracleDBConsole<database_sid>
Or
Open a DOS Command Window and type
C> set ORACLE_SID=<database_sid>
C> set ORACLE_UNQNAME=<value of the DB_UNIQUE_NAME database parameter>
C> set ORACLE_HOME=<oracle_home_name>
C> cd %ORACLE_HOME%/bin
C> emctl start dbconsole

4. Check that the password has been encrypted
   Edit the file targets.xml
   Search for the line: <property name="password" value="<encrypted_string>" encrypted="TRUE">
   Check that the password VALUE is encrypted
   Check that the value of ENCRYPTED is TRUE

Please Give Your Expert Suggestion or Comment If any....! Thank You