安裝oracle 10g EM database control

   今天下午在公司裝了下10g em database control,以方偏web方式來管理資料庫

手工建立EM dbconsole的步驟
1. 建立oracle資料庫
2. 建立資料檔案庫
    emca -repos create
3. 配置EM dbconsole
    emca -config dbconsole db
4. 檢查EM dbconsole 配置屬性
   檢查$ORACLE_HOME/_/sysman/config下的
  emoms.properties

5.在以web方式執行http://192.168.15.109:5500/em登入後出現以下錯誤

java.lang.Exception: Exception in sending Request :: null
 解決方案：找到下面的檔案

$ORACLE_HOME\db_1\$HOSTNAME\sysman\config\emd.properties

其中的agentTZRegion預設是GMT,改為你所在的時區即可,例如:

agentTZRegion=GMT+8

關於時區的列表參考：10.2.0\db_1\sysman\admin\supportedtzs.lst

然後先停止 dbconsole 使時區設定生效並重啟OracleDBConsole：

1.emctl stop dbconsole

2.emctl resetTZ agent

D:\oracle\product\10.2.0\db_1\BIN>emctl resetTZ agent
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
Updating D:\oracle\product\10.2.0\db_1/192.168.15.109_orcl/sysman/config/emd.pro
perties...
Time zone set to Asia/Shanghai.

To complete this process, you must either:

connect to the database served by this DBConsole as user 'sysman', and execute:

SQL> exec mgmt_target.set_agent_tzrgn('192.168.15.109:3938','Asia/Shanghai')

                        -- or --

connect to the database served by this DBConsole as user 'sys', and execute:

SQL> alter session set current_schema = SYSMAN;
SQL> exec mgmt_target.set_agent_tzrgn('192.168.15.109:3938','Asia/Shanghai')

3.emctl config agent getTZ

4.emctl start dbconsole