Contents

Beta Draft

Title and Copyright Information

Preface

Intended Audience

Documentation Accessibility

Related Documents

Conventions

1 Using Microsoft Transaction Server with Oracle Database

Microsoft Transaction Server Overview

Oracle Services for Microsoft Transaction Server Support for Serializable Transactions

Oracle Services for Microsoft Transaction Server Support for DTC

Microsoft Transaction Server and Oracle Integration Overview

Getting Started with Microsoft Transaction Server and Oracle

2 Installing and Migrating Oracle Products

Installing Oracle Services for Microsoft Transaction Server

Installation Requirements for Microsoft Transaction Server

Oracle Products

Non-Oracle Products

Installation Requirements for Oracle Database

Oracle Products

Non-Oracle Products

Upgrading Oracle Services for Microsoft Transaction Server

Deleting OraMTS with Oracle Manager for MTS Services

Stopping OraMTS

Stopping and Restarting the Database

Restarting the OraMTS

Monitoring the OraMTS Trace Files

Deleting OraMTS Table Information

Deleting the OraMTS

Deleting Roles and Privileges of an Inactive OraMTS User

Deleting Oracle Services for Microsoft Transaction Server Manually

Manually Deleting Oracle Services for Microsoft Transaction Server with the Registry

Deleting the OracleMTSServicen Service

3 Managing Recovery Scenarios

Microsoft Transaction Server Configuration Requirements

Microsoft Transaction Server Transaction Recovery Overview

Scheduling Automatic Microsoft Transaction Server Transaction Recovery

Setting and Starting Up Database Job-Queue Processes

Creating and Scheduling Automatic Transaction Recovery

utl_oramts.show_indoubt Procedure

utl_oramts.recover_automatic Procedure

utl_oramts.forget_RMs Procedure

oramts_2pc_pending View

Viewing Microsoft Transaction Server In-Doubt Transactions

Modifying Registry Values for Oracle Fail Safe Configurations

4 Running the Microsoft Application Demo

Configuring Oracle Call Interface with the Microsoft Application Demo

Microsoft Application Demo Overview

Ensuring the Database Includes the Proper Microsoft Application Demo Tables

Running the Microsoft Application Demo

Configuring Oracle ODBC Driver with the Microsoft Application Demo

Configuring Oracle Provider for OLE DB with the Microsoft Application Demo

5 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

6 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

Starting MSDTC

7 Troubleshooting Oracle Microsoft Transaction Server

Tracking Oracle Services for Microsoft Transaction Server Performance

Correcting Windows Explorer Problems

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