Oracle DB control配置启动

今天打算启用一下Oracle Database 11g的Database Control，发现初始并未安装:[Oracle@test126 ~]$ emctl start
EM Configuration issue. /opt/Oracle/product/11.1.0/test126.hurray.com.cn_dodd not found.
遇到这类问题，可以通过重新配置，来创建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 settingsDatabase Oracle_HOME ................ /opt/Oracle/product/11.1.0Local 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 PMOracle 10g中，配置方法与此相同。
配置完成之后就可以启动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
如果是Linux环境，你可能还需要在iptables中开放1158端口，增加如下一行:
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 1158 -j ACCEPT重新启动防火墙之后就可以通过IE在远端连接EM的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 ]SUSE 10 SP2下安装Oracle 10g R2[多图]Ubuntu系统：存储节点（NDB）的安装及配置相关资讯 oracle

[INS-32052] Oracle基目录和Oracle （07/22/2014 07:41:41）
Oracle 4个大对象（lobs）数据类型（02/03/2013 12:33:05）
Oracle按时间段分组统计（07/26/2012 10:36:48）

[Oracle] dbms_metadata.get_ddl的（07/12/2013 07:37:30）
Liferay Portal 配置使用Oracle和（07/31/2012 20:07:18）
Concurrent Request:Inactive （07/20/2012 07:44:05）

本文评论查看全部评论（0）