oracle 10g em db control中如何修改sysman密碼

paulyibinyi發表於2010-05-27

sysman密碼

1.    停止em

Emctl stop dbconsole 

2.    檢查是否已經停掉em

Emctl status dbconsole

3.    sys使用者登入sqlplus,用命令修改密碼

Sqlplus / as sysdba

alter user sysman identified by  ;

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

     SQL> connect sysman/[@database_alias]

 

5.      修改emoms.properties檔案

進入到$ORACLE_HOME/host_sid/sysman/config目錄
5.1 cp emoms.properties emoms.properties.orig
        5.2 Edit the file emoms.properties
         a. Search for the line beginning with:
          oracle.sysman.eml.mntr.emdRepPwd=
          Replace the encrypted value by the new password value
         b. Search for the line:
          oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE
          Replace TRUE by FALSE
         
         oracle.sysman.eml.mntr.emdRepPwd裡面輸入新密碼
         oracle.sysman.eml.mntr.emdRepPwdEncrypted=true的值改為false
 

6.      啟動em

      Emctl  start dbconsole

7.      檢查emoms.properties檔案 密碼檔案是否已經加密等

         Edit the file emoms.properties
         7.1 Search for the line beginning with:
           oracle.sysman.eml.mntr.emdRepPwd=
           Check that the password is encrypted
         7.2 Search for the line beginning with:
          oracle.sysman.eml.mntr.emdRepPwdEncrypted=
          Check that the value is TRUE

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-663834/,如需轉載,請註明出處,否則將追究法律責任。

相關文章