After I’ve downloaded and installed Oracle SOA Suite 11g, I relyezed very quickly that I forgot to set one important parameter.
When trying to start the manage server I got the following error:
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”
This error happened because I used Oracle Database 11g Express Edition, and I should have set the RCU_JDBC_TRIM_BLOCKS environment variable to TRUE
To see exactly how to set this parameter, go the RCU installation.
I had to drop the RCU, set the parameter and run the RCU installation again.
It took me 10 minutes and turned out to work just fine.
Thanks a ton, this totally helped 🙂