Table of Contents

• List of Figures
• List of Tables
• 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 Services for Microsoft Transaction Server in ODAC 12c Release 3
    • New Features
  • Changes in Oracle Database 12c Release 1 (12.1)
    • New Features
• 1 Using Microsoft Transaction Server with Oracle Database
  • 1.1 Microsoft Transaction Server Overview
  • 1.2 Microsoft Transaction Server and Oracle Integration Overview
    • 1.2.1 Oracle Services for Microsoft Transaction Server Support for DTC
    • 1.2.2 Distributed Transactions on Real Application Clusters (Oracle RAC)
    • 1.2.3 Promotable Local Transactions
    • 1.2.4 Read-Committed and Serializable Transactions
  • 1.3 Getting Started with Microsoft Transaction Server and Oracle
• 2 Installing Oracle Services for Microsoft Transaction Server
  • 2.1 Installation Introduction
  • 2.2 Installation Requirements for Microsoft Transaction Server
    • 2.2.1 Oracle Products
    • 2.2.2 Non-Oracle Products
  • 2.3 Using Oracle Services for MTS with Oracle Data Provider for .NET
  • 2.4 Manually Creating an Oracle MTS Recovery Service
• 3 Managing Recovery Scenarios
  • 3.1 Microsoft Transaction Server Configuration Requirements
  • 3.2 Microsoft Transaction Server Transaction Recovery Overview
  • 3.3 Scheduling Automatic Microsoft Transaction Server Transaction Recovery
    • 3.3.1 Creating an Access Control List (ACL)
    • 3.3.2 Configuring Automatic Transaction Recovery
      • 3.3.2.1 Setting and Starting Up Database Job-Queue Processes
      • 3.3.2.2 Creating and Scheduling Automatic Transaction Recovery
        • 3.3.2.2.1 utl_oramts.show_indoubt Procedure
        • 3.3.2.2.2 utl_oramts.recover_automatic Procedure
        • 3.3.2.2.3 utl_oramts.forget_RMs Procedure
        • 3.3.2.2.4 oramts_2pc_pending View
  • 3.4 Viewing Microsoft Transaction Server In-Doubt Transactions
  • 3.5 Modifying Registry Values for Oracle Fail Safe Configurations
• 4 Programming with Microsoft Transaction Server and an Oracle Database
  • 4.1 COM Component Integration in a Transaction
  • 4.2 Microsoft Transaction Server Application Development
    • 4.2.1 Microsoft Transaction Server Component Registration
      • 4.2.1.1 Types of Registration Components
      • 4.2.1.2 Registration of Components
    • 4.2.2 Microsoft Transaction Server-Coordinated Component Transaction
    • 4.2.3 Microsoft DTC-Coordinated Component Transaction
  • 4.3 OCI Integration with Microsoft Transaction Server
    • 4.3.1 Integrating COM Components
      • 4.3.1.1 COM Components Running in an MTS-Coordinated Transaction
      • 4.3.1.2 Non-Transactional COM Components Running with OCI Connection Pooling
      • 4.3.1.3 COM Components Using MS DTC and OCI Connection Pooling
      • 4.3.1.4 COM Components Using MS DTC and Nonpooling OCI Connection
    • 4.3.2 Using OCI Functions
    • 4.3.3 OraMTSSvcGet()
    • 4.3.4 OraMTSSvcRel()
    • 4.3.5 OraMTSSvcEnlist()
    • 4.3.6 OraMTSSvcEnlistEx()
    • 4.3.7 OraMTSEnlCtxGet()
    • 4.3.8 OraMTSEnlCtxRel()
    • 4.3.9 OraMTSJoinTxn()
    • 4.3.10 OraMTSTransTest()
    • 4.3.11 OraMTSOCIErrGet()
  • 4.4 ODBC Integration with Microsoft Transaction Server Overview
    • 4.4.1 Setting the Connection Attribute
    • 4.4.2 Using Oracle ODBC Driver
    • 4.4.3 Using Microsoft Oracle ODBC Driver
• 5 Tuning Microsoft Transaction Server Performance
  • 5.1 Improving Microsoft Transaction Server Application Performance
  • 5.2 Managing Microsoft Transaction Server Connections
    • 5.2.1 Connection Pooling Registry Parameters
  • 5.3 Increasing the Transaction Timeout Parameter
  • 5.4 Changing Initialization Parameter Settings
  • 5.5 Additional Parameters
  • 5.6 Starting MSDTC
• 6 Troubleshooting Oracle Microsoft Transaction Server
  • 6.1 Tracking Oracle Services for Microsoft Transaction Server Performance
  • 6.2 Correcting Oracle Net Changes that Impact Connection Pooling
  • 6.3 Designing an Application that Uses Multiple Databases
  • 6.4 Working with Different Types of Connection Pooling
  • 6.5 Working with In-Doubt Transactions
  • 6.6 Dropping the Microsoft Transaction Server Administrative User Account
• Glossary
• Index