很久没打开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可以正常打开了^_^