See also at Oracle' s Metalink
How To Drop, Create And Recreate the Database Control (DB Control) Release 10g and 11g (Doc ID 278100.1)
This is how I configured the database control after I initially created my database without configuring it.
Important to mention is that the somewhat unlucky hostname of my laptop is "pc_van_guy" and that these underscores triggered a severe error while I tried to configure the Database Control.
A logfile located in %ORACLE_HOME%\cfgtoollogs\emca mentionned the below error
I also noticed the message "CONFIG: No value was set for the parameter ORACLE_HOSTNAME."
What I did is
1. I added the below entry in the %WINDIR%\system32\drivers\etc\hosts.
127.0.0.1 localhost ::1 localhost 127.0.0.1 PC_VAN_GUY
2. I assured my listener was also listening on 127.0.0.1 by editing the %ORACLE_HOME%\network\admin\listener.ora
3. And I set the ORACLE_HOSTNAME environment as indicated below.
C:\Windows\system32>SET ORACLE_HOSTNAME=127.0.0.1
C:\Windows\system32>emca -config dbcontrol db
STARTED EMCA at 2-jun-2009 23:03:55
EM Configuration Assistant, Version 11.1.0.7.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: PLATINUM
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
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 ................ C:\oracle\product\11.1.0\db_1
Local hostname ................ 127.0.0.1
Listener port number ................ 1521
Database SID ................ PLATINUM
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
Do you wish to continue? yes(Y)/no(N): Y
2-jun-2009 23:04:13 oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at C:\oracle\product\11.1.0\cfgtoollogs\emca\PLATINUM\emca_2009_06_02_23_03_55.log.
2-jun-2009 23:04:15 oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
2-jun-2009 23:05:57 oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
2-jun-2009 23:06:04 oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
2-jun-2009 23:06:04 oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
2-jun-2009 23:06:30 oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
2-jun-2009 23:06:30 oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
2-jun-2009 23:06:51 oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
2-jun-2009 23:06:51 oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
2-jun-2009 23:12:41 oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
2-jun-2009 23:12:41 oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO:The Database Control URL is "https://127.0.0.1:5501/em">https://127.0.0.1:5501/em
2-jun-2009 23:13:08 oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
data will be encrypted. The encryption key has been placed in the file: C:\oracle\product\11.1.0\db_1\127.0.0.1_PLATINUM\sysman\config\emkey.ora.
Please ensure this file is backed up as the encrypted data will become unusable if this file is lost.
FINISHED EMCA at 2-jun-2009 23:13:08