sysman密码过期导致oem无法使用

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