henry

0 积分	0 好友	4 主题

发消息

[SQL调优] EM无法访问

1^#

发表于 2015-3-10 16:03:19 | 查看: 2947| 回复: 1

本帖最后由 henry 于 2015-3-10 16:04 编辑

老师，您好：
            今天中午EM控制台突然不能访问了，早晨还能访问。
            现状描述：EM登陆界面能出来，但是登陆后点击“数据库”或“集群”，很长时间没有反应。
            后台emoms.log记录有如下信息：

2015-03-10 12:04:45,166 [EMUI_12_04_45_/console/rac/util/RacFlex] ERROR em.console doGet.352 - Root Cause of the ServletException is
:
2015-03-10 12:04:45,167 [EMUI_12_04_45_/console/rac/util/RacFlex] ERROR em.console doGet.353 - java.lang.NullPointerException
java.lang.NullPointerException
      at oracle.sysman.emo.rac.RacDB.outputDrillDownXML(RacDB.java:2963)
      at oracle.sysman.db.rac.util.RacFlexController.handleRequest(RacFlexController.java:292)
      at oracle.sysman.db.rac.RacControllerResolver.handleRequest(RacControllerResolver.java:141)
      at oracle.sysman.emSDK.svlt.EMServlet.myDoGet(EMServlet.java:787)
      at oracle.sysman.emSDK.svlt.EMServlet.doGet(EMServlet.java:343)
      at oracle.sysman.eml.app.Console.doGet(Console.java:304)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      at oracle.sysman.eml.app.EMRepLoginFilter.doFilter(EMRepLoginFilter.java:208)
      at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
      at oracle.sysman.db.adm.inst.HandleRepDownFilter.doFilter(HandleRepDownFilter.java:168)
      at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17)
      at oracle.sysman.eml.app.BrowserVersionFilter.doFilter(BrowserVersionFilter.java:122)
      at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17)
      at oracle.sysman.emSDK.svlt.EMRedirectFilter.doFilter(EMRedirectFilter.java:102)
      at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17)
      at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:357)
      at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
      at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
      at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:889)
      at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
      at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)
      at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)
      at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
      at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      at java.lang.Thread.run(Thread.java:637)
   ...........................

                  2015-03-10 15:59:53,685 [MetricCollector:RACE2E_THREAD151:15] WARN  em.MetricEngine _suspendMetric.725 - MetricCollectorThread[MetricCollector:RACE2E_THREAD151:15] attempting to suspend non-automated metric...
2015-03-10 15:59:53,685 [MetricCollector:RACE2E_THREAD151:15] WARN  em.MetricEngine _suspendMetric.725 - MetricCollectorThread[MetricCollector:RACE2E_THREAD151:15] attempting to suspend non-automated metric...
2015-03-10 16:00:08,686 [MetricCollector:RACE2E_THREAD151:15] WARN  em.MetricEngine _suspendMetric.725 - MetricCollectorThread[MetricCollector:RACE2E_THREAD151:15] attempting to suspend non-automated metric...
2015-03-10 16:00:08,686 [MetricCollector:RACE2E_THREAD151:15] WARN  em.MetricEngine _suspendMetric.725 - MetricCollectorThread[MetricCollector:RACE2E_THREAD151:15] attempting to suspend non-automated metric...
2015-03-10 16:00:08,686 [MetricCollector:RACE2E_THREAD151:15] WARN  em.MetricEngine _suspendMetric.725 - MetricCollectorThread[MetricCollector:RACE2E_THREAD151:15] attempting to suspend non-automated metric...
2015-03-10 16:00:08,686 [MetricCollector:RACE2E_THREAD151:15] WARN  em.MetricEngine _suspendMetric.725 - MetricCollectorThread[MetricCollector:RACE2E_THREAD151:15] attempting to suspend non-automated metric...
2015-03-10 16:00:23,686 [MetricCollector:RACE2E_THREAD151:15] WARN  em.MetricEngine _suspendMetric.725 - MetricCollectorThread[MetricCollector:RACE2E_THREAD151:15] attempting to suspend non-automated metric...
2015-03-10 16:00:23,687 [MetricCollector:RACE2E_THREAD151:15] WARN  em.MetricEngine _suspendMetric.725 - MetricCollectorThread[MetricCollector:RACE2E_THREAD151:15] attempting to suspend non-automated metric...
2015-03-10 16:00:23,687 [MetricCollector:RACE2E_THREAD151:15] WARN  em.MetricEngine _suspendMetric.725 - MetricCollectorThread[MetricCollector:RACE2E_THREAD151:15] attempting to suspend non-automated metric...
2015-03-10 16:00:23,687 [MetricCollector:RACE2E_THREAD151:15] WARN  em.MetricEngine _suspendMetric.725 - MetricCollectorThread[MetricCollector:RACE2E_THREAD151:15] attempting to suspend non-automated metric...

QQ截图20150310155724.png (30.87 KB, 下载次数: 182)