In case you face any issues with file based MDS, you may configure adf-config.xml  with entries like below to resolve the issue.



        <metadata-namespaces>
          <namespace path="/soa/shared" metadata-store-usage="mstore-usage_1"/>
          <namespace path="/apps" metadata-store-usage="mstore-usage_2"/>
        </metadata-namespaces>
        <metadata-store-usages>
          <metadata-store-usage id="mstore-usage_1">
            <metadata-store class-name="oracle.mds.persistence.stores.file.FileMetadataStore">
              <property name="metadata-path"
                        value="${oracle.home}/integration"/>
              <property name="partition-name" value="seed"/>
            </metadata-store>
          </metadata-store-usage>
        <metadata-store-usage id="mstore-usage_2">
            <metadata-store class-name="oracle.mds.persistence.stores.file.FileMetadataStore">
              <property name="metadata-path"
                        value="${oracle.home}/integration"/>
              <property name="partition-name" value="seed"/>
            </metadata-store>
          </metadata-store-usage>
        </metadata-store-usages>

WLST Script to export all SOA composites in one go

1) List all composites

   Connect to WLST  and run following WLST command to list all composites.

   sca_listDeployedComposites(host, port, user, password)

2) Save the output of step 1) to a .txt file ( example : list_of_composites_soa_11g.txt )

3) Create .py file with following content ( file name : import_all_soa_composites_jar_files.py )

 and run wlst to export all SOA Composites : /u01/app/oracle/fmw/12.2/soa/common/bin/wlst.sh import_all_soa_composites_jar_files.py

[oracle@integration ~]$ more import_all_soa_composites_jar_files.py
from java.io import FileInputStream
from java.lang import *
from java.util import Date
from java.util import HashMap
from java.lang import Runtime
from java.util import Arrays
from java.lang import System

f = open("list_of_composites_soa_11g.txt", "r")
for composite in f:
    composite_name = composite.split('[')[0]
    rev_number_temp = composite.split('[')[1]
    rev_number = rev_number_temp.split(']')[0]
    connect('weblogic', 'welcome1', 'localhost:8001')
    soa_composite_name = composite_name+"_rev"+rev_number+".jar"
    print(soa_composite_name)
    print(rev_number)
    sca_exportComposite('http://localhost:8001', 'all', soa_composite_name, composite_name, rev_number, user='weblogic', password='welcome1')
[oracle@integration ~]$