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:
Post a Comment