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.
