This discussion is archived
12 Replies Latest reply: Sep 12, 2012 12:30 AM by User129 RSS

Oracle 11g(11.1.1.6) SOA Domain creation failed

805618 Newbie
Currently Being Moderated
Hi ,

I am new to SOA .I have downloaded s/w from OTN (ORACLE) site .I have followed the quick start guide for installation .Everything went well

I have successfully installed oracle XE ,weblogic server,OEPE,RCU,OracleServiceBus.

When I try to create a Soa domain.I am getting following exception

Preparing...
Extracting Domain Contents...
Creating Domain Security Information...
Domain Creation Failed!

Domain Location: C:\demos\domains\SOAOSBPS4DevDomain

Reason: null

Exception:

Traceback (innermost last):
File "<iostream>", line 6, in ?
File "<iostream>", line 21, in cd
     at com.oracle.cie.domain.script.jython.CommandExceptionHandler.handleException(CommandExceptionHandler.java:51)

     at com.oracle.cie.domain.script.jython.WLScriptContext.handleException(WLScriptContext.java:1538)

     at com.oracle.cie.domain.script.jython.WLScriptContext.cd(WLScriptContext.java:602)

     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

     at java.lang.reflect.Method.invoke(Method.java:597)


com.oracle.cie.domain.script.jython.WLSTException: com.oracle.cie.domain.script.jython.WLSTException: com.oracle.cie.domain.script.ScriptException: No nested element JDBCDriverParams is found

I have selected converttoRACMultiDatasource radio button

If I dont select that radion button Soa domain is getting created successfully

Can anyone please let me know what could be the problem

Thanks
  • 1. Re: Oracle 11g(11.1.1.6) SOA Domain creation failed
    Anuj Dwivedi Guru
    Currently Being Moderated
    I have selected converttoRACMultiDatasource radio button
    You need to select this option only when you are using RAC (Real Application Clusters) database for storing design and runtime information (MDS and SOAINFRA schema's) which is generally used for production installations. As you are doing a local/developer installation, you should not select this option.

    Regards,
    Anuj
  • 2. Re: Oracle 11g(11.1.1.6) SOA Domain creation failed
    805618 Newbie
    Currently Being Moderated
    Thanks a lot anuj .SOA Domain gets created successfully but I ran into a problem when I run the server

    Caused By: oracle.mds.exception.MDSExceptionList: MDS-01329: unable to load elem
    ent "persistence-config"
    MDS-01370: MetadataStore configuration for metadata-store-usage "OWSM_TargetRepo
    s" 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_INTERN
    AL_SHREDDED"
    ORA-06512: at line 1


    at oracle.mds.config.PConfig.loadFromBean(PConfig.java:953)
    at oracle.mds.config.PConfig.<init>(PConfig.java:758)
    at oracle.mds.config.MDSConfig.loadFromBean(MDSConfig.java:787)
    at oracle.mds.config.MDSConfig.loadFromElement(MDSConfig.java:848)
    at oracle.mds.config.MDSConfig.<init>(MDSConfig.java:491)
    Truncated. see log file for complete stacktrace
    >


    Ive adjusted processes=500
    and Ive set the RCU_JDBC_TRIM_BLOCKS environment variable to TRUE prior to running RCU.
    set RCU_JDBC_TRIM_BLOCKS=TRUE
    echo %RCU_JDBC_TRIM_BLOCKS%

    Can anybody suggest what went wrong
  • 3. Re: Oracle 11g(11.1.1.6) SOA Domain creation failed
    veejai24 Pro
    Currently Being Moderated
    Check your adf-config.xml file to see whether the MDS configuration is proper or not.

    Check this aswell

    http://blog.ipnweb.com/2011/02/upgast-02003-and-mds-00912-when-running.html

    Thanks,
    Vijay
  • 4. Re: Oracle 11g(11.1.1.6) SOA Domain creation failed
    805618 Newbie
    Currently Being Moderated
    Hi Vijay

    I have checked the post and tested the same on my installation everything looks right

    SQL> SELECT comp_id, comp_name, version, status, mrc_name, owner FROM schema_ver
    sion_registry;

    COMP_ID
    ------------------------------
    COMP_NAME
    --------------------------------------------------------------------------------

    VERSION STATUS MRC_NAME
    ------------------------------ ----------- ------------------------------
    OWNER
    ------------------------------
    BAM
    BAM Services
    11.1.1.5.0 VALID DEV
    DEV_ORABAM


    COMP_ID
    ------------------------------
    COMP_NAME
    --------------------------------------------------------------------------------

    VERSION STATUS MRC_NAME
    ------------------------------ ----------- ------------------------------
    OWNER
    ------------------------------
    MDS
    Metadata Services
    11.1.1.6.0 VALID DEV
    DEV_MDS


    COMP_ID
    ------------------------------
    COMP_NAME
    --------------------------------------------------------------------------------

    VERSION STATUS MRC_NAME
    ------------------------------ ----------- ------------------------------
    OWNER
    ------------------------------
    ORASDPM
    SDP Messaging
    11.1.1.6.0 VALID DEV
    DEV_ORASDPM


    COMP_ID
    ------------------------------
    COMP_NAME
    --------------------------------------------------------------------------------

    VERSION STATUS MRC_NAME
    ------------------------------ ----------- ------------------------------
    OWNER
    ------------------------------
    SOAINFRA
    SOA Infrastructure Services
    11.1.1.6.0 VALID DEV
    DEV_SOAINFRA

    can any body suggest what will be wrong.I have been on this issue since 2 weeks
  • 5. Re: Oracle 11g(11.1.1.6) SOA Domain creation failed
    veejai24 Pro
    Currently Being Moderated
    Make sure you have 'MDS_INTERNAL_SHREDDED' and OWSM_TargetRepo
    s under MDS schema.

    select * from all_objects where object_name like 'MDS_INTERNAL_SHREDDED';

    Otherwise you have re-run the RCU on XE.

    Thanks,
    Vijay
  • 6. Re: Oracle 11g(11.1.1.6) SOA Domain creation failed
    Anuj Dwivedi Guru
    Currently Being Moderated
    No need to recreate the schema's. You should be able to recompile the invalid DB object(s) using JDev, SqlDev. or manually through SQL client. Even if you don't find the objects in MDS schema, you may get the package spec and body from RCU installable and compile it in MDS schema -

    $RCU_HOME/rcu/integration/mds/sql/MDSINSRS.pls
    $RCU_HOME/rcu/integration/mds/sql/MDSINSRB.plb

    Regards,
    Anuj
  • 7. Re: Oracle 11g(11.1.1.6) SOA Domain creation failed
    805618 Newbie
    Currently Being Moderated
    Hi

    SQL> select * from all_objects where object_name like 'MDS_INTERNAL_SHREDDED';

    OWNER OBJECT_NAME
    ------------------------------ ------------------------------
    SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
    ------------------------------ ---------- -------------- -------------------
    CREATED LAST_DDL_ TIMESTAMP STATUS T G S
    --------- --------- ------------------- ------- - - -
    DEV_MDS MDS_INTERNAL_SHREDDED
    13699 PACKAGE
    25-MAY-12 25-MAY-12 2012-05-25:16:17:18 VALID N N N

    DEV_MDS MDS_INTERNAL_SHREDDED
    13702 PACKAGE BODY
    25-MAY-12 25-MAY-12 2012-05-25:16:17:18 INVALID N N N

    OWNER OBJECT_NAME
    ------------------------------ ------------------------------
    SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
    ------------------------------ ---------- -------------- -------------------
    CREATED LAST_DDL_ TIMESTAMP STATUS T G S
    --------- --------- ------------------- ------- - - -

    Here for Package body status is INVALID is this is causing the error

    Thanks
  • 8. Re: Oracle 11g(11.1.1.6) SOA Domain creation failed
    Anuj Dwivedi Guru
    Currently Being Moderated
    Here for Package body status is INVALID is this is causing the error
    Yes, this is causing issue. You may run below command (login as user DEV_MDS or as a sysdba) to recompile the package body-

    ALTER PACKAGE DEV_MDS.MDS_INTERNAL_SHREDDED COMPILE BODY;

    Regards,
    Anuj
  • 9. Re: Oracle 11g(11.1.1.6) SOA Domain creation failed
    805618 Newbie
    Currently Being Moderated
    I executed the query

    ALTER PACKAGE DEV_MDS.MDS_INTERNAL_SHREDDED COMPILE BODY;

    Warning: Package Body altered with compilation errors.

    But still problem does exists
  • 10. Re: Oracle 11g(11.1.1.6) SOA Domain creation failed
    RaviJegga Expert
    Currently Being Moderated
    Hi
    The error clearly indicates that these packages are NOT compiled. See the below post for quick fix. Instead of trying all the stuff, the quick way just run rcu, drop the schemas and recreate again AFTER setting this flag: RCU_JDBC_TRIM_BLOCKS=TRUE. See below post for details. It may take like 10 mts to drop and recreate the schemas again. You can reuse the same Domain.

    Re: SOA infra is falied

    Thanks
    Ravi Jegga
  • 11. Re: Oracle 11g(11.1.1.6) SOA Domain creation failed
    veejai24 Pro
    Currently Being Moderated
    Exactly as you are starting as fresh installation, you can drop the schemas and re-run the RCU it will save you lots of time.
    Make sure you follow all the installation requirements and dont ignore any exception that you get while installing RCU.

    Thanks,
    Vijay
  • 12. Re: Oracle 11g(11.1.1.6) SOA Domain creation failed
    User129 Explorer
    Currently Being Moderated
    this is perfect solution for me and hope it will help lot of people
    http://sathyam-soa.blogspot.com/2011/08/weblogic-11g-domain-creation-failed.html#comment-form

    Muhammad Nasir

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points