無法登錄 Oracle Enterprise Manager 11g：ORA-28001

我無法再登錄 Oracle Enterprise Manager 11g。我收到此錯誤消息：

ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)

我可以使用 SQL Plus登錄伺服器。*我警告我密碼將在 7 天內過期（這與已經過期不同）。*根據幾個文件的建議，我從 SQL Plus 執行了這些命令：

ALTER USER sys IDENTIFIED BY new_password;
ALTER USER system IDENTIFIED BY new_password;

SQL*Plus 不再警告密碼，但我仍然無法使用企業管理器。然後我按照這個刪除密碼過期：

ALTER PROFILE default 
LIMIT password_life_time UNLIMITED

而且我還重新啟動了 Oracle 服務。如果它使用記憶體的憑據，我嘗試從多台電腦中的多個瀏覽器進行連接。

沒辦法：我仍然在企業管理器中得到 ORA-28001。我錯過了什麼？

更新：更多資訊

SQL> select username,ACCOUNT_STATUS,EXPIRY_DATE from dba_users;

USERNAME                       ACCOUNT_STATUS                   EXPIRY_D
------------------------------ -------------------------------- --------
MGMT_VIEW                      OPEN
SYS                            OPEN
SYSTEM                         OPEN
[...]
DBSNMP                         EXPIRED                          24/05/10
SYSMAN                         EXPIRED                          24/05/10
OUTLN                          EXPIRED & LOCKED                 16/11/09
FLOWS_FILES                    EXPIRED & LOCKED                 16/11/09

USERNAME                       ACCOUNT_STATUS                   EXPIRY_D
------------------------------ -------------------------------- --------
MDSYS                          EXPIRED & LOCKED                 16/11/09
ORDSYS                         EXPIRED & LOCKED                 16/11/09
EXFSYS                         EXPIRED & LOCKED                 16/11/09
WMSYS                          EXPIRED & LOCKED                 16/11/09
WKSYS                          EXPIRED & LOCKED                 16/11/09
WK_TEST                        EXPIRED & LOCKED                 16/11/09
CTXSYS                         EXPIRED & LOCKED                 16/11/09
ANONYMOUS                      EXPIRED & LOCKED                 16/11/09
XDB                            EXPIRED & LOCKED                 16/11/09
WKPROXY                        EXPIRED & LOCKED                 16/11/09
ORDPLUGINS                     EXPIRED & LOCKED                 16/11/09

USERNAME                       ACCOUNT_STATUS                   EXPIRY_D
------------------------------ -------------------------------- --------
FLOWS_030000                   EXPIRED & LOCKED                 16/11/09
OWBSYS                         EXPIRED & LOCKED                 16/11/09
SI_INFORMTN_SCHEMA             EXPIRED & LOCKED                 16/11/09
OLAPSYS                        EXPIRED & LOCKED                 16/11/09
SCOTT                          EXPIRED & LOCKED                 16/11/09
ORACLE_OCM                     EXPIRED & LOCKED                 16/11/09
TSMSYS                         EXPIRED & LOCKED                 16/11/09
XS$NULL                        EXPIRED & LOCKED                 16/11/09
BI                             EXPIRED & LOCKED                 16/11/09
PM                             EXPIRED & LOCKED                 16/11/09
MDDATA                         EXPIRED & LOCKED                 16/11/09

USERNAME                       ACCOUNT_STATUS                   EXPIRY_D
------------------------------ -------------------------------- --------
IX                             EXPIRED & LOCKED                 16/11/09
SH                             EXPIRED & LOCKED                 16/11/09
DIP                            EXPIRED & LOCKED
OE                             EXPIRED & LOCKED                 16/11/09
APEX_PUBLIC_USER               EXPIRED & LOCKED                 16/11/09
HR                             EXPIRED & LOCKED                 16/11/09
SPATIAL_CSW_ADMIN_USR          EXPIRED & LOCKED                 16/11/09
SPATIAL_WFS_ADMIN_USR          EXPIRED & LOCKED                 16/11/09

無恥的自我推銷 企業管理器連接不上數據庫實例怎麼辦(ORA-28001)

查看您的 SYSMAN 和 DBSNMP 使用者。AFAIK EM 使用它們。

引用自：https://serverfault.com/questions/145753