How to connect EM to the DB Instance?
I've Oracle DB 10g Rel. 2 installed on Windows 2000 server. 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 C:\oracle\product\10.2.0\db_1
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 C:\oracle\product\10.2.0\db_1
Location C:\oracle\product\10.2.0\db_1\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.
--Khan.
how to connect to EM to the DB instance
Hello Khan,
We are using ASM 10gR2 with ASM and DB installed in two seperate directories.
Today I changed the password for sys, sysman,system, and dbsnmp. Then, I run into the same problem as you which I can not connect to the OEM. I tried to do steps from your suggestion:
1. emca -deconfig dbcontrol db (to drop old config files)
2. emca -config dbcontrol db (to create new config files)
I have questions when I tried to do step 2 (create new config files using "emca -config dbcontrol db"). Step 2 asked for "ASM port". I know that my regular dabase instance listener using 1522. But I am not sure what port I am using for ASM instance.
Then I did:
1. export ORACLE_SID=+ASM
2. cd /app/oracle/product/10.2.0/asm (the directory to ASM_Oracle_Home)
3. I did "/app/oracle/product/10.2.0/asm/bin/lsnrctl start"
I see that ASM running on port 1521.
After that, I see my OEM running normally.
But I could not login into ASM page from OEM, while I could login into ASM from sqlplus. Do you have any clue?