1 Reply Latest reply: Dec 4, 2012 11:37 AM by User579398-Oracle RSS

    Error when discovering Oracle EBS from Enterprise Manager 12C

    739888
      Hi everyone..

      I have installed Enterprise manager 12C and discovered EBS database.But im unable to discover EBS applications through it.

      OEM VERSION : 12C R2
      EBIS VERSION : VISION INSTANCE 12.1.3
      DATABASE : 11.2.0.3



      I'm getting below error when im trying to discover through menu Targets----->Oracle E-Business Suite Instances



      Error Log

      oracle.apps.ebs.amp.oms.discovery.discoverer.AppsDiscoveryException: TargetRegistration :: registerService : SQLException - ORA-20233: Either the target or the metric does not exist for <target_name>/<metric_name>/<metric_column> VIS_ocs.ocs.dmsswt.com_HTTP Server/ResponseStatus
      ORA-06512: at "SYSMAN.EM_REP_METRIC", line 390
      ORA-06512: at "SYSMAN.EM_REP_METRIC", line 629
      ORA-06512: at "SYSMAN.EM_REP_METRIC", line 1775
      ORA-06512: at "SYSMAN.MGMT_TARGET", line 4057
      ORA-06512: at "SYSMAN.MGMT_SERVICE", line 2227
      ORA-06512: at "SYSMAN.MGMT_SERVICE", line 1340
      ORA-06512: at line 1

      Caused By: java.sql.SQLException: ORA-20233: Either the target or the metric does not exist for <target_name>/<metric_name>/<metric_column> VIS_ocs.ocs.dmsswt.com_HTTP Server/ResponseStatus
      ORA-06512: at "SYSMAN.EM_REP_METRIC", line 390
      ORA-06512: at "SYSMAN.EM_REP_METRIC", line 629
      ORA-06512: at "SYSMAN.EM_REP_METRIC", line 1775
      ORA-06512: at "SYSMAN.MGMT_TARGET", line 4057
      ORA-06512: at "SYSMAN.MGMT_SERVICE", line 2227
      ORA-06512: at "SYSMAN.MGMT_SERVICE", line 1340
      ORA-06512: at line 1

      oracle.apps.fnd.oam.em.util.job.CommandException
      Caused By: oracle.apps.fnd.oam.em.sdk.targetData.discovery.AppsDiscoveryException: Error while attempting to discover EBS on : VIS( oracle_database ) using schema: apps
      Caused By: oracle.apps.ebs.amp.oms.discovery.discoverer.AppsDiscoveryException: TargetRegistration :: registerService : SQLException - ORA-20233: Either the target or the metric does not exist for <target_name>/<metric_name>/<metric_column> VIS_ocs.ocs.dmsswt.com_HTTP Server/ResponseStatus
      ORA-06512: at "SYSMAN.EM_REP_METRIC", line 390
      ORA-06512: at "SYSMAN.EM_REP_METRIC", line 629
      ORA-06512: at "SYSMAN.EM_REP_METRIC", line 1775
      ORA-06512: at "SYSMAN.MGMT_TARGET", line 4057
      ORA-06512: at "SYSMAN.MGMT_SERVICE", line 2227
      ORA-06512: at "SYSMAN.MGMT_SERVICE", line 1340
      ORA-06512: at line 1

      Caused By: java.sql.SQLException: ORA-20233: Either the target or the metric does not exist for <target_name>/<metric_name>/<metric_column> VIS_ocs.ocs.dmsswt.com_HTTP Server/ResponseStatus
      ORA-06512: at "SYSMAN.EM_REP_METRIC", line 390
      ORA-06512: at "SYSMAN.EM_REP_METRIC", line 629
      ORA-06512: at "SYSMAN.EM_REP_METRIC", line 1775
      ORA-06512: at "SYSMAN.MGMT_TARGET", line 4057
      ORA-06512: at "SYSMAN.MGMT_SERVICE", line 2227
      ORA-06512: at "SYSMAN.MGMT_SERVICE", line 1340
      ORA-06512: at line 1



      =================================================================

      Output Log

      ******Discovery Exceptions:
      ******Exception 0
      oracle.apps.fnd.oam.em.sdk.targetData.discovery.AppsDiscoveryException: Error while attempting to discover EBS on : VIS( oracle_database ) using schema: apps
           at oracle.apps.fnd.oam.em.onDemand.jobs.OAMRegisterEBSOD.execute(Unknown Source)
           at oracle.apps.fnd.oam.em.util.job.AbstractCommandExecutor.executeCommand(Unknown Source)
           at oracle.sysman.emdrep.jobs.CommandStepExecutor.execute(CommandStepExecutor.java:154)
           at oracle.sysman.emWebservices.inbound.jobs.worker.ConsoleJobStepExecutor.execute(ConsoleJobStepExecutor.java:321)
           at oracle.sysman.emWebservices.inbound.jobs.worker.ConsoleJobStepExecutor.executeStep(ConsoleJobStepExecutor.java:187)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at oracle.j2ee.ws.server.jaxws.ServiceEndpointRuntime.processMessage(ServiceEndpointRuntime.java:370)
           at oracle.j2ee.ws.server.jaxws.ServiceEndpointRuntime.processMessage(ServiceEndpointRuntime.java:202)
           at oracle.j2ee.ws.server.jaxws.JAXWSRuntimeDelegate.processMessage(JAXWSRuntimeDelegate.java:474)
           at oracle.j2ee.ws.server.provider.ProviderProcessor.doEndpointProcessing(ProviderProcessor.java:1187)
           at oracle.j2ee.ws.server.WebServiceProcessor$1.run(WebServiceProcessor.java:1120)
           at oracle.j2ee.ws.server.WebServiceProcessor$1.run(WebServiceProcessor.java:1118)
           at java.security.AccessController.doPrivileged(Native Method)
           at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
           at oracle.security.jps.internal.jaas.AccActionExecutor.execute(AccActionExecutor.java:74)
           at oracle.security.jps.internal.jaas.CascadeActionExecutor$SubjectPrivilegedExceptionAction.run(CascadeActionExecutor.java:83)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
           at weblogic.security.Security.runAs(Security.java:61)
           at oracle.security.jps.wls.jaas.WlsActionExecutor.execute(WlsActionExecutor.java:51)
           at oracle.security.jps.internal.jaas.CascadeActionExecutor.execute(CascadeActionExecutor.java:56)
           at oracle.j2ee.ws.server.provider.GenericProviderPlatform.runAs(GenericProviderPlatform.java:398)
           at oracle.j2ee.ws.server.WebServiceProcessor.invokeEndpointImplementation(WebServiceProcessor.java:1138)
           at oracle.j2ee.ws.server.provider.ProviderProcessor.doRequestProcessing(ProviderProcessor.java:581)
           at oracle.j2ee.ws.server.WebServiceProcessor.processRequest(WebServiceProcessor.java:233)
           at oracle.j2ee.ws.server.WebServiceProcessor.doService(WebServiceProcessor.java:193)
           at oracle.j2ee.ws.server.WebServiceServlet.doPost(WebServiceServlet.java:485)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
           at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
           at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
           at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
           at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.sysman.eml.app.EMRepLoginFilter.doFilter(EMRepLoginFilter.java:335)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.sysman.emas.fwk.MASConnectionFilter.doFilter(MASConnectionFilter.java:41)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:179)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:550)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.adfinternal.view.faces.caching.filter.AdfFacesCachingFilter.doFilter(AdfFacesCachingFilter.java:137)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
           at java.security.AccessController.doPrivileged(Native Method)
           at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
           at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)
           at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
           at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
           at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
           at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
           at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
           at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
           at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
           at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
      Caused by: oracle.apps.ebs.amp.oms.discovery.discoverer.AppsDiscoveryException: TargetRegistration :: registerService : SQLException - ORA-20233: Either the target or the metric does not exist for <target_name>/<metric_name>/<metric_column> VIS_ocs.ocs.dmsswt.com_HTTP Server/ResponseStatus
      ORA-06512: at "SYSMAN.EM_REP_METRIC", line 390
      ORA-06512: at "SYSMAN.EM_REP_METRIC", line 629
      ORA-06512: at "SYSMAN.EM_REP_METRIC", line 1775
      ORA-06512: at "SYSMAN.MGMT_TARGET", line 4057
      ORA-06512: at "SYSMAN.MGMT_SERVICE", line 2227
      ORA-06512: at "SYSMAN.MGMT_SERVICE", line 1340
      ORA-06512: at line 1

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


      Can anyone help me out?

      Thanks very much.

      Regards,
      Pubudu
        • 1. Re: Error when discovering Oracle EBS from Enterprise Manager 12C
          User579398-Oracle
          Hello,

          The errors you are receiving are typically a result of not following our published MOS note and our documentation. It’s important in order for Oracle E-Business Suite systems to be properly recognized by E-Business Suite Plug-in, AutoConfig must be enabled and updated on all nodes. You should prevalidate your system before the running discovery to help ensure success of the discovery process. These tests check that context files, context variables, users, and components are set up correctly in the system for successful discovery.

          For more information on both topics refer to:
          •     Getting Started with Oracle Application Management Pack (AMP) for Oracle E-Business Suite, Release 12.1.0.1 (Doc ID 1434392.1)
          •     Oracle Application Management Pack for Oracle E-Business Suite Guide Release 12.1.0.1.0 Part No. E28715-03 October

          If you are still experiencing errors after reviewing our documentation and taking the appropriate steps to prevalidate your system consider filing a Service Request with Support.

          Regards,
          Product Management