安装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

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7199859/viewspace-545154/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7199859/viewspace-545154/