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  ;

4.    驗證密碼是否已經修改

        SQL> connect dbsnmp/[@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:

        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:

          Check that the password VALUE is encrypted

          Check that the value of ENCRYPTED is TRUE