How to modify Dbsnmp User Password in Oracle 10g em

Modify

Dbsnmp

Password

1.



Stop em

Emctl stop dbconsole

 

2.



Check if Em has been stopped

Emctl status dbconsole

 

3.



Use sys
User Login sqlplus
, Use the command to change the password

 

Sqlplus/As sysdba

alter user dbsnmp identified by <new_password> ;

4.



Verify that the password has been modified

       SQL> connect dbsnmp/<new_password>[@database_alias]

 

5.



Modify
Targets. xml
File

Go to the $ ORACLE_HOME/host_sid/sysman/EMD directory.

5.1 cp targets.xml 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

Enter the new password in value.

Change true in encrypted to false.

6.





Start em

Emctl
Start dbconsole

 

7.





Check
Targets. xml
File
Is the password 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