How To Create dbconsole ?

Problem :-
I am using three database with single $ORACLE_HOME i.e single Oracle Binary. When I created three database one after another, the dbconsole services was overwritten by one another, and at last none is available and functioning.

Solution :-
Steps to recreate dbconsole -:
1. export ORACLE_HOME=
2. export ORACLE_SID=
3. SQL> drop user sysman cascade;
4. SQL> drop role MGMT_USER;
5. SQL> drop user MGMT_VIEW cascade;
6. SQL> drop public synonym MGMT_TARGET_BLACKOUTS;
7. SQL> drop public synonym SETEMVIEWUSERCONTEXT;


Remove the following directories from your filesystem if exits:


Now run the following command to configure the dbconsole

1. export ORACLE_HOME=
2. export ORACLE_SID=
3. cd $ORACLE_HOME/bin./emca -config dbcontrol db -repos create

After this, it will ask for the following information and give you result -:

STARTED EMCA at Jan 21, 2009 2:35:59 PMEM Configuration Assistant, Version 10.2.0.1.0 ProductionCopyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: unixcm
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):

-------------------------------------------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ /orahome/oracle/product/10.2.0
Database hostname ................
Listener port number ................
Database SID ................
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Jan 21, 2009 2:36:33 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /orahome/oracle/product/10.2.0/cfgtoollogs/emca/unixcm/emca_2009-01-21_02-35-59-PM.log.
Jan 21, 2009 2:36:35 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jan 21, 2009 2:38:08 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Jan 21, 2009 2:38:12 PM oracle.sysman.emcp.util.DBControlUtil startOMSINFO:
Starting Database Control (this may take a while) ...
Jan 21, 2009 2:39:55 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfullyJan 21, 2009 2:39:55 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: The Database Control URL is : http://www.blogger.com/5500/em
Follow the same steps above to create another dbconsole, but don't forget to export $ORACLE_HOME
$ORACLE_SID

To check status , stop and start dbconsole of a respective database, first always do this
export $ORACLE_HOME
export $ORACLE_SID
-------------------------------------------------------------------------------------------------