In the Database Control Console, the home page shows the following error:
Enterprise Manager is not able to connect to the database instance. The state of the components are listed below.
Listener Status: Up
Agent Status: Succeeded
Please ensure that DBSNMP, SYSMAN, and SYS accounts are not locked nor password is expired for these accounts. If the accounts are locked or expired, please unlock or change the password accordingly.
If this doesn’t fix the issue, you need to try additional steps are required in order to make Oracle Enterprise Manager connect. Please ensure that ORACLE_HOME, ORACLE_SID environment variables are set correctly and then follow the below steps:
1) Stop the dbconsole by running the below command:
$emctl stop dbconsole
2) Connect to the DB as a user with DBA privileges using SQL*Plus and run the following command:
alter user sysman identified by <new password>
3) Next verify if the new password works
SQL> connect sysman/<new password>
4) Navigate to $ORACLE_HOME/<HostName_SID>/sysman/config and make a backup of the emoms.properties file.
a) Open the file emoms.properties and search for:
oracle.sysman.eml.mntr.emdRepPwd=<some encrypted value>
Replace the encrypted value with the new password value
b) Search for oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE and change TRUE to FALSE.
c) Save and close emoms.properties
5) Restart the dbconsole:
$emctl start dbconsole
Login in again to verify if the issue is fixed.
If you reopen ”emoms.properties” file, ”oracle.sysman.eml.mntr.emdRepPwd” is encrypted and the value ”oracle.sysman.eml.mntr.emdRepPwdEncrypted” is TRUE