Search This Blog

Sunday, April 22, 2007

EM webpage Database Status DOWN


when EM page database status is DOWN

Then first place to check EMAGENT.TRC FILE
Location : $ORACLE_HOME\localhost.domainname_sid\sysman\log




EMAGENT.TRC last few lines

OCISessionBegin"...

LOGIN = dbsnmp/@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=taj.domainname.local)(PORT=1521))(CONNECT_DATA=(SID=orcl)))

2007-04-22 16:10:18 Thread-2692 ERROR vpxoci: ORA-28000: the account is locked

Suggestion : We need to UNLOCK dbsnmp account.

SQL> select account_status
2 from dba_users
3 where username = 'DBSNMP';

ACCOUNT_STATUS
--------------------------------
LOCKED

SQL> alter user dbsnmp ACCOUNT UNLOCK;

User altered.



--Wait for few minutes after access EM webpage.

No comments: