分类： Oracle
2009-08-14 08:56:58
操作系统：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
