[Translated from mos] modify the dbsnmp password in the DB (10g and 11g) monitored by the db Control, mosdbsnmp

[Translated from mos] modify the dbsnmp password in the DB (10g and 11g) monitored by the db Control, mosdbsnmp

How to modify the dbsnmp password in the DB (10g and 11g) monitored by db Control

Reference Original:
How to Change DBSNMP Password in Database 10g and 11g Monitored by DB Control (Doc ID 259387.1)

Applicable:
Enterprise Manager for Oracle Database-Version 10.1.0.4 to 11.2.0.3 [Release 10.1 to 11.2]
Information in this document applies to any platform.

Purpose:
When a database of 10g or 11g is monitored by the database, modify the dbsnmp user password in the database.
ATTENTION: Enterprise Manager 10g is now in extended support. Oracle strongrong recommends that you upgrade your environment to either Enterprise Manager 11g or 12c, both of which are still in premier Support.

Range:
All Database administrators who use db control to monitor their 10g or 11g db

Details:
When you change the dbsnmp password, you must strictly follow the steps below. Otherwise, the 10g or 11g db Control that manages your DB will run abnormally.

Note: For DB Control Release 10.2.0.3 and later installed on Windows 2008/Vista, The emctl command may fail and the error is "Permission Denied ".
Please refer to the following article to solve this error:
Document 1164293.1-Executing Any EMCTL Command on Windows 2008/Vista Returns "Permission denied" Error

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 has been 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. log on to sqlplus with the dba permission and execute the following statement: ---> the db logged in is the monitored database.
SQL> alter user dbsnmp identified by <new dbsnmp password>;

4. confirm that the new password can be connected:
SQL> connect dbsnmp/[@ database_alias]

5. To the $ ORACLE_HOME/host_sid/sysman/emd directory -----> this step should be performed on the standalone dbconsole host?
5.1 copy the targets. xml file as targets. xml. orig
5.2 use a text editor to edit the targets. xml file
5.2.1 find the following line:
<Property name = "password" value = "<encrypted_string>" encrypted = "TRUE">
5.2.2 Replace the encrypted value with the new password
5.3.3 replace TRUE with FALSE
5.3 restart 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

5.4 confirm that the password has been encrypted
View targets. xml
Search: <property name = "password" value = "<encrypted_string>" encrypted = "TRUE">
Check that the password value is encrypted.
Check whether the value of ENCRYPTED is TRUE.