I have installed SOA Suite and OSB several times but never observed an issue with soa-infra. I used Oracle DB Enterprise Edition in all these installations.
Today i have tried with SOA Suite 11.1.1.4 installation with XE database as i was just preparing an environment for developers for their practice. But observed an issue with soa-infra in EM console which showing it as down. So went to deployments in weblogic admin console and verified the status of soa-infra application and found it in ‘Failed’ status. So the first thing i tried out was starting the soa-infra from deployments section in admin console. When i did this, i encountered the following error:
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
Solution:
- Do ‘grant execute on dbms_lob to public’ in sqlplus using sys login.
- Recompile the package DEV_MDS.MDS_INTERNAL_SHREDDED
Restart the server and verify that soa-infra is in Active status now. If the issue is not resolved drop the schema and recreate using the RCU. But before recreating, make sure that following environment variable is set when using XE database.
set RCU_JDBC_TRIM_BLOCKS=TRUE
Siva's Blog 
I have a two node SOA Cluster environment. The Admin server is shared on both nodes as a service. The Managed servers and Soa_composites are up and running on both nodes. For some reason, the soa_infra (soa_server1) folder is missing on the FMW console. Can someone please help me to get this solved?
Do you mean that you are not able to soa-infra in EM console? did you verify the deployments in Admin console and targets for soa-infra webapp
There is a problem in em console. Soa-infra not showing in em console…
Hi siva
i have tried with SOA Suite 11.1.1.5installation with XE database as i was just preparing an environment for developers for their practice. But observed an issue with soa-infra in EM console which showing it as down. So went to deployments in weblogic admin console and verified the status of soa-infra application and found it in ‘new’ status.can you please help to me. what should i do
log would be of help here…any logs?
Hi Siva,
Thanks for solution. I tried recomiling, and then dropping the entire schema and recreated using RCU.bat. Even i tried compiling using JDev as well. its giving me 3 packages compiled with 6 errors.
Nothing worked for me. Any other alternatives.
Regards,
Sudheer
Recompilation should do. Check the dependencies among these 3 packages and compile them accordingly. i.e first compile the package that does not have dependencies first and then proceed to other packages.
I had the same issue, and tried your method, but I got compile error:
SQL> alter package MDS_INTERNAL_SHREDDED compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY MDS_INTERNAL_SHREDDED:
LINE/COL ERROR
——– —————————————————————–
113/2 PLS-00103: Encountered the symbol “DZYSB0DKL”
113/39 PLS-00103: Encountered the symbol “=” when expecting one of the
following:
. ( , * @ % & – + / at mod remainder rem
as
from into || bulk
Also, I’ve re-run rcu several times by drop and create the databases, and that environment variable was always set to true before I run rcu.
Do you have any other suggestions? Thanks a lot,
There are two packages which will be shown as the invalid, if we see it through database navigator of jdev. compiling both of them will do.