如何重新配置Oracle的

今天打算启用一下Oracle Database 11g的Database Control，发现初始并未安装:

[oracle@test126 ~]$ emctl start

EM Configuration issue. /opt/oracle/product/11.1.0/_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@

Outgoing Mail (SMTP) server for notifications (optional):

-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /opt/oracle/product/11.1.0

Local hostname ................

Listener port number ................ 1521

Database SID ................ dodd

Email address for notifications ............... eygle@

Outgoing Mail (SMTP) server for notifications .......汇龙荣登全省二十强。为推进生猪产业化发展........

-----------------------------------------------------------------

Do you wish to continue? [yes(Y)/no(N)]: Y

Aug 28, 2007 11:56:58 AM Config perform

INFO: This operation is being logged at /opt/oracle/cfgtoollogs/emca/dodd/emca_2007_08_28_11_54_g.

Aug 28, 2007 11:57:01 AM ReposConfig invoke

INFO: Dropping the EM repository (this may take a while) ...

Aug 28, 2007 11:57:16 AM ReposConfig invoke

INFO: Repository successfully dropped

Aug 28, 2007 11:57:16 AM ReposConfig createRepository

INFO: Creating the EM repository (this may take a while) ...

Aug 28, 2007 12:08:35 PM ReposConfig invoke

INFO: Repository successfully created

Aug 28, 2007 12:08:47 PM ReposConfig uploadConfigDataToRepository

INFO: Uploading configuration data to EM repository (this may take a while) ...

Aug 28, 2007 12:11:45 PM ReposConfig invoke

INFO: Uploaded configuration data successfully

Aug 28, 2007 12:11:51 PM ControlUtil configureSoftwareLib

INFO: Software library configured successfully.

Aug 28, 2007 12:11:51 PM DBPostConfig configureSoftwareLibrary

INFO: Deploying Provisioning archives ...

Aug 28, 2007 12:12:13 PM DBPostConfig configureSoftwareLibrary

INFO: Provisioning archives deployed successfully.

Aug 28, 2007 12:12:13 PM ControlUtil secureDBConsole

INFO: Securing Database Control (this may take a while) ...

Aug 28, 2007 12:12:39 PM ControlUtil secureDBConsole

INFO: Database Control secured successfully.

Aug 28, 2007 12:12:39 PM ControlUtil startOMS

INFO: Starting Database Control (this may take a while) ...

Aug 28, 2007 12:14:04 PM DBPostConfig performConfiguration

INFO: Database Control started successfully

Aug 28, 2007 12:14:04 PM DBPostConfig performConfiguration

INFO: The Database Control URL is

Aug 28, 2007 12:14:16 PM DBPostConfig 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/_dodd/sysman/config/a. 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中，配置方法与此相同。

配置完成之后就可以启动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.

Starting Oracle Enterprise Manager 11g Database Control ........ started.

------------------------------------------------------------------

Logs are generated in directory /opt/oracle/product/11.1.0/_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 ]

查看本文来源