配置oracle11g EM db control

前陣子裝好了11g後，發現oracle11g文件很多快速管理指南的內容都是透過EM來進行的，但我在文件上並沒找到EM的安裝說明，於是試著透過10g的說明來對其進行配置。

從安裝軟體上看，我並沒找到grid control部分，不知道是不是還沒有推出，下面簡單描述一下db control的配置過程以及遇到的幾個問題。

listener1=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=oratest)(PORT=1521))
)

並指定local_listener＝listener1後，動態註冊立即生效了。至於為啥，我不知道，新特性還是bug？以後再說吧（10G沒怎麼玩過，不知道有沒這個問題）

重新執行emca -config dbcontrol db -repos recreate，成功，開始drop以前的配置了，之後一切順利，執行過程及結果訊息如下：

$ emca -config dbcontrol db -repos recreate

STARTED EMCA at Aug 29, 2007 8:40:57 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: test11g
Listener port number: 1521
Password for SYS 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 ................ /oracle11g/product/11g

Local hostname ................ oratest
Listener port number ................ 1521
Database SID ................ test11g
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Aug 29, 2007 8:41:20 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle11g/cfgtoollogs/emca/test11g/emca_2007_08_29_08_40_56.log.
Aug 29, 2007 8:41:30 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Aug 29, 2007 8:50:26 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Aug 29, 2007 8:50:28 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Aug 29, 2007 9:16:21 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Aug 29, 2007 9:17:05 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Aug 29, 2007 9:20:57 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfullyAug 29, 2007 9:21:22 AM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Aug 29, 2007 9:21:22 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Aug 29, 2007 9:26:27 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Aug 29, 2007 9:26:27 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Aug 29, 2007 9:27:34 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Aug 29, 2007 9:27:34 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Aug 29, 2007 9:36:05 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Aug 29, 2007 9:36:08 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is <<<<<<<<<<<
Aug 29, 2007 9:37:50 AM 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: /oracle11g/product/11g/oratest_test11g/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 29, 2007 9:37:51 AM

emkey.ora是金鑰的所在地所以如果在生成系統上還是需要備份好的。
$ more /oracle11g/product/11g/oratest_test11g/sysman/config/emkey.ora
KEY=056790FE22685160158605895E3E62FC06D7C153C224D99BAA82236AD677DD962B974B3BDA0A678E9D8278C75662EFEB5A8EB793695A79C131F79B8F8BDBBD03
80955F67D1BFBE675F5E20B9DC6B710A92

都完成之後，執行emctl status dbconsole可以檢視狀態，emctl start dbconsole和emctl stop dbconsole可以對Database Control Console Process進行啟停。預設埠依然跟10G一樣是1158，不過似乎不在支援http，只能用https登陸。我從遠端用ie7登陸的時候會警告證照是錯誤的（linux本地上沒有問題），不用管它，繼續就可以看到em的登陸介面了，呵呵。

介面看起來挺友好的，具體功能有待日後研究。