ORA-12519 TNS No Appropriate Service Handler Found When More Than One WebCenter Managed Server Is Started (Doc ID 1500879.1)

Last updated on AUGUST 07, 2017

Applies to:

Oracle WebCenter Portal - Version 11.1.1.6.0 and later
Information in this document applies to any platform.
Checked for relevance on 25-Mar-2014

Symptoms

After installing a new 11.1.1.6 WebCenter setup we can only start one managed server at a time. Otherwise we see errors like the following in the logs:

"...
[2012-10-22T11:36:24.332-04:00] [WC_Portlet] [NOTIFICATION] [] [oracle.adf.share.config.MDSConfigFactory] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [ecid: 0000Je97M076UOB_BXfd6h1GXMV2000002,0] [APP: wsm-pm] [[
oracle.adf.share.ADFShareException: MDSConfigurationException encountered in parseADFConfiguration
at oracle.adf.share.config.ADFMDSConfig.createMDSInstanceFromelement(ADFMDSConfig.java:261)
at oracle.adf.share.config.MDSConfigFactory.createApplication(MDSConfigFactory.java:123)
at oracle.adf.share.config.ADFConfigFactory.findOrCreateADFConfig(ADFConfigFactory.java:137)
at oracle.adf.share.config.ADFConfigFactory.findOrCreateADFConfig(ADFConfigFactory.java:78)
at oracle.adf.share.config.ADFConfigFactory.findOrCreateADFConfig(ADFConfigFactory.java:56)
at oracle.adf.share.ADFContext.getADFConfigEx(ADFContext.java:807)
at oracle.adf.share.ADFContext.getADFConfig(ADFContext.java:759)
at oracle.adf.share.config.ADFContextMDSConfigHelperImpl.getMDSInstance(ADFContextMDSConfigHelperImpl.java:277)
at oracle.adf.share.ADFContext.getMDSInstanceAsObject(ADFContext.java:1674)
at oracle.wsm.repository.mds.MDSInstanceFactory.getMDSInstance(MDSInstanceFactory.java:98)
at oracle.wsm.policymanager.bean.AbstractBean.getRepository(AbstractBean.java:350)
at oracle.wsm.policymanager.bean.AbstractBean.createSession(AbstractBean.java:233)
at oracle.wsm.policymanager.bean.UpgradeManagerBean.seedWSMPolicyRepository(UpgradeManagerBean.java:588)
at oracle.wsm.policymanager.web.PolicyManagerValidator.init(PolicyManagerValidator.java:113)
at weblogic.servlet.internal.StubSecurityHelper$ServletInitAction.run(StubSecurityHelper.java:283)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.StubSecurityHelper.createServlet(StubSecurityHelper.java:64)
at weblogic.servlet.internal.StubLifecycleHelper.createOneInstance(StubLifecycleHelper.java:58)
at weblogic.servlet.internal.StubLifecycleHelper.(StubLifecycleHelper.java:48)
at weblogic.servlet.internal.ServletStubImpl.prepareServlet(ServletStubImpl.java:539)
at weblogic.servlet.internal.WebAppServletContext.preloadServlet(WebAppServletContext.java:1981)
at weblogic.servlet.internal.WebAppServletContext.loadServletsOnStartup(WebAppServletContext.java:1955)
at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1874)
at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:3154)
at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1518)
at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:484)
at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
at weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:200)
at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:247)
at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:27)
......
Caused by: oracle.mds.config.MDSConfigurationException: MDS-01330: unable to load MDS configuration document

MDS-01329: unable to load element "persistence-config"
MDS-01370: MetadataStore configuration for metadata-store-usage "OWSM_TargetRepos" is invalid.
MDS-01377: Unable to get database connection from data source configured with JNDI name "jdbc/mds/owsm".
weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
....
at oracle.mds.config.PConfig.loadFromBean(PConfig.java:959)
at oracle.mds.config.PConfig.(PConfig.java:758)
at oracle.mds.config.MDSConfig.loadFromBean(MDSConfig.java:787)
at oracle.mds.config.MDSConfig.loadFromElement(MDSConfig.java:848)
at oracle.mds.config.MDSConfig.(MDSConfig.java:491)
at oracle.mds.core.MDSInstance.getMDSConfigFromDocument(MDSInstance.java:2690)
at oracle.mds.core.MDSInstance.findAndStoreMDSInstanceWithCustConfig(MDSInstance.java:2523)
at oracle.mds.core.MDSInstance.getOrCreateInstanceInternal(MDSInstance.java:2031)
at oracle.mds.core.MDSInstance.getOrCreateInstance(MDSInstance.java:740)
at oracle.adf.share.config.ADFMDSConfig.createMDSInstanceFromelement(ADFMDSConfig.java:245)
... 54 more
Caused by: oracle.mds.exception.MDSExceptionList: MDS-01329: unable to load element "persistence-config"
MDS-01370: MetadataStore configuration for metadata-store-usage "OWSM_TargetRepos" is invalid.
MDS-01377: Unable to get database connection from data source configured with JNDI name "jdbc/mds/owsm".
weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
 
at oracle.mds.config.PConfig.loadFromBean(PConfig.java:953)
... 63 more

..."


The Database Alert.log shows:

Error Description: ORA-00020: maximum number of processes (%s) exceeded


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms