This article is about to discuss an issue I faced during starting of SOA11.1.1.4 server on top of XE database.
After installing SOA 11.1.1.4 on top of XE database and when I start admin server I started seeing below error message.
One more indication which confirms this issue is when we create a connection in Jdev we can not see any MDS partitions to connect to the server.
Circumstance: When SOA 11.1.1.4 is installed on XE database and when we start admin server/managed server
This error is specific to XE db
Error
Caused By: oracle.mds.exception.MDSExceptionList: MDS-01329: unable to load element "persistence-config"
MDS-01370: MetadataStore configuration for metadata-store-usage "soa-infra-store" is invalid.
ORA-04063: package body "DEV_MDS.MDS_INTERNAL_SHREDDED" has errors
ORA-06508: PL/SQL: could not find program unit being called: "DEV_MDS.MDS_INTERNAL_SHREDDED"
If you try to compile above procedure and if error is
Error(1): PLS-00753: malformed or corrupted wrapped unit, then you can simply apply below solution
Solution:
1) Use RCU to drop the SOA Suite schemas and tablespaces
2) Set the environmental variable RCU_JDBC_TRIM_BLOCKS=TRUE and then run RCU again to re-create the SOA Suite schemas and tablespaces
I faced this problem after installing the SOA suite 11.1.1.4. I also tried dropping the schemas using RCU and setting the enviornment variable and recreating the schemas. Still I face the same error and soa-infra is showing as down in EM console. Any help?
ReplyDeletePraveen, any idea where does the compoiste get stored in 11g? In 10g, there used to be separate tables that used to store BPEL Process meta-data and suite-case jar files.
ReplyDeleteDid not find any such thing in 11g.
Thanks in advance for your help.
Ashish
Thank you!
ReplyDeleteThat worked for me: Windows 7, Oracle XE 10.2.0.1.0
This blog is great. It solved my issue. Worked on windows 7
ReplyDeleteThanks
Thank you so much !
ReplyDeleteIt worked for me on Windows 7 professional, Oracle XE
Thank you a lot.
ReplyDeleteIt worked for me on Windows 7 professional 64bit, Oracle XE.
Hi,
ReplyDeleteI am getting the same error..but I have already set the RCU JDBC to TRUE followed the oracle user guide..I can understand the problem what I am facing can be fixed by connecting to the MDS from SQL, developer when trying to install SQL developer on windows 7 64 Bit and OracleXEUniv..suggest me the link from where and and which one should be downloaded also let me the the jdk downloading,looking forward for your reply.
error log file : Started: ADF Library non-ADFJspResourceProvider post-deployment
Finished: ADF Library non-ADFJspResourceProvider post-deployment (millis): 63
(PConfig.java:499)
at oracle.mds.config.MDSConfig.loadFromBean(MDSConfig.java:707)
at oracle.mds.config.MDSConfig.loadFromElement(MDSConfig.java:764)
at oracle.mds.config.MDSConfig.(MDSConfig.java:420)
at oracle.mds.core.MDSInstance.getMDSConfigFromDocument(MDSInstance.java
:2055)
at oracle.mds.core.MDSInstance.createMDSInstanceWithCustomizedConfig(MDS
Instance.java:1197)
at oracle.mds.core.MDSInstance.getOrCreateInstance(MDSInstance.java:580)
at oracle.adf.share.config.ADFMDSConfig.createMDSInstanceFromelement(ADF
MDSConfig.java:243)
at oracle.adf.share.config.MDSConfigFactory.createApplication(MDSConfigF
actory.java:123)
at oracle.adf.share.config.ADFConfigFactory.findOrCreateADFConfig(ADFCon
figFactory.java:142)
at oracle.adf.share.config.ADFConfigFactory.findOrCreateADFConfig(ADFCon
figFactory.java:78)
at oracle.adf.share.config.ADFConfigFactory.findOrCreateADFConfig(ADFCon
figFactory.java:56)
at oracle.adf.share.http.ServletADFContext.checkForUpdatesToADFConfig(Se
rvletADFContext.java:645)
at oracle.adf.share.http.ServletADFContext.initialize(ServletADFContext.
java:443)
at oracle.adf.share.http.ServletADFContext.initThreadContext(ServletADFC
ontext.java:395)
at oracle.adf.mbean.share.config.ADFConfigLifeCycleCallBack.contextIniti
alized(ADFConfigLifeCycleCallBack.java:97)
at weblogic.servlet.internal.EventsManager$FireContextListenerAction.run
(EventsManager.java:481)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Authenticate
dSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:
120)
at weblogic.servlet.internal.EventsManager.notifyContextCreatedEvent(Eve
ntsManager.java:181)
at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAp
pServletContext.java:1872)
at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletCon
text.java:3153)
at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.jav
a:1508)
at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:482)
at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleSta
teDriver.java:425)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineD
river.java:52)
at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStat
eDriver.java:119)
at weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedMod
uleDriver.java:200)
at weblogic.application.internal.flow.ModuleListenerInvoker.start(Module
ListenerInvoker.java:247)
at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleSta
teDriver.java:425)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineD
river.java:52)
at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStat
at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleSta
DeleteteDriver.java:425)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineD
river.java:52)
at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStat
eDriver.java:119)
at weblogic.application.internal.flow.StartModulesFlow.activate(StartMod
ulesFlow.java:27)
at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.ja
va:636)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineD
river.java:52)
at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.
java:205)
at weblogic.application.internal.EarDeployment.activate(EarDeployment.ja
va:58)
at weblogic.application.internal.DeploymentStateChecker.activate(Deploym
entStateChecker.java:161)
at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(Ap
pContainerInvoker.java:79)
at weblogic.deploy.internal.targetserver.BasicDeployment.activate(BasicD
eployment.java:184)
at weblogic.deploy.internal.targetserver.BasicDeployment.activateFromSer
verLifecycle(BasicDeployment.java:361)
at weblogic.management.deploy.internal.DeploymentAdapter$1.doActivate(De
ploymentAdapter.java:51)
at weblogic.management.deploy.internal.DeploymentAdapter.activate(Deploy
mentAdapter.java:200)
at weblogic.management.deploy.internal.AppTransition$2.transitionApp(App
Transition.java:30)
at weblogic.management.deploy.internal.ConfiguredDeployments.transitionA
pps(ConfiguredDeployments.java:240)
at weblogic.management.deploy.internal.ConfiguredDeployments.activate(Co
nfiguredDeployments.java:169)
at weblogic.management.deploy.internal.ConfiguredDeployments.deploy(Conf
iguredDeployments.java:123)
at weblogic.management.deploy.internal.DeploymentServerService.resume(De
ploymentServerService.java:180)
at weblogic.management.deploy.internal.DeploymentServerService.start(Dep
loymentServerService.java:96)
at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
>
Thread[[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tun
ing)',5,Pooled Threads]: CompressionFilter: Using debug = (0)
PostInstallConfigIntegration:oracle_ias_farm target auth registration is done.