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.

default password for DBSNMP is DBSNMP, SYSMAN is SYSMAN, SYS is MANAGER or CHANGE_ON_INSTALL.

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

About these ads

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. :-)

    Bente

  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 )

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

Follow

Get every new post delivered to your Inbox.

Join 39 other followers

%d bloggers like this: