Enterprise Manager is not able to connect to the database instance

Today i got this message from OEM,

“Enterprise Manager is not able to connect to the database instance. The state of the components are listed below.”

I have search the solution that help me to fix this problem,

– first, check DBSNMP, SYSMAN, and SYS not locked and password value is ok.


to ensure the correct password, it is better to alter it with new password.

– emca -deconfig dbcontrol db

Database SID : <dbsid>

Listener port number : 1521 (usually)

– emca -config dbcontrol db,

Database SID : <dbsid>

Listener port number : 1521 (usually)

Password for SYS user: <SYS pwd>

Password for DBSNMP user: <DBSNMP pwd>

Password for SYSMAN user: <SYSMAN pwd>
If above step cannot resolve the problem then you can try the others,

–  C:\Documents and Settings\Administrator>set oracle_sid=<dbsid>

– C:\Documents and Settings\Administrator>emctl stop dbconsole

–  connect to database as user with DBA privilege with SQL*Plus

– SQL >alter user sysman identified by <new_password>;

– SQL >exit

– SQL >connect sysman/<new_password>;

– if connected then go to $ORACLE_HOME/host_sid/sysman/config

– locate file “emoms.properties” and backup this file

– open and locate “oracle.sysman.eml.mntr.emdRepPwd”, replace the encrypted value by the<new_password> value

– locate “oracle.sysman.eml.mntr.emdRepPwdEncrypted”, replace TRUE by FALSE

– save file

– C:\Documents and Settings\Administrator>emctl start dbconsole

– if you reopen  “emoms.properties” file, “oracle.sysman.eml.mntr.emdRepPwd” is encrypted

and the value “oracle.sysman.eml.mntr.emdRepPwdEncrypted” is TRUE


8 Responses

  1. I am MSSQL DBA, known oracles but not expert, encountered this tough problem after changed the sys*-like pwd. Find and read many ans from Google/Yahoo, pain for many days. Luckily found your blog and give a comprehensive answer, and stop my trouble.

    Thanks in advance !

    Your blog will keep saving other MSSQL DBA.
    (p.s. although MSSQL is not better than Oracle in all aspects but it was really more DBA-friendly.)

  2. Wonderful…

  3. in oracle’s dbstart file change the oracle_home_listner to the path of the oracle_home directory

  4. Hi!

    Thank you! You saved my day and my problem was solved. 🙂


  5. Thank you so much!
    Very detail!

  6. I resolved with: Try to connect as sysdba and issue startup command from sqlplus.

  7. Hurrah! After all I got a weblog from where I
    can actually get useful data concerning my study and knowledge.

  8. There is clearly a bundle to realize about this. I suppose you made some good points in features also. ecgdeeaebfea

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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s

%d bloggers like this: