(1) Check whether your database is registered with Enterprise Manager or not, using following command:
posdbprod21:oracle> emctl status dbconsole
OC4J Configuration issue. /oracle/app/oracle/product/10.1/oc4j/j2ee/OC4J_DBConsole_posdbprod21_CIF not found.
posdbprod21:oracle>
This means database is not registered with OEM.
(2) Remember DBCA and other java interfaces use /vat/opt/oracle/oratab file to find the number of oracle instances instaled on that server. So ensure that you have your database entry in oratab. I have put following entry there:
CIF:/oracle/app/oracle/product/10.1:N
(3) To register this database with OEM we need to run dbca. for that
(3-1) find your local PC IP.
(3-2) Set DISPLAY env variable pointing to local ip as following:
posdbprod21:oracle> export DISPLAY=10.180.78.47:0.0
(3-3) Start X-windows client on your PC. Here i will start Reflection-X locally on my PC.
(3-4) Now start Database Configuration Asst using command line tool “dbca”.
(3-5) Click on next while navigating through GUI.
(3-6) Check the box on “Configure the Database with Enterprise Manager”.
The radio will be at “Use Database Control for Database Management”. I didnt check any of following options as i dont need them at this time:
“Enable Email Notifications”
“Enable Daily Backup”
Then Click Next..
(3-7) While registering Listeners select “Register this database with selected listeners only”. and select “LISTENER_CIF” for here.
(3-8) Now, you will be asked to provide passwords for SYSMAN and DBSNMP users. give appropriate password. I generally keep same password as SYS.
(4) After that when we check dbconsole status, we will get following results:
posdbprod21:oracle> emctl status dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.1.0.4
Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved.
http://posdbprod21:5502/em/console/aboutApplication
Oracle Enterprise Manager 10g is running.
——————————————————————
Logs are generated in directory /oracle/app/oracle/product/10.1/posdbprod21_CIF/sysman/log
posdbprod21:oracle>
So now DB is registered with OEM and Intelligent Agent is running on this server.
(5) Now here you can see follwoing string in above step-4.
http://posdbprod21:5502/em/console/aboutApplication
So go to your browser and type
http://posdbprod21:5502/em
If you are getting some errors related to resolving name then bypass proxy for local servers and also need to setup your server-ip address in exceptions in browser settings:
Tools -> Internet Options -> Connections -> LAN Settings -> Advanced -> and in Exception mention, your DB server name or IP address of DB server.
So this setting should work.