本帖最后由 paulyi 于 2014-2-9 10:37 编辑

今天下午在公司装了下10g em database control,以方偏web方式来管理数据库手工建立EM dbconsole的步骤

1. 建立oracle数据库

2. 建立资料档案库
emca -repos create

3. 配置EM dbconsole
emca -config dbconsole db

4. 检查EM dbconsole 配置属性
检查[font=Courier New]$ORACLE_HOME/_/sysman/config下的
emoms.properties

[font=Courier New]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
然后先停止 [font=Courier New]dbconsole 使时区设置生效并重启OracleDBConsole：

[font=Courier New]1.emctl stop dbconsole

[font=Courier New]2.emctl resetTZ agent
[font=Courier New]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.
[font=Courier New]To complete this process, you must either:
[font=Courier New]connect to the database served by this DBConsole as user 'sysman', and execute:
[font=Courier New]SQL> exec mgmt_target.set_agent_tzrgn('192.168.15.109:3938','Asia/Shanghai')
[font=Courier New] -- or --
[font=Courier New]connect to the database served by this DBConsole as user 'sys', and execute:
[font=Courier New]SQL> alter session set current_schema = SYSMAN;
SQL> exec mgmt_target.set_agent_tzrgn('192.168.15.109:3938','Asia/Shanghai')

[font=Courier New]3.[font=Courier New]emctl config agent getTZ

[font=Courier New]4.emctl start dbconsole