My Oracle Support Banner

How to Create SOA 11g Database Schemas in a Microsoft SQL Server (MS SQLServer) Database and Create a SOA Domain Using those Schemas (Doc ID 1400953.1)

Last updated on APRIL 12, 2024

Applies to:

Oracle SOA Suite - Version 11.1.1.1.0 and later
Information in this document applies to any platform.

Goal

This document describes step-by-step how to create SOA 11g database schemas in a Microsoft SQL Server (MS SQLServer) database using the Repository Creation Utility (RCU). Also, it shows how to create a SOA domain using the schemas created earlier.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Creating SOA Schemas in a Microsoft SQL Server Database using RCU
 1. Make sure that the database version used is certified. Information is available in the following documentation:
 2. Create a database in your SQLServer to hold your SOA schemas.
 Set READ_COMMITTED_SNAPSHOT to ON
 Alter Database to Apply the Correct Collate to the Database
 Run RCU to Create Schemas
 XA Configuration Required to Start the SOA Infrastructure on Microsoft SQL Server
 Configuring a SOA Domain Using the Schemas Created Earlier
 Check Release Notes and Implement Recommended Workaround
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.