oracle 10g em 中如何修改dbsnmp用户密码

 

修改dbsnmp密码

1. 停止em

Emctl stop dbconsole

2. 检查是否已经停掉em

Emctl status dbconsole

3. 用sys用户登录sqlplus，用命令修改密码

Sqlplus / as sysdba

alter user dbsnmp identified by <new_password> ;

4. 验证密码是否已经修改

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

5. 修改targets.xml文件

进入到$ORACLE_HOME/host_sid/sysman/emd目录

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

          Value里面输入新密码

         ENCRYPTED里面的true改为false

6. 启动em

Emctl start dbconsole

7. 检查targets.xml文件密码是否已经加密等

         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