Skip to content
Advertisements

Archive for

Enterprise Manager is not able to connect to the database instance

Solution :

check the sysman and dbsnmp account status, If expired, please activate
SQL> select username,account_status from dba_users where username =’SYSMAN’;

USERNAME ACCOUNT_STATUS
—————————— ——————————–
SYSMAN EXPIRED

SQL> select username,account_status from dba_users where username =’DBSNMP’;

USERNAME ACCOUNT_STATUS
—————————— ——————————–
DBSNMP OPEN

 

So sysman account has been expired.  Please activate with old password and also Please check if this account has been locked, please unlock this account.

 

SQL> alter user sysman identified by Admin123;

User altered.

SQL> select user,account_status from dba_users where username=’SYSMAN’;

USER ACCOUNT_STATUS
—————————— ——————————–
SYS LOCKED(TIMED)

SQL> alter user sysman account unlock;

User altered.

 

It will work after start the dbconsole

 

 

Advertisements