sysman密碼到期導致oem無法使用

2013-09-29 09:29:47,309 [HTTPThreadGroup-5] ERROR eml.OMSHandshake processFailure.808 - OMSHandshake failed.(AGENT URL = https://szpms1:1830/emd/main)(ERROR = INTERNAL_ERROR)(CAUSE =java.sql.SQLException: ORA-28000: the account is locked
2013-09-29 09:29:47,856 [HTTPThreadGroup-5] ERROR conn.ConnectionService verifyRepositoryEx.891 - Invalid Connection Pool. ERROR = ORA-28000: the account is locked

由於SYSMAN使用者密碼到期導致OEM(Oracle 企業管理器)無法正常工作處理方案
1.在所有節點停止OEM服務
  emctl stop dbconsole
 
  停止之後確認狀態
  emctl status dbconsole

2.進入資料庫修改sysman使用者密碼
  alter user sysman identified by passw0rd;
  alter user sysman account unlock;

3.進入每個節點修改設定檔emoms.properties
  目錄 $ORACLE_HOME/${HOSTNAME}_${ORACLE_UNQNAME}/sysman/config
  cd /oracle/11gr2/szpms1_szpmsdb/sysman/config
  cd /oracle/11gr2/szpms2_szpmsdb/sysman/config
 
  oracle.sysman.eml.mntr.emdRepPwd=c509e4dc8aa740d7  --密碼改為新修改的密碼
  oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE    --TRUE改成FALSE

4.在所有節點重新開啟OEM服務
  emctl start dbconsole