Enterprise Manager is not able to connect to the database instance. The state of the components are listed below.

Today when i try to connect to Oracle Enterprise Manager in 11gr2 on widows server then got below message

Enterprise Manager is not able to connect to the database instance. The state of the components are listed below.

to check what could be the reason i check emoms.trc file located under

%ORACLE_HOME%\hostname.domainname_dbname\sysman\log\emoms.trc

and found the following error

[SystemThreadGroup-8] ERROR app.SessionObjectManager sessionDestroyed.128 - java.sql.SQLException: ORA-28000: the account is locked

java.sql.SQLException: ORA-28000: the account is locked

After that i checked locked account in db and found the following two account is locked.

1. SYSTEM / 2. SYSMAN

SQL> select username,account_status from dba_users

  2  where account_status ='LOCKED';

USERNAME                       ACCOUNT_STATUS

------------------------------ --------------------------------

SYSTEM                         LOCKED

SYSMAN                         LOCKED

Once i unlocked the account EM working fine

SQL> alter user SYSMAN account unlock;

User altered.