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.

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)

Applies to:

Goal

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!