配置oracle 10g oem,oracle 10g oem web登录问题

操作系统：windows 2003 server

数据库版本:oracle 10g 10.2.0.1.0

现象：启动oracledbconsoleSID服务后，登录oem管理页面时报错：java.lang.Exception: Exception in sending Request :: null

以致无法通过web页面管理数据库，sqlplus登录及使用都正常。

----------------------------------------------

搜索很多网页帖子后，找到了解决方法：(文中ad888是我的机器名，orawin是数据库SID)

1.先停止oracledbconsoleSID服务；

2.把C:\oracle\product\10.2.0\db_1\ad888_orawin\sysman\config\emd.properties文件的最后一项参数由agentTZRegion=GMT 改成：agentTZRegion=Asia/Shanghai 正确的时区设置　，保存后重启oracledbconsoleSID服务。

再关闭ie打开web登录页面后恢复正常使用。

最终找到解决方法的页面链接：

oracle支持的时区设置在文件：C:\oracle\product\10.2.0\db_1\sysman\admin\supportedtzs.lst中有列表

问题解决后想再把这个问题重现一下于是把C:\oracle\product\10.2.0\db_1\ad888_orawin\sysman\config\emd.properties文件中的agentTZRegion参数再改成GMT，再重启oracledbconsoleSID却发现还是能正常登录oem web管理页面进行查看操作，连数据库服务和侦听服务都重启了也还是没法重现这个问题，对此感到很奇怪。

另外web页面登录恢复正常后在dos命令行下的状态显示我也感到奇怪，信息贴出如下：

C:\Documents and Settings\Administrator>emctl status dbconsole

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0

Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.

EM Daemon is not running.

------------------------------------------------------------------

Logs are generated in directory c:\oracle\product\10.2.0\db_1/ad888_orawin/sysma

n/log

C:\Documents and Settings\Administrator>emctl status agent

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0

Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.

---------------------------------------------------------------

Agent Version     : 10.1.0.4.1

OMS Version       : 10.1.0.4.0

Protocol Version  : 10.1.0.2.0

Agent Home        : c:\oracle\product\10.2.0\db_1\ad888_orawin

Agent binaries    : c:\oracle\product\10.2.0\db_1

Agent Process ID  : 3956

Agent Process ID  : 3956

Agent URL         :

Started at        : 2009-07-27 14:40:22

Started by user   : SYSTEM

Last Reload       : 2009-07-27 14:40:22

Last successful upload                       : 2009-07-27 14:42:17

Total Megabytes of XML files uploaded so far :     0.07

Number of XML files pending upload           :        1

Size of XML files pending upload(MB)         :     0.04

Available disk space on upload filesystem    :    16.48%

---------------------------------------------------------------

Agent is Running and Ready

在登录异常之前EM Daemon is not running.是这么提示的，但恢复正常后还是这么提示；agent的状态显示倒是正常了。

还有很多事情要忙，先记在这里，以后有空再慢慢研究。

----------------------------------------------

出现问题时一些日志文件中有如下信息：

C:\oracle\product\10.2.0\db_1\ad888_orawin\sysman\log\emdctl.trc出现如下提示：

2009-07-27 13:59:15 Thread-3336 WARN  http: snmehl_connect: connect failed to (ad888:1158): 由于目标机器积极拒绝，无法连接。

(error = 10061)

2009-07-27 13:59:48 Thread-532 WARN  http: snmehl_connect: connect failed to (ad888:3938): 由于目标机器积极拒绝，无法连接。

C:\oracle\product\10.2.0\db_1\ad888_orawin\sysman\log\emdb.nohup出现如下提示：

另一个程序正在使用此文件，进程无法访问。

Monitoring Agent+Console -----

launchprocess::Launching process : c:\oracle\product\10.2.0\db_1\jdk/bin/java -server -Xmx256M -XX:MaxPermSize=96m -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME=c:\oracle\product\10.2.0\db_1 -Doracle.home=c:\oracle\product\10.2.0\db_1/oc4j -Doracle.oc4j.localhome=c:\oracle\product\10.2.0\db_1\ad888_orawin/sysman -DEMSTATE=c:\oracle\product\10.2.0\db_1\ad888_orawin -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=c:\oracle\product\10.2.0\db_1/oc4j/j2ee/OC4J_DBConsole_ad888_orawin/config/jazn.xml -Djava.security.policy=c:\oracle\product\10.2.0\db_1/oc4j/j2ee/OC4J_DBConsole_ad888_orawin/config/java2.policy -Djava.security.properties=c:\oracle\product\10.2.0\db_1/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=c:\oracle\product\10.2.0\db_1\ad888_orawin -Dsysman.md5password=true -Drepapi.oracle.home=c:\oracle\product\10.2.0\db_1 -Ddisable.checkForUpdate=true -Djava.awt.headless=true -jar c:\oracle\product\10.2.0\db_1/oc4j/j2ee/home/oc4j.jar -config c:\oracle\product\10.2.0\db_1/oc4j/j2ee/OC4J_DBConsole_ad888_orawin/config/server.xml

launchprocess::Launched process successfuly. Process Id is : 1476

----- Mon Jul 27 13:00:38 2009::Console Launched with PID 1476 at time Mon Jul 27 13:00:38 2009 -----

----- Mon Jul 27 13:02:10 2009::The agentTZRegion value in c:\oracle\product\10.2.0\db_1\ad888_orawin/sysman/config/emd.properties is not in agreement with what agent thinks it should be.Please verify your environment to make sure that TZ setting has not changed since the last start of the agent.

If you modified the timezone setting in the environment, please stop the agent and exectute 'emctl resetTZ agent' and also execute the script 'mgmt_target.set_agent_tzrgn' to get the value propagated to repository -----

C:\oracle\product\10.2.0\db_1\ad888_orawin\sysman\log\emoms.log出现如下提示：

2009-07-27 03:27:23,031 [CacheManager] ERROR cache.CacheManager run.519 - Exception message: sleep interrupted

java.lang.InterruptedException: sleep interrupted

at java.lang.Thread.sleep(Native Method)

at oracle.sysman.emSDK.svc.cache.CacheManager$Checker.run(CacheManager.java:507)

at java.lang.Thread.run(Thread.java:534)

2009-07-27 03:27:42,703 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.sysman.ias.ias.IASIntegration

2009-07-27 03:27:42,921 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.sysman.eml.target.slb.common.SLBIntegration

2009-07-27 03:27:43,000 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.sysman.eml.ssl.intg.SSLIntegration

2009-07-27 03:27:43,078 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.tip.oem.central.domain.ProcessConnectDomainIntg

2009-07-27 03:27:43,078 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.tip.oem.central.instance.ProcessConnectInstanceIntg

2009-07-27 03:27:43,093 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.webdb.admin.em.PortalIntegration

2009-07-27 03:27:43,093 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.webdb.admin.em.SSOIntegration

2009-07-27 03:27:43,093 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.reports.em.RepIntg

2009-07-27 03:27:43,093 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.sysman.ocs.mntr.target.OcsEmailIntegration

2009-07-27 03:27:43,093 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.sysman.ocs.mntr.target.OcsOidIntegration

2009-07-27 03:27:43,109 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.sysman.ocs.mntr.target.OcsOvfIntegration

2009-07-27 03:27:43,109 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.sysman.ocs.mntr.target.OcsWebconfIntegration

2009-07-27 03:27:43,109 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.sysman.ocs.mntr.target.OcsWirelessIntg

2009-07-27 03:27:43,109 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.sysman.ocs.mntr.target.OcsCalGrpIntegration

2009-07-27 03:28:34,828 [EMUI_03_28_34_/console/database/instance/sitemap] ERROR perf.sitemap initializeGeneral.398 - Failed to initialize object: ORA-20206:

ORA-06512: 在 "SYSMAN.EMD_DATABASE", line 1165

ORA-01403: 未找到数据

ORA-06512: 在 line 1