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