19 | 10 | 2017
Latest Articles
Popular Articles

Administration

Database Control Configuration

User Rating:  / 1
PoorBest 

The Database Control Configuration ( 11G )

 

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

CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
2-jun-2009 22:48:04 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
2-jun-2009 22:48:04 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter EMAIL_ADDRESS.
2-jun-2009 22:48:04 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MAIL_SERVER_NAME.
2-jun-2009 22:48:04 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
2-jun-2009 22:48:04 oracle.sysman.emcp.EMConfig perform
SEVERE: Invalid Hostname PC_van_Guy. Hostname should not contain underscore _ in it.

 

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:

Management Repository has been placed in secure mode wherein Enterprise Manager

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.

Enterprise Manager configuration completed successfully

FINISHED EMCA at 2-jun-2009 23:13:08

DatabaseControlHome