今天打算启用一下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 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中,配置方法与此相同。
配置完成之后就可以启动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环境,你可能还oracle认证,加入收藏需要在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 ]。
全部