How to Change the Password of the 10g Database User Dbsnmp

	Doc ID:	259387.1	Type:	BULLETIN
	Modified Date :	23-DEC-2008	Status:	PUBLISHED

PURPOSE
-------

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

 
SCOPE & APPLICATION
-------------------
All database administrators using the Standalone dbconsole


How to change the password of the 10g database user dbsnmp
----------------------------------------------------------
 
To change the password of the user dbsnmp 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
   $ export ORACLE_SID=<The SID of the database monitored by the dbconsole>
   $ emctl stop dbconsole
   on Windows
   Stop the Windows Service Oracle<oracle_home_name>DBConsole<SID>
   Or
   Open a DOS Command Window and type
   C> set ORACLE_SID=<The SID of the database monitored by the dbconsole>
   C> set ORACLE_HOME=<ORACLE_HOME of the database>
   C> cd %ORACLE_HOME%/bin
   C> emctl stop dbconsole

2. Check that the standalone dbconsole and the emagent are stopped
   on Unix
   $ emctl status dbconsole
   $ emctl status agent
   on Windows
   Check the status of the Windows Service Oracle<oracle_home_name>DBConsole
   Check that the process emagent.exe is not running in Task Manager
   Or
   Open a DOS Command Window, cd to the database $ORACLE_HOME\bin and type
   C> emctl status dbconsole
   C> emctl status agent

3. Connect to the database as a user with DBA privilege with SQL*Plus 
   and execute
   SQL> alter user dbsnmp identified by <new_password> ;

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

5. Go to $ORACLE_HOME/host_sid/sysman/emd
   5.1 Save the file targets.xml to targets.xml.orig
   5.2 Edit the file targets.xml with your favorite text editor 
      (wordpad is recommended on Windows platform)
      Search for the line:
      <Property NAME="password" VALUE="<encrypted_string>" ENCRYPTED="TRUE"/>
      Replace the encrypted value by the new password value
      Replace TRUE by FALSE

6. Restart the standalone dbconsole
   on Unix
   $ export ORACLE_SID=<The SID of the database monitored by the dbconsole>
   $ emctl start dbconsole
   on Windows
   Start the Windows Service Oracle<oracle_home_name>DBConsole<SID>
   Or
   Open a DOS Command Window and type
   C> set ORACLE_SID=<The SID of the database monitored by the dbconsole>
   C> set ORACLE_HOME=<ORACLE_HOME of the database>
   C> cd %ORACLE_HOME%/bin
   C> emctl start dbconsole

7. 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

Note: In case of Rac DB, the dbsnmp password should be changed in targets.xml
not only for instances(oracle_database), but also for rac_database target.