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

2014-11-24 17:37:00 · 作者: · 浏览: 1

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



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