Migrating the Metadata from SOA 10g to 11g and sharing the common artifacts to MDS Repository.

Migrating the Metadata from SOA 10g to 11g and sharing the common artifacts to Repository:

If we use the Domain Value Maps (DVMs) or Cross References in Oracle BPEL Process Manager 10g or Oracle Enterprise Service Bus 10g project, the Xpath functions used to access the domain value maps or cross references will be upgraded automatically when the projects are upgraded in Oracle JDeveloper 11g.

However, a manual upgrade task has to be performed to upgrade the domain value maps and cross references that are saved in the Oracle Enterprise Service Bus repository. Also, if we use the common schemas or WSDLs in 10g project the same should be migrated to MDS repository; in 11g all the common artifacts will be stored in MDS repository.

There is a lot of information for the same topic but thought of sharing my experience.

Below are the steps for migrating the DVMs and XREFs to 11g and also to create the project that will have all the common artifacts like DVM, XREF, WSDL and SCHEMAs that can be stored to MDS repository.

Export the DVM and XREF metadata from 10g server: (Steps should be executed on 10 g server)

1. Log on to your Oracle SOA Suite 10g server.
2. cd $ORACLE_HOME/integration/esb/bin
3. Set the environment - ./ esbsetenv.sh
4. Run the export.sh script to export the entire ESB metadata - ./export.sh metadata10g.zip.
5. Copy the metadata10g.zip file from $ORACLE_HOME\integration\esb\bin to the Oracle SOA 11g server.

Convert the ZIP file to an Oracle SOA Suite 11g archive file (Steps should be executed on 11g server) :

1. Log on to your Oracle SOA 11g server
2. Set your environment:

export DomainHome=<<Weblogic DomainHome>>

export OracleHome=<<OracleHome>>

cd $DomainHome/bin

. setDomainEnv.sh

3. Execute the below comments to convert the 10g metadata to 11g format.

cd $OracleHome/bin

ant -f ant-sca-upgrade.xml upgrade-xrefdvm -Dsource=<<Path to metadata10g.zip>> -Dtarget= <<Target path>>

4. Copy the archive sca_XrefDvmFiles10g_rev1.0.jar generated in target path to local machine.

Create the Metadata project:

• Create a new Generic Application (e.g. MetaDataApp) in JDeveloper 11g.
• Click “Next” and Give a Project Name e.g. Metadata.
• From the Oracle JDeveloper 11g “File” menu, select “Import”, then “SOA Archive into SOA Project”. In the Import Composite Archive Dialog Box, click Browse and locate the sca_XrefDvmFiles10g_rev1.0.jar file that you created previously.
• Make sure that the Project Name and Composite Name in the Create SOA Project from SOA Archive dialog box and Import Composite Archive Dialog Box have the same name.
• Click Finish to create the new SOA project. The new project consists of an empty composite, along with the upgraded Xref and DVM files.
• Crete new folders with the name Xref, dvm, faultpolicy, schemas and WSDL under SOAContent of the project folder based on the different type of artifacts needs to be stored in MDS.

• Group the dvm’s to dvm folder and the xref’s to Xref folder. By default all content is grouped in the project folder in the file system.

• Copy the common schemas from 10g to the schemas folder of Metadata project.

• Copy the common WSDL’s from 10g to the WSDL folder of Metadata project.

• Copy the fault Policy and fault binding files to faultpolices folder of MeatDataProject.

• Remove the folders those are not required like xsl, xsd, classes and testsuites from the Metadata project.

Now the metadata application is ready with all the common artifacts, create a metadata archive file and deploy the project to the server, the metadata can be referred in the Composite with the help of oramds protocol.