[Oracle]-[EM]-EM无法打开的解决

很久没打开EM了，打开后今天出现这个报错：

SQL> select username, account_status from dba_users;
USERNAME        ACCOUNT_STATUS
 ------------------------------ --------------------------------
 OUTLN                OPEN
 SYS                      OPEN
 SYSTEM              OPEN
 MY_USER           OPEN
 BISAL                   OPEN
 SCOTT                 OPEN
 TEST                    OPEN
 DBSNMP             EXPIRED & LOCKED
 TSMSYS              EXPIRED & LOCKED
 DIP                       EXPIRED & LOCKED

按说DBSNMP和SYSMAN用户是用于EM的，但这里SYSMAN没有呢？

决定重新创建一个EM资料库：

[oracle@liu Desktop]$ emca -config dbcontrol db -repos create
...

再次：SQL> select username, account_status from dba_users;

USERNAME       ACCOUNT_STATUS
 ------------------------------ --------------------------------
 OUTLN               OPEN
 MGMT_VIEW     OPEN
 SYS                     OPEN
 SYSTEM             OPEN
 DBSNMP            OPEN
 SYSMAN             OPEN
 MY_USER          OPEN
 BISAL                  OPEN
 SCOTT                OPEN
 TEST                   OPEN
 TSMSYS             EXPIRED & LOCKED
 DIP

DBSNMP和SYSMAN都有了，而且状态都是OPEN。

此时EM可以正常打开了^_^