To Configure & Start dbcontrol in 10g/11g

To Configure & Start dbcontrol in 10g/11g:

Since Oracle 10g, the GUI tool innovated by Oracle to administrate Oracle database/instances are called "Database Control" or "DB console". To help you setting up with easy tips, I condensed the steps to the most simple summary:

1.       Procedure to setup dbconsole:

a.       $ export ORACLE_HOST_NAME = logical hostname

n  This is required since Oracle 10g to setup dbcontrol.

b.      $ emca –config dbcontrol db –repos create

n  This command would generate emca logs located at:

/opt/oracle/pathpod/product/10.x.x.x/cfgtoollogs/emca

c.       $ emca start dbconsole

n  This command will startup the dbconsole

2.       The emca –config dbcontrol db –repos create creats the following objects, which may cause problems if any of those objects already exist in the database. If it hits to an error message saying any of the objects below already exists, then clean up all the objects below and rerun the emca –config –dbcontrol db –repose create command

n  User sysman

n  User mgmt_view

n  Role mgmt_user

n  Public synonym mgmt_target_blackouts

n  Public synonym setemviewusercontext

3.       And I recommend to write a drop scripts to clean out those objects

EX: em_object_clean.sql

Spool em_object_clean.out

Set echo on

Drop user sysman cascade;

Drop user mgmt_view;

Drop role_mgmt_user;

Drop public synonym mgmt_target_blackouts;

Drop public synonym setemviewusercontext;

Spool off

** Note: Be aware of that, clean out the old EM console objects will wide out all the old history of your EM objects, including snapshots, SWR reports, etc; because those objects are owned by sysman user. Therefore, dropping the sysman cascade command actually wipes out those objects. Be considerable before taking this action.