This article is about to discuss an issue I faced during starting of SOA18.104.22.168 server on top of XE database.
After installing SOA 22.214.171.124 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 126.96.36.199 is installed on XE database and when we start admin server/managed server
This error is specific to XE db
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
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