Contents

List of Examples

List of Figures

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Using Microsoft Transaction Server with Oracle Database

• 1.1 Microsoft Transaction Server Overview
• • 1.1.1 Oracle Services for Microsoft Transaction Server Support for Serializable Transactions
  • 1.1.2 Oracle Services for Microsoft Transaction Server Support for DTC
• 1.2 Microsoft Transaction Server and Oracle Integration Overview
• 1.3 Getting Started with Microsoft Transaction Server and Oracle

2 Installing and Migrating Oracle Products

• 2.1 Installing Oracle Services for Microsoft Transaction Server
• • 2.1.1 Installation Requirements for Microsoft Transaction Server
  • • 2.1.1.1 Oracle Products
    • 2.1.1.2 Non-Oracle Products
  • 2.1.2 Installation Requirements for Oracle Database
  • • 2.1.2.1 Oracle Products
    • 2.1.2.2 Non-Oracle Products
• 2.2 Upgrading Oracle Services for Microsoft Transaction Server
• • 2.2.1 Deleting OraMTS with Oracle Manager for MTS Services
  • • 2.2.1.1 Stopping OraMTS
    • 2.2.1.2 Stopping and Restarting the Database
    • 2.2.1.3 Restarting the OraMTS
    • 2.2.1.4 Monitoring the OraMTS Trace Files
    • 2.2.1.5 Deleting OraMTS Table Information
    • 2.2.1.6 Deleting the OraMTS
• 2.3 Deleting Roles and Privileges of an Inactive OraMTS User
• 2.4 Deleting Oracle Services for Microsoft Transaction Server Manually
• • 2.4.1 Manually Deleting Oracle Services for Microsoft Transaction Server with the Registry
  • 2.4.2 Deleting the OracleMTSServicen 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 Setting and Starting Up Database Job-Queue Processes
  • 3.3.2 Creating and Scheduling Automatic Transaction Recovery
  • • 3.3.2.1 utl_oramts.show_indoubt Procedure
    • 3.3.2.2 utl_oramts.recover_automatic Procedure
    • 3.3.2.3 utl_oramts.forget_RMs Procedure
    • 3.3.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 Running the Microsoft Application Demo

• 4.1 Configuring Oracle Call Interface with the Microsoft Application Demo
• • 4.1.1 Microsoft Application Demo Overview
  • 4.1.2 Ensuring the Database Includes the Proper Microsoft Application Demo Tables
  • 4.1.3 Running the Microsoft Application Demo
• 4.2 Configuring Oracle ODBC Driver with the Microsoft Application Demo
• 4.3 Configuring Oracle Provider for OLE DB with the Microsoft Application Demo

5 Programming with Microsoft Transaction Server and an Oracle Database

• 5.1 COM Component Integration in a Transaction
• 5.2 Microsoft Transaction Server Application Development
• • 5.2.1 Microsoft Transaction Server Component Registration
  • • 5.2.1.1 Types of Registration Components
    • 5.2.1.2 Registration of Components
  • 5.2.2 Microsoft Transaction Server-Coordinated Component Transaction
  • 5.2.3 Microsoft DTC-Coordinated Component Transaction
• 5.3 OCI Integration with Microsoft Transaction Server
• • 5.3.1 Integrating COM Components
  • • 5.3.1.1 COM Components Running in an MTS-Coordinated Transaction
    • 5.3.1.2 Non-Transactional COM Components Running with OCI Connection Pooling
    • 5.3.1.3 COM Components Using MS DTC and OCI Connection Pooling
    • 5.3.1.4 COM Components Using MS DTC and Nonpooling OCI Connection
  • 5.3.2 Using OCI Functions
  • 5.3.3 OraMTSSvcGet()
  • 5.3.4 OraMTSSvcRel()
  • 5.3.5 OraMTSSvcEnlist()
  • 5.3.6 OraMTSSvcEnlistEx()
  • 5.3.7 OraMTSEnlCtxGet()
  • 5.3.8 OraMTSEnlCtxRel()
  • 5.3.9 OraMTSJoinTxn()
  • 5.3.10 OraMTSTransTest()
  • 5.3.11 OraMTSOCIErrGet()
• 5.4 ODBC Integration with Microsoft Transaction Server Overview
• • 5.4.1 Setting the Connection Attribute
  • 5.4.2 Using Oracle ODBC Driver
  • 5.4.3 Using Microsoft Oracle ODBC Driver

6 Tuning Microsoft Transaction Server Performance

• 6.1 Improving Microsoft Transaction Server Application Performance
• 6.2 Managing Microsoft Transaction Server Connections
• • 6.2.1 Connection Pooling Registry Parameters
• 6.3 Increasing the Transaction Timeout Parameter
• 6.4 Changing Initialization Parameter Settings
• 6.5 Starting MSDTC

7 Troubleshooting Oracle Microsoft Transaction Server

• 7.1 Tracking Oracle Services for Microsoft Transaction Server Performance
• 7.2 Correcting Windows Explorer Problems
• 7.3 Correcting Oracle Net Changes that Impact Connection Pooling
• 7.4 Designing an Application that Uses Multiple Databases
• 7.5 Working with Different Types of Connection Pooling
• 7.6 Working with In-Doubt Transactions
• 7.7 Dropping the Microsoft Transaction Server Administrative User Account

Glossary

Index