This discussion is archived
1 Reply Latest reply: Dec 4, 2012 9:37 AM by user579398 RSS

Error when discovering Oracle EBS from Enterprise Manager 12C

739888 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points