Geek asks and answers

Oracle 11G EM not working on Windows 7

I installed oracle 11G release 2 on my 64-bit Windows 7 computer, but I can not start em. When I log in, it generates the error "Internal error encrypted verification log file for details." After I noticed:

  • The service is ORACLEDBConsoleorclnot running.
  • When I start dctconsole emctl start, it gives me the error "A specific service error has occurred: 2", followed by "additional help is available by typing NET HELPMSG"

  • After the setup database setup assistant gave me the warning "Error starting database management", run the following commands

    • Set the environment variable ORACLE_UNQNAME to a unique database name
    • c:\app\henry\product\11.2.0\dbhome_1\bin\emctl.bat start dbconsole

  • Below is the details of enoms

2011-05-30 13: 05: 05,601 [EMUI_13_05_05_ / console / database / instance / sitemap] ERROR perf.sitemap initializeGeneral.580 - Failed to initialize object: ORA-20206: 
ORA-06512: at "SYSMAN.EMD_DATABASE", line 1297
ORA-01403: no data found
ORA-06512: at line 1

2011-05-30 13: 05: 05,788 [MetricCollector: HOMETAB_THREAD600: 60] ERROR rt.DbMetricCollectorTarget _getAllData.344 - java.lang.NullPointerException
java.lang.NullPointerException
    at oracle.sysman.emSDK.emd.comm.EMDClient.getURL (EMDClient.java:1570)
    at oracle.sysman.emSDK.emd.comm.EMDClient.getConnection (EMDClient.java:1266)
    at oracle.sysman.emSDK.emd.comm.EMDClient.getConnection (EMDClient.java:1242)
    at oracle.sysman.emSDK.emd.comm.EMDClient.getResponseForRequest (EMDClient.java:1689)
    at oracle.sysman.emSDK.emd.comm.EMDClient.getMetrics (EMDClient.java:981)
    at oracle.sysman.emo.perf.metric.rt.DbHomeTab._getAllData (DbHomeTab.javahaps40)
    at oracle.sysman.emo.perf.metric.rt.DbHomeTab.getData (DbHomeTab.java:154)
    at oracle.sysman.emo.perf.metric.eng.MetricCached.collectCachedData (MetricCached.java:416)
    at oracle.sysman.emo.perf.metric.eng.MetricCollectorThread._collectCachedData (MetricCollectorThread.java:605)
    at oracle.sysman.emo.perf.metric.eng.MetricCollectorThread.run (MetricCollectorThread.java:325)
    at java.lang.Thread.run (Thread.java∗95)
2011-05-30 13: 05: 05,788 [MetricCollector: HOMETAB_THREAD600: 60] ERROR rt.DbMetricCollectorTarget _getAllData.344 - java.lang.NullPointerException
java.lang.NullPointerException
    at oracle.sysman.emSDK.emd.comm.EMDClient.getURL (EMDClient.java:1570)
    at oracle.sysman.emSDK.emd.comm.EMDClient.getConnection (EMDClient.java:1266)
    at oracle.sysman.emSDK.emd.comm.EMDClient.getConnection (EMDClient.java:1242)
    at oracle.sysman.emSDK.emd.comm.EMDClient.getResponseForRequest (EMDClient.java:1689)
    at oracle.sysman.emSDK.emd.comm.EMDClient.getMetrics (EMDClient.java:981)
    at oracle.sysman.emo.perf.metric.rt.DbHomeTab._getAllData (DbHomeTab.javahaps40)
    at oracle.sysman.emo.perf.metric.rt.DbHomeTab.getData (DbHomeTab.java:154)
    at oracle.sysman.emo.perf.metric.eng.MetricCached.collectCachedData (MetricCached.java:416)
    at oracle.sysman.emo.perf.metric.eng.MetricCollectorThread._collectCachedData (MetricCollectorThread.java:605)
    at oracle.sysman.emo.perf.metric.eng.MetricCollectorThread.run (MetricCollectorThread.java:325)
    at java.lang.Thread.run (Thread.java∗95)
2011-05-30 13: 05: 05,788 [EMUI_13_05_05_ / console / database / instance / sitemap] ERROR perf.sitemap initializeFromAgent.1047 - java.lang.NullPointerException
java.lang.NullPointerException
    at oracle.sysman.emSDK.emd.dtd.ValueRow.getNumValue (ValueRow.javahaps30)
    at oracle.sysman.emSDK.emd.dtd.ValueRow.getNumValue (ValueRow.java data66)
    at oracle.sysman.emo.smap.DBInstanceInitializer.initializeFromAgent (DBInstanceInitializer.java:998)
    at oracle.sysman.emo.smap.DBInstanceInitializer.initialize (DBInstanceInitializer.javahaps95)
    at oracle.sysman.emo.smap.DBInstance.init (DBInstance.java:643)
    at oracle.sysman.db.adm.inst.SitemapController.getBean (SitemapController.java:3570)
    at oracle.sysman.db.adm.inst.SitemapController.getInstanceBean (SitemapController.java:2963)
    at oracle.sysman.db.adm.inst.SitemapController.logFeatureUsageHomePage (SitemapController.java:6384)
    at oracle.sysman.db.adm.inst.SitemapController.onDoLoad (SitemapController.java:3058)
    at oracle.sysman.db.adm.BaseController.handleEvent (BaseController.java:1306)
    at oracle.sysman.emSDK.svlt.PageHandler.handleRequest (PageHandler.java∗77)
    at oracle.sysman.db.adm.RootController.handleRequest (RootController.java:235)
    at oracle.sysman.db.adm.BaseController.handleRequest (BaseController.java:1238)
    at oracle.sysman.db.adm.DBControllerResolver.handleRequest (DBControllerResolver.java:139)
    at oracle.sysman.emSDK.svlt.EMServlet.myDoGet (EMServlet.java:787)
    at oracle.sysman.emSDK.svlt.EMServlet.doGet (EMServlet.javahaps43)
    at oracle.sysman.eml.app.Console.doGet (Console.javahaps19)
    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:165)
    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.javahaps57)
    at com.evermind.server.http.ServletRequestDispatcher.invoke (ServletRequestDispatcher.java:621)
    at com.evermind.server.http.ServletRequestDispatcher.forwardInternal (ServletRequestDispatcher.javahaps70)
    at com.evermind.server.http.HttpRequestHandler.doProcessRequest (HttpRequestHandler.java:871)
    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∗95)
2011-05-30 13: 05: 05,803 [EMUI_13_05_05_ / console / database / instance / sitemap] ERROR svlt.PageHandler handleRequest.639 - java.lang.NullPointerException
java.lang.NullPointerException
    at oracle.sysman.util.jdk.VersionUtil.compareVersion (VersionUtil.java:63)
    at oracle.sysman.db.adm.inst.SitemapController.setRequestAttributes (SitemapController.java:1355)
    at oracle.sysman.db.adm.BaseController.handleEvent (BaseController.java:1391)
    at oracle.sysman.emSDK.svlt.PageHandler.handleRequest (PageHandler.java∗77)
    at oracle.sysman.db.adm.RootController.handleRequest (RootController.java:235)
    at oracle.sysman.db.adm.BaseController.handleRequest (BaseController.java:1238)
    at oracle.sysman.db.adm.DBControllerResolver.handleRequest (DBControllerResolver.java:139)
    at oracle.sysman.emSDK.svlt.EMServlet.myDoGet (EMServlet.java:787)
    at oracle.sysman.emSDK.svlt.EMServlet.doGet (EMServlet.javahaps43)
    at oracle.sysman.eml.app.Console.doGet (Console.javahaps19)
    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:165)
    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.javahaps57)
    at com.evermind.server.http.ServletRequestDispatcher.invoke (ServletRequestDispatcher.java:621)
    at com.evermind.server.http.ServletRequestDispatcher.forwardInternal (ServletRequestDispatcher.javahaps70)
    at com.evermind.server.http.HttpRequestHandler.doProcessRequest (HttpRequestHandler.java:871)
    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∗95)
+4
source share
1 answer

You probably did not configure Windows 7 to let Oracle work without problems before installing it (opening ports, disabling UAC, installing JDK, etc.).

Oracle 11gR2 Windows 7. Windows 7 11.2.0.3.

0

More articles:


All Articles