Oracle Enterprise Manager

If Agent won't allow connections (ORA-28001)

If you get a ORA-28001 or "Enterprise Manager is not able to connect to the database instance" or "ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)" error, the most probable reason is that the SYSMAN user password has expired. You need to do more than just change this password however... here's what you'll need to do...

Make sure that ORACLE_HOME, ORACLE_SID environment variables are set.

Stop the dbconsole: emctl stop dbconsole.

Connect to the database as a user with DBA privilege using SQL*Plus:

sqlplus /nolog
conn / as sysdba
    

Then run: alter user sysman identified by YourNewPassword;

Make sure that your password works: conn sysman/YourNewPassword

cd to $ORACLE_HOME/YourInstanceSID/sysman/config backup the emoms.properties file.

Edit the emoms.properties file and change oracle.sysman.eml.mntr.emdRepPwd=ABunchOfEncryptedValues to oracle.sysman.eml.mntr.emdRepPwd=YourNewPassword

Then modify oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE to oracle.sysman.eml.mntr.emdRepPwdEncrypted=FALSE

Restart the dbconsole: emctl start dbconsole

Refresh your Oracle Enterprise Manager in your browser.