start oracle DB control configuration

Jun 23 posted in Oracle (RSS), 511 views.

Today, you intend to enable Oracle Database 11g's Database Control, found that the initial is not installed:

[Oracle @ test126 ~] $ emctl start
EM Configuration issue. / Opt/Oracle/product/11.1.0/test126.hurray.com.cn_dodd not found.

Problems of this sort can be re-configured to create the configuration file EM:

[Oracle @ test126 11.1.0] $ emca-config dbcontrol db-repos recreate
STARTED EMCA at Aug 28, 2007 11:54:40 AM
EM Configuration Assistant, Version 11.1.0.5.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: dodd
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): eygle@eygle.com
Outgoing Mail (SMTP) server for notifications (optional):
-------------------------------------------------- ---------------

You have specified the following settings

Database Oracle_HOME ................ / opt/Oracle/product/11.1.0

Local hostname ................ test126.hurray.com.cn
Listener port number ................ 1521
Database SID ................ dodd
Email address for notifications ............... eygle@eygle.com
Outgoing Mail (SMTP) server for notifications ...............

-------------------------------------------------- ---------------
Do you wish to continue? [Yes (Y) / no (N)]: Y
Aug 28, 2007 11:56:58 AM Oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at / opt/Oracle/cfgtoollogs/emca/dodd/emca_2007_08_28_11_54_40.log.
Aug 28, 2007 11:57:01 AM Oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Aug 28, 2007 11:57:16 AM Oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Aug 28, 2007 11:57:16 AM Oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...

Aug 28, 2007 12:08:35 PM Oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Aug 28, 2007 12:08:47 PM Oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Aug 28, 2007 12:11:45 PM Oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Aug 28, 2007 12:11:51 PM Oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Aug 28, 2007 12:11:51 PM Oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Aug 28, 2007 12:12:13 PM Oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Aug 28, 2007 12:12:13 PM Oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Aug 28, 2007 12:12:39 PM Oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Aug 28, 2007 12:12:39 PM Oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Aug 28, 2007 12:14:04 PM Oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Aug 28, 2007 12:14:04 PM Oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https: / / test126.hurray.com.cn: 1158/em <<<<<<<<<<<
Aug 28, 2007 12:14:16 PM Oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************ 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: / opt/Oracle/product/11.1.0/test126.hurray.com.cn_dodd/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 Aug 28, 2007 12:14:16 PM

Oracle 10g, the same configuration.
Can be configured to start after the completion of the EM:

[Oracle @ test126 11.1.0] $ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https: / / test126.hurray.com.cn: 1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ........ started.
-------------------------------------------------- ----------------
Logs are generated in directory / opt/Oracle/product/11.1.0/test126.hurray.com.cn_dodd/sysman/log

If it is Linux environment, you may also need to open 1158 port in iptables, add the following line:
-A RH-Firewall-1-INPUT-m state - state NEW-m tcp-p tcp - dport 1158-j ACCEPT

After the restart the firewall can connect through IE on the remote EM of the Database Control:

[root @ test126 sysconfig] # service iptables restart
Flushing firewall rules: [OK]
Setting chains to policy ACCEPT: filter [OK]
Unloading iptables modules: [OK]
Applying iptables firewall rules: [OK]
Loading additional iptables modules: ip_conntrack_netbios_ns [OK]