Advertisements



SOA-INFRA Issue

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

Advertisements

9 Responses to “SOA-INFRA Issue”


  1. 1 Hadi February 2, 2016 at 9:34 PM

    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?

  2. 3 mybujji December 19, 2015 at 7:00 PM

    There is a problem in em console. Soa-infra not showing in em console…

  3. 4 Anonymous March 5, 2014 at 1:53 AM

    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

  4. 6 Sudheer September 4, 2012 at 4:27 PM

    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

    • 7 svgonugu September 4, 2012 at 5:52 PM

      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.

  5. 8 Cindy May 24, 2012 at 2:15 AM

    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,


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




Advertisements

Pages

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 341 other followers

Enter your email address to follow this blog and receive notifications of new posts by email.