Step by Step "How to drop and create enterprise manager dbconsole repository in Oracle 10gR2 running Windows"

1. Check Enterprise Manager service is running or not.

 C:\Users\Administrator>emctl status dbconsole
Environment variable ORACLE_SID not defined. Please define it.

2. set ORACLE_SID value

C:\Users\Administrator>set ORACLE_SID=orcl

3. Drop Dbconsole and repository – Enterprice Manager in 10g

emca -deconfig dbcontrol db -repos drop

======================
C:\Users\Administrator>emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Jun 23, 2014 3:59:18 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: orcl
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: Y
Jun 23, 2014 3:59:48 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at F:\oracle\product\10.2.0\db_2\cfgtoollog
s\emca\orcl\emca_2014-06-23_03-59-17-AM.log.
Jun 23, 2014 3:59:51 AM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be p
erformed.
Jun 23, 2014 3:59:51 AM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Jun 23, 2014 4:01:14 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jun 23, 2014 4:01:14 AM

C:\Users\Administrator>
======================

4. Create Dbconsole and repository – Enterprice Manager in 10g

emca -config dbcontrol db -repos create
======================
C:\Users\Administrator>emca -config dbcontrol db -repos create

STARTED EMCA at Jun 23, 2014 4:03:02 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: orcl
Listener port number: 1521
Password for SYS user:
Password for SYS user: sys123
Password for SYSMAN 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 ................ F:\oracle\product\10.2.0\db_2

Database hostname ................ saidrasel-PC.sblcorp.com
Listener port number ................ 1521
Database SID ................ orcl
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Jun 23, 2014 4:04:26 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at F:\oracle\product\10.2.0\db_2\cfgtoollog
s\emca\orcl\emca_2014-06-23_04-03-02-AM.log.
Jun 23, 2014 4:04:35 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jun 23, 2014 4:07:21 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Jun 23, 2014 4:07:39 AM oracle.sysman.emcp.util.PlatformInterface executeCommand

WARNING: Error executing CMD /C F:\oracle\product\10.2.0\db_2\bin\emctl.bat depl
oy dbconsole F:\oracle\product\10.2.0\db_2\saidrasel-PC.sblcorp.com_orcl saidras
el-PC.sblcorp.com:3938 saidrasel-PC.sblcorp.com orcl
Jun 23, 2014 4:07:39 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Error instantiating EM configuration files
Refer to the log file at F:\oracle\product\10.2.0\db_2\cfgtoollogs\emca\orcl\emc
a_2014-06-23_04-03-02-AM.log for more details.
Could not complete the configuration. Refer to the log file at F:\oracle\product
\10.2.0\db_2\cfgtoollogs\emca\orcl\emca_2014-06-23_04-03-02-AM.log for more deta
ils.

C:\Users\Administrator>
======================
5. Check the status of dbconsole

C:\Users\Administrator>emctl status dbconsole
Unable to determine local host from URL REPOSITORY_URL=http://saidrasel-PC.sblco
rp.com:%EM_UPLOAD_PORT%/em/upload/

6. The very first thing is, add your machine host name in hosts file:

127.0.0.1       localhost
10.xx.xx.xx  machine-host-name

The location of hosts file (in Windows) is C:\WINDOWS\system32\drivers\etc\hosts

7. Drop and create current Database Console repository by issuing Step 3 and 4.

8. Check the status of dbconsole

C:\Users\Administrator>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://saidrasel-PC:1158/em/console/aboutApplication
EM Daemon is not running.
------------------------------------------------------------------
Logs are generated in directory F:\oracle\product\10.2.0\db_2/saidrasel-PC_orcl/
sysman/log

C:\Users\Administrator>

9. Check the Enterprise Manager agent timezone located 

ORACLE_HOME/HOST_NAME_SID\sysman\config
emd.properties file and set the timezone (for Bangladesh)
agentTZRegion=+06:00

10. Stop and start dbconsole

11. Now run the enterprise manager dbconsole in any browser

http://saidrasel-PC:1158/em/


Note: This solution is tested in Windows 7 and Oracle 1ogR2 Database.