很久没打开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 EXPIRED & LOCKED
DBSNMP和SYSMAN都有了,而且状态都是OPEN。
此时EM可以正常打开了^_^