I've Oracle DB 10g Rel. 2 installed on RHEL 4. The database is up and running i.e. everyone can connect to the DB by using any App tool e.g. SQL*Plus, Forms, or Reports. It means that the listener and the service is running. But the problem is that when I try to start the EM I see some error messages on the webpage.
It says:
Enterprise Manager is not able to connect to the database instance. The state of the components are listed below.
Database Instance (Red arrow pointing downwards)
Host workflow-dev
Port 1521
SID orcl
Oracle Home /opt/oracle/product/10gR2
Agent Connection to Instance (Red arrow pointing downwards)
Status Unavailable
Details
Listener (Green arrow pointing upwards)
Status Up
Host workflow-dev
Port 1521
Name LISTENER
Oracle Home /opt/oracle/product/10gR2
Location /opt/oracle/product/10gR2/network/admin
I've already checked all the services, they are running. And when I execute emctl command I got the following message.
emctl status dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://workflow-dev:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is running.
My question is if every thing is workign fine then what is the problem with the EM? Why it is not connecting to the DB?
Thanks.