Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Changes in This Release for Oracle Services for Microsoft Transaction Server Developer's Guide

• Changes in Oracle Database 12c Release 1 (12.1)

1 Using Microsoft Transaction Server with Oracle Database

• Microsoft Transaction Server Overview
• Microsoft Transaction Server and Oracle Integration Overview
  • Oracle Services for Microsoft Transaction Server Support for DTC
  • Distributed Transactions on Real Application Clusters (Oracle RAC)
  • Promotable Local Transactions
  • Read-Committed and Serializable Transactions
• Getting Started with Microsoft Transaction Server and Oracle

2 Installing Oracle Services for Microsoft Transaction Server

• Installation Introduction
• Installation Requirements for Microsoft Transaction Server
  • Oracle Products
  • Non-Oracle Products
• Using Oracle Services for MTS with Oracle Data Provider for .NET, Managed Driver
• Manually Creating an Oracle MTS Recovery Service

3 Managing Recovery Scenarios

• Microsoft Transaction Server Configuration Requirements
• Microsoft Transaction Server Transaction Recovery Overview
• Scheduling Automatic Microsoft Transaction Server Transaction Recovery
  • Creating an Access Control List (ACL)
  • Configuring Automatic Transaction Recovery
    • Setting and Starting Up Database Job-Queue Processes
    • Creating and Scheduling Automatic Transaction Recovery
• Viewing Microsoft Transaction Server In-Doubt Transactions
• Modifying Registry Values for Oracle Fail Safe Configurations

4 Programming with Microsoft Transaction Server and an Oracle Database

• COM Component Integration in a Transaction
• Microsoft Transaction Server Application Development
  • Microsoft Transaction Server Component Registration
    • Types of Registration Components
    • Registration of Components
  • Microsoft Transaction Server-Coordinated Component Transaction
  • Microsoft DTC-Coordinated Component Transaction
• OCI Integration with Microsoft Transaction Server
  • Integrating COM Components
    • COM Components Running in an MTS-Coordinated Transaction
    • Non-Transactional COM Components Running with OCI Connection Pooling
    • COM Components Using MS DTC and OCI Connection Pooling
    • COM Components Using MS DTC and Nonpooling OCI Connection
  • Using OCI Functions
  • OraMTSSvcGet()
  • OraMTSSvcRel()
  • OraMTSSvcEnlist()
  • OraMTSSvcEnlistEx()
  • OraMTSEnlCtxGet()
  • OraMTSEnlCtxRel()
  • OraMTSJoinTxn()
  • OraMTSTransTest()
  • OraMTSOCIErrGet()
• ODBC Integration with Microsoft Transaction Server Overview
  • Setting the Connection Attribute
  • Using Oracle ODBC Driver
  • Using Microsoft Oracle ODBC Driver

5 Tuning Microsoft Transaction Server Performance

• Improving Microsoft Transaction Server Application Performance
• Managing Microsoft Transaction Server Connections
  • Connection Pooling Registry Parameters
• Increasing the Transaction Timeout Parameter
• Changing Initialization Parameter Settings
• Additional Parameters
• Starting MSDTC

6 Troubleshooting Oracle Microsoft Transaction Server

• Tracking Oracle Services for Microsoft Transaction Server Performance
• Correcting Oracle Net Changes that Impact Connection Pooling
• Designing an Application that Uses Multiple Databases
• Working with Different Types of Connection Pooling
• Working with In-Doubt Transactions
• Dropping the Microsoft Transaction Server Administrative User Account

Glossary

Index