Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

0

好友

1

主题
1#
发表于 2013-4-5 21:11:26 | 查看: 3181| 回复: 0
1. 系统情况如下 :
OS: ebsdb1 B.11.31
Oracle: 10.2.0.4 enterprise edition(已经打过em的8350262补丁)
hostname: ebsdb1
/etc/hosts设置: 10.30.50.xxx    ebsdb1.cn.xxgroup.com ebsdb1

现在的情况是创建并启动em dbconsole之后,em登陆界面输入用户密码,然后页面就一直卡在那里,进不到console界面。
  1. $ emctl status dbconsole
  2. Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
  3. Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved.
  4. https://ebsdb1.cn.xxxgroup.com:1158/em/console/aboutApplication
  5. Oracle Enterprise Manager 10g is running.
  6. ------------------------------------------------------------------
  7. Logs are generated in directory /u02/prod/db/tech_st/10.2.0/ebsdb1.cn.xxxgroup.
  8. com_PROD/sysman/log

  9. $ emctl status agent
  10. Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
  11. Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved.
  12. ---------------------------------------------------------------
  13. Agent Version     : 10.1.0.6.0
  14. OMS Version       : 10.1.0.6.0
  15. Protocol Version  : 10.1.0.2.0
  16. Agent Home        : /u02/prod/db/tech_st/10.2.0/ebsdb1.cn.xxxgroup.com_PROD
  17. Agent binaries    : /u02/prod/db/tech_st/10.2.0
  18. Agent Process ID  : 5964
  19. Parent Process ID : 5662
  20. Agent URL         : https://ebsdb1.cn.xxxgroup.com:3938/emd/main
  21. Started at        : 2013-04-05 20:24:00
  22. Started by user   : oraprod
  23. Last Reload       : 2013-04-05 20:24:00
  24. Last successful upload                       : 2013-04-05 21:00:04
  25. Total Megabytes of XML files uploaded so far :     1.35
  26. Number of XML files pending upload           :        1
  27. Size of XML files pending upload(MB)         :     0.00
  28. Available disk space on upload filesystem    :    39.54%
  29. ---------------------------------------------------------------
  30. Agent is Running and Ready
复制代码
2. 卡住的界面就是这里,点击login之后就一直等待服务器反应了:

2013-4-5_0000.png

3. emoms.trc中有如下错误信息:
  1. 2013-04-05 19:32:14,690 [1423::EMUI_19_26_38_/console/database/instance/sitemap] DEBUG em.console doGet.354 - End process
  2. 2013-04-05 19:32:14,687 [1401::EMUI_19_27_00_/console/database/instance/sitemap] ERROR em.console doGet.311 - java.lang.NullPointerException
  3. java.lang.NullPointerException
  4.         at oracle.sysman.db.adm.RootController.getCompartment(RootController.java:385)
  5.         at oracle.sysman.db.adm.RootController.getCompartment(RootController.java:358)
  6.         at oracle.sysman.db.adm.RootController.getCompartment(RootController.java:352)
  7.         at oracle.sysman.db.adm.RootController.setCachedObject(RootController.java:558)
  8.         at oracle.sysman.db.adm.inst.SitemapController.getBean(SitemapController.java:2287)
  9.         at oracle.sysman.db.adm.BaseController.validateFileNameState(BaseController.java:1047)
  10.         at oracle.sysman.db.adm.BaseController.handleEvent(BaseController.java:1017)
  11.         at oracle.sysman.emSDK.svlt.PageHandler.handleRequest(PageHandler.java:376)
  12.         at oracle.sysman.db.adm.RootController.handleRequest(RootController.java:170)
  13.         at oracle.sysman.db.adm.DBControllerResolver.handleRequest(DBControllerResolver.java:114)
  14.         at oracle.sysman.emSDK.svlt.EMServlet.myDoGet(EMServlet.java:688)
  15.         at oracle.sysman.emSDK.svlt.EMServlet.doGet(EMServlet.java:291)
  16.         at oracle.sysman.eml.app.Console.doGet(Console.java:287)
  17.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
  18.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
  19.         at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
  20.         at oracle.sysman.emSDK.svlt.EMRedirectFilter.doFilter(EMRedirectFilter.java:101)
  21.         at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:16)
  22.         at oracle.sysman.db.adm.inst.HandleRepDownFilter.doFilter(HandleRepDownFilter.java:151)
  23.         at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20)
  24.         at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:304)
  25.         at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:600)
  26.         at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317)
  27.         at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:793)
  28.         at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
  29.         at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
  30.         at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
  31.         at java.lang.Thread.run(Thread.java:534)
  32. 2013-04-05 20:22:35,665 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.ias.ias.IASIntegration
  33. 2013-04-05 20:22:36,023 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.eml.target.slb.common.SLBIntegration
  34. 2013-04-05 20:22:36,137 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.eml.ssl.intg.SSLIntegration
  35. 2013-04-05 20:22:36,413 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.tip.oem.central.domain.ProcessConnectDomainIntg
  36. 2013-04-05 20:22:36,415 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.tip.oem.central.instance.ProcessConnectInstanceIntg
  37. 2013-04-05 20:22:36,417 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.webdb.admin.em.PortalIntegration
  38. 2013-04-05 20:22:36,419 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.webdb.admin.em.SSOIntegration
  39. 2013-04-05 20:22:36,421 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.reports.em.RepIntg
  40. 2013-04-05 20:22:36,423 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.ocs.mntr.target.OcsEmailIntegration
  41. 2013-04-05 20:22:36,425 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.ocs.mntr.target.OcsOidIntegration
  42. 2013-04-05 20:22:36,427 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.ocs.mntr.target.OcsOvfIntegration
  43. 2013-04-05 20:22:36,429 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.ocs.mntr.target.OcsWebconfIntegration
  44. 2013-04-05 20:22:36,431 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.ocs.mntr.target.OcsWirelessIntg
  45. 2013-04-05 20:22:36,433 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.ocs.mntr.target.OcsCalGrpIntegration
复制代码
大家帮忙分析下可能是什么地方有问题。另外有一套测试数据库是从生产克隆过去的,em是好的。
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-27 15:53 , Processed in 0.048788 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569