12 Replies Latest reply: Sep 12, 2012 2:30 AM by User129 RSS

    Oracle 11g(11.1.1.6) SOA Domain creation failed

    805618
      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--Oracle
          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
            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
              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
                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
                  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--Oracle
                    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
                      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--Oracle
                        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
                          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
                            Ravi Jegga
                            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
                              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
                                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