Search This Blog

Steps to clear ORA-04063: package body "DEV_MDS.MDS_INTERNAL_SHREDDED" Error

Steps to clear ORA-04063: package body  "DEV_MDS.MDS_INTERNAL_SHREDDED"  Error

Most of the time when you created SOA_Server "DEV_MDS.MDS_INTERNAL_SHREDDED"  error occur due to incomplete installation on RCU creation ( no need to Drop and create new Schema ).

Error Statement : 

<BEA-149205> <Failed to initialize the application 'soa-infra' due to error 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"
ORA-06512: at line 1
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"
ORA-06512: at line 1
at oracle.mds.config.PConfig.loadFromBean(PConfig.java:684)
at oracle.mds.config.PConfig.loadFromBean(PConfig.java:517)
at oracle.mds.config.PConfig.<init>(PConfig.java:341)

Stop all your Server including Admin server and managed node server SOA_server1.

To clear this above Error , recompile DEV_MDS scheme , open SQL Developer  :

username : DEV_MDS
Password : *******

Compile all the package. Start admin server and Soa_server1 .

Error cleared ..