Emre Baransel - Oracle Blog

This strange error appeared after trying to login enterprise manager dbconsole. Error message clearly notes that there is an authentication problem but a user (me this time) who reads this error message normally thinks that he has entered wrong username or password. This is not the problem here, because when we enter wrong information on em login screen we see an error like:

Error
Your username and/or password are invalid.

So checked the log file '$ORACLE_HOME/hostname/sysman/log/emoms.log' and saw an error like:

java.sql.SQLException: ORA-28001: the password has expired

This indicates that the status of SYSMAN user is expired. (This is most likely caused by the profile of SYSMAN user). Check the SYSMAN user status.

select USERNAME, ACCOUNT_STATUS from dba_users where username='SYSMAN';


USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SYSMAN EXPIRED

You should set a new password for SYSMAN user to make the status 'OPEN'. Changing SYSMAN password is not as easy as changing other users' passwords. This operation requires edition of some configuration files.

1- Stop dbconsole and grid control agent (if exists)

emctl stop dbconsole
emctl stop agent

2- change SYSMAN password

SQL>alter user sysman identified by newpassword;

3- Go to $ORACLE_HOME/hostname/sysman/config. First backup then edit 'emoms.properties'

Modify the parameters:
oracle.sysman.eml.mntr.emdRepPwd=newpassword
oracle.sysman.eml.mntr.emdRepPwdEncrypted=FALSE

NOTE: When you restart the OMS, the FALSE setting will change to TRUE and the password will become encrypted in the file

4- If there is an agent installed go to $AGENT_HOME/sysman/emd and edit targets.xml

Modify the following line:


NOTE: When you restart the OMS, the FALSE setting will change to TRUE and the password will become encrypted in the file

5- Start the services

emctl start dbconsole
emctl start agent

Error will gone and you will be able to login enterprise manager.