2 Replies Latest reply: Jun 20, 2013 9:59 AM by 1009441 RSS

    Unable to discover Oracle EBS database using APM

    1009441

      Hi group,

       

      I am trying to configuring Cloud Control 12.1.0.2 with APM, Prevalidate step has been accomplished without any problem, but when I try to Discover this Application, below error are displayed:

       

      Error Log

      java.lang.NullPointerException

      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 : PREBS1( oracle_database ) using schema: apps

      Caused By: java.lang.NullPointerException


      Output Log

       

      ******Discovery Exceptions:

      ******Exception 0

      • oracle.apps.fnd.oam.em.sdk.targetData.discovery.AppsDiscoveryException: Error while attempting to discover EBS on : PREBS1( 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: java.lang.NullPointerException

              at oracle.apps.ebs.amp.oms.discovery.discoverer.EBSTargetDiscovererR12.discoverAppsJVMTarget(Unknown Source)

              at oracle.apps.ebs.amp.oms.discovery.discoverer.EBSTargetDiscovererR12.discoverIASTargets(Unknown Source)

              at oracle.apps.ebs.amp.oms.discovery.discoverer.EBSTargetDiscovererR12.discoverAppNodeTarget(Unknown Source)

              at oracle.apps.ebs.amp.oms.discovery.discoverer.EBSTargetDiscovererR12.discoverNodeSystem(Unknown Source)

              at oracle.apps.ebs.amp.oms.discovery.discoverer.AppsTargetDiscoverer.discoverEBSSystem(Unknown Source)

              at oracle.apps.ebs.amp.oms.discovery.discoverer.AppsTargetDiscoverer.startDiscovery(Unknown Source)

              at oracle.apps.ebs.amp.oms.discovery.discoverer.TargetDiscoverer.startDiscovery(Unknown Source)

              at oracle.apps.fnd.oam.em.onDemand.jobs.OAMRegisterEBSOD.discoverEBS(Unknown Source)

              ... 68 more

       

      ******

       

      ******Discovery Messages:

      • oracle.apps.fnd.oam.em.onDemand.jobs.OAMRegisterEBSOD._executeCommand: Starting...Time=Tue Jun 18 17:59:02 CDT 2013
      • oracle.apps.fnd.oam.em.sdk.srvc.connection.AppsDBConnectionService._sGetDatabaseConnection lTargetType=oracle_database

         Name=PREBS1 Type=oracle_database

      • oracle.apps.fnd.oam.em.sdk.srvc.connection.AppsDBConnectionService._sGetDatabaseConnection pUid=apps
      • oracle.apps.fnd.oam.em.sdk.srvc.connection.AppsDBConnectionService._sGetDatabaseConnection JDBC Url=jdbc:oracle:thin:@semebsr12db01.7-eleven.com.mx:1521:PREBS
      • oracle.apps.fnd.oam.em.sdk.srvc.connection.AppsDBConnectionService._sGetDatabaseConnection Successfully provided connection
      • oracle.apps.ebs.amp.oms.discovery.discoverer.TargetDiscoverer.startDiscovery In
      • oracle.apps.ebs.amp.oms.discovery.context.ContextSearchUtil.getEbsContextFiles Inside
      • oracle.apps.ebs.amp.oms.discovery.context.ContextSearchUtil.retrieveR12ContextFiles In
      • oracle.apps.ebs.amp.oms.discovery.context.ContextSearchUtil.checkForDuplicateContextFiles In
      • oracle.apps.ebs.amp.oms.discovery.context.ContextSearchUtil.checkForDuplicateContextFiles Out Successfully
      • oracle.apps.ebs.amp.oms.discovery.context.EbsR12ContextFile.initializeAppContext In
      • oracle.apps.ebs.amp.oms.discovery.context.EbsR12ContextFile.initializeAppContext Out Successfully
      • oracle.apps.ebs.amp.oms.discovery.context.EbsR12ContextFile.initializeDbContext In
      • oracle.apps.ebs.amp.oms.discovery.context.EbsR12ContextFile.initializeDbContext Out Successfully
      • oracle.apps.ebs.amp.oms.discovery.context.ContextSearchUtil.retrieveR12ContextFiles Out Successfull. Number of context files - 2
      • oracle.apps.ebs.amp.oms.discovery.context.ContextSearchUtil.getEbsContextFiles Out Successfully
      • oracle.apps.ebs.amp.oms.discovery.adaptor.EBSCustomizeAdaptor.getCustomization Inside
      • oracle.apps.ebs.amp.oms.discovery.adaptor.EBSCustomizeAdaptor.getCustomization Out successfully
      • oracle.apps.ebs.amp.oms.discovery.context.ContextSearchUtil.getDbInfo In side
      • oracle.apps.ebs.amp.oms.discovery.context.ContextSearchUtil.setDbProperties DBName=PREBS1  DBType=oracle_database  In
      • oracle.apps.ebs.amp.oms.discovery.context.ContextSearchUtil.setDbProperties Out Successfull
      • oracle.apps.ebs.amp.oms.discovery.context.ContextSearchUtil.getDbInfo Out successfully
      • oracle.apps.ebs.amp.oms.discovery.discoverer.AppsTargetDiscoverer Inside constructor
      • oracle.apps.ebs.amp.oms.discovery.discoverer.AppsTargetDiscoverer Out constructor
      • oracle.apps.ebs.amp.oms.discovery.discoverer.TargetDiscoverer.startDiscovery ----------------- Existing Targets -----------------
      • oracle.apps.ebs.amp.oms.discovery.discoverer.TargetDiscoverer.startDiscovery ---------------------------------
      • oracle.apps.ebs.amp.oms.discovery.discoverer.AppsTargetDiscoverer.startDiscovery In
      • oracle.apps.ebs.amp.oms.discovery.discoverer.EBSTargetDiscovererR12.initializeEbsInstance In
      • oracle.apps.ebs.amp.oms.discovery.instCreate.EbsInstanceCreator.createInstance In
      • oracle.apps.ebs.amp.oms.discovery.instCreate.EbsR12InstanceCreator.createAppNodeinstance In(ContextName=PREBS_semebsr12apl01)
      • oracle.apps.ebs.amp.oms.discovery.instCreate.EbsR12InstanceCreator.createAppNodeinstance Out Successfull
      • oracle.apps.ebs.amp.oms.discovery.instCreate.EbsInstanceCreator.createInstance Out Successfull
      • oracle.apps.ebs.amp.oms.discovery.discoverer.EBSTargetDiscovererR12.initializeEbsInstance Out Successfull
      • oracle.apps.ebs.amp.oms.discovery.discoverer.AppsTargetDiscoverer.discoverEBSSystem In
      • oracle.apps.ebs.amp.oms.discovery.discoverer.EBSTargetDiscovererR12.discoverNodeSystem In
      • oracle.apps.ebs.amp.oms.discovery.discoverer.EBSTargetDiscovererR12.discoverAppNodeTarget In
      • oracle.apps.ebs.amp.oms.discovery.discoverer.AppsTargetDiscoverer.getAgentUrl In MonitoringHost=semebsr12apl01.7-eleven.com.mx
      • oracle.apps.ebs.amp.oms.discovery.discoverer.AppsTargetDiscoverer.getAgentUrl Out Successfull
      • oracle.apps.ebs.amp.oms.discovery.discoverer.EBSTargetDiscovererR12.discoverIASTargets In AppNode Name=PREBS-Infrastructure PREBS_semebsr12apl01-APPL_TOP Context HostName=semebsr12apl01.7-eleven.com.mx AgentURL=https://semebsr12apl01.7-eleven.com.mx:3872/emd/main/
      • oracle.apps.fnd.oam.em.onDemand.jobs.OAMRegisterEBSOD._executeCommand: Tue Jun 18 17:59:03 CDT 2013 Duration(sec))=1
      • oracle.apps.fnd.oam.em.onDemand.jobs.OAMRegisterEBSOD._executeCommand: calling toFileDiscoveryLog


       

      I haven't applied any patch to OMS environment and seems that I am missing one

       

      Has anybody had this error or problem before?

       

      We are running everything on Linux 5.9 64 bits with Oracle database 11.2.0.3 version.

       

      Any help or advice will be really appreciated.

       

      Thanks in advance.

       

      Francisco Mtz.