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系統執行狀態的相關資料，sysman是oem的超級管理員。如果配置了oem後，又使用alter user identified by ；修改了這兩使用者的口令，就會出現dbsnmp 和sysman  "LOCKED(TIMED)". 的情況。

解決方法：
還必須同步修改oem中記錄的dbsnmp和sysman使用者的口令。

$emca  -config  dbcontrol db

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