Database Control Gives Error Message: “Enterprise Manager Is Not Able To Connect to the Database instance”


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.
Instance Status:Open
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.

Note:
If you reopen  ”emoms.properties” file, ”oracle.sysman.eml.mntr.emdRepPwd” is encrypted and the value ”oracle.sysman.eml.mntr.emdRepPwdEncrypted” is TRUE

Advertisements

3 Comments

Filed under Oracle

3 responses to “Database Control Gives Error Message: “Enterprise Manager Is Not Able To Connect to the Database instance”

  1. Thank you!! Thank you!! Thank you!! Thank you!!
    You saved my GPA!! Thanks (Tears)

  2. Thushara

    Thanx very much !!!

  3. Tuaans ngocj

    Thanks You very much!!!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s