EM无法登录，提示ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)

--查看数据库目前的口令期限

sys@TESTDB11>select * from dba_profiles where profile = 'DEFAULT' and resource_name = 'PASSWORD_LIFE_TIME';

 

PROFILE                        RESOURCE_NAME                    RESOURCE LIMIT

------------------------------ -------------------------------- -------- ----------------------------------------

DEFAULT                        PASSWORD_LIFE_TIME               PASSWORD 180

 

--查看用户的状态,发现DBSNMP和SYSMAN两个帐号都已经过期

sys@TESTDB11>select username, account_status from dba_users;

USERNAME                       ACCOUNT_STATUS

------------------------------ --------------------------------

MGMT_VIEW                      OPEN

SYS                            OPEN

SCOTT                          OPEN

PLSQL                          OPEN

IX                             OPEN

SH                             OPEN

OE                             OPEN

HR                             OPEN

STORE                          OPEN

OPS$USERA                      OPEN

USERA                          OPEN

DBSNMP                         EXPIRED

SYSMAN                         EXPIRED

SYSTEM                         EXPIRED(GRACE)

OUTLN                          EXPIRED & LOCKED

FLOWS_FILES                    EXPIRED & LOCKED

MDSYS                          EXPIRED & LOCKED

ORDSYS                         EXPIRED & LOCKED

EXFSYS                         EXPIRED & LOCKED

WMSYS                          EXPIRED & LOCKED

APPQOSSYS                      EXPIRED & LOCKED

APEX_030200                    EXPIRED & LOCKED

OWBSYS_AUDIT                   EXPIRED & LOCKED

ORDDATA                        EXPIRED & LOCKED

CTXSYS                         EXPIRED & LOCKED

ANONYMOUS                      EXPIRED & LOCKED

XDB                            EXPIRED & LOCKED

ORDPLUGINS                     EXPIRED & LOCKED

OWBSYS                         EXPIRED & LOCKED

SI_INFORMTN_SCHEMA             EXPIRED & LOCKED

OLAPSYS                        EXPIRED & LOCKED

ORACLE_OCM                     EXPIRED & LOCKED

XS$NULL                        EXPIRED & LOCKED

BI                             EXPIRED & LOCKED

PM                             EXPIRED & LOCKED

MDDATA                         EXPIRED & LOCKED

DIP                            EXPIRED & LOCKED

APEX_PUBLIC_USER               EXPIRED & LOCKED

SPATIAL_CSW_ADMIN_USR          EXPIRED & LOCKED

SPATIAL_WFS_ADMIN_USR          EXPIRED & LOCKED

 

40 rows selected.

 

--修改用户的口令期限为无限制

sys@TESTDB11>alter profile default limit password_life_time unlimited;

 

Profile altered.

 

--修改DBSNMP和SYSMAN两个帐号的口令

sys@TESTDB11>alter user dbsnmp identified by dbsnmp;

 

User altered.

 

sys@TESTDB11>alter user sysman identified by sysman;

 

User altered.

 

-- 重新登录 EM, 问题已经解决

--------&gt>如果问题还是没有解决，请继续往下看：

再次查询sysman和dbsnmp用户的状态，这次的状态为LOCKED(TIMED)
SQL> select username,account_status from dba_users where username='SYSMAN';
USERNAME                       ACCOUNT_STATUS
SYSMAN                         LOCKED(TIMED)

原因：
dbsnmp和sysman这两个用户和oem紧密相关，dbsnmp用户启动Oracle智 能代理，用于收集oracle系统运行状态的相关数据，sysman是oem的超级管理员。如果配置了oem后，又使用alter user identified by ；修改了这两用户的口令，就会出现dbsnmp 和sysman  "LOCKED(TIMED)". 的情况。

解决方法：
还必须同步修改oem中记录的dbsnmp和sysman用户的口令。

$emca  -config  dbcontrol db

根据提示修改sysman和dbsnmp的口令即可

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29119536/viewspace-1285762/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29119536/viewspace-1285762/