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

Advertisements