This morning I opened Enterprise Manager and instead of the regular “login”-screen, I found following screen:

 

 

Everything is up and running but Enterprise Manager is not able to connect to the database instance. Sounds like a connection problem, not?

These are the steps I followed to solve this issue and to reset the “sysman”-account:

STEP1: Check EM log file:

 

[oracle@myserver log]$ pwd

 

 

/opt/oracle/product/11.1.0/db/myserver.mydomain_DWHD
/sysman/log

 

 

 [oracle@ myserver log]$ tail -50 emoms.log

…

 

 

2008-02-11 23:12:04,968 [ApplicationServerThread-11]
 ERROR app.SessionObjectManager sessionDestroyed.128 - 
java.sql.SQLException: ORA-28000: the account is locked

 

 

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

…

 

 

STEP 2: Check database users:

 

 

SYSTEM> select username, account_status from dba_users;
USERNAME ACCOUNT_STATUS
------------------------------ -------------
MGMT_VIEW OPEN
SYS OPEN
SYSTEM OPEN
DBSNMP OPEN
SYSMAN LOCKED(TIMED)

 

 

STEP 3: Stop the Database Console

 

[oracle@myserver dbascripts]$ emctl stop dbconsole

 

 

Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0

 

 

Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.

 

 

https://myserver.mydomain:1158/em/console/aboutApplication

 

 

Stopping Oracle Enterprise Manager 11g Database Control ...

 

 

 ... Stopped.

 

 

[oracle@myserver dbascripts]$

 

 

STEP 4: Reset the SYSMAN-account

 


[oracle@myserver log]$ sqlplus "/ as sysdba"
SQL*Plus: Release 11.1.0.6.0 - Production on Tue Feb 12 09:51:59 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SYS> alter user sysman identified by <new_password> account unlock; 
User altered.


 

STEP 5: Reset the SYSMAN-account in the “targets.xml”-file ($ORACLE_HOME/myserver.mydomain _mySID/sysman/emd) and modify the “Username”-Property and the “Password”-property as follows:

 

[oracle@myserver emd]$ pwd
/opt/oracle/product/11.1.0/db/myserver.mydomain_DWHD/sysman/emd
[oracle@myserver emd]$ cp targets.xml targets.xml.ori
[oracle@myserver emd]$ vi targets.xml
…
<Property NAME="UserName" VALUE="SYSMAN" ENCRYPTED="FALSE"/>
<Property NAME="password" VALUE="<new_password>" ENCRYPTED="FALSE"/>
…

 

 

STEP 6: Reset the SYSMAN-account in the “emoms.properties”-file ($ORACLE_HOME/myserver.my_domain_mySID/sysman.config) and modify the “oracle.sysman.eml.mntr.emdRepPwd”-parameter and the “oracle.sysman.eml.mntr.emdRepPwdEncrypted” in the following way:

 

[oracle@myserver config]$ pwd
/opt/oracle/product/11.1.0/db/myserver.mydomain_DWHD/sysman/config
[oracle@myserver config]$ cp emoms.properties emoms.properties.ori
[oracle@myserver config]$ vi emoms.properties
…
oracle.sysman.eml.mntr.emdRepPwd=<new_password>
…
oracle.sysman.eml.mntr.emdRepPwdEncrypted=FALSE
…

 

STEP 7: Start the Database Console

 

[oracle@myserver dbascripts]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://myserver.mydomain:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ...... started.
------------------------------------------------------------------
Logs are generated in directory 
/opt/oracle/product/11.1.0/db/myserver.mydomain_DWHD/sysman/log

 

 

STEP 8: Test