Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience

Organization

Related Documentation

Conventions

Documentation Accessibility

What's New in Oracle Services for Microsoft Transaction Server?

Oracle9i Release 9.0 New Features in Oracle Services for Microsoft Transaction Server

1 Using Microsoft Transaction Server with Oracle

Microsoft Transaction Server Overview

Microsoft Transaction Server and Oracle Integration Overview

Getting Started with Microsoft Transaction Server and Oracle

2 Installing and Migrating Oracle Products

Microsoft Transaction Server and Oracle Installation Overview

Oracle Services for Microsoft Transaction Server Installation Requirements

Migrating From a Previous Oracle Services for Microsoft Transaction Server Installation

Deleting an Oracle Service with the Oracle Manager for MTS Services Snap-In

Deleting Roles and Privileges of an Inactive Oracle Service User

Using the Registry to Manually Delete the Oracle Service

Task 1: Manually Delete Oracle Service with the Registry

Task 2: Delete 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

Task 1: Set and Start Up SNP Processes

Task 2: Create and Schedule 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 OCI 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 Server

COM Component Integration in a Transaction Overview

Microsoft Transaction Server Application Development Overview

Microsoft Transaction Server Component Registration Overview

Microsoft Transaction Server-Coordinated Component Transaction Overview

MS DTC-Coordinated Component Transaction Overview

OCI Integration with Microsoft Transaction Server Overview

OCI and Microsoft Transaction Server Function Overview

OraMTSSvcGet() Function

OraMTSSvcRel() Function

OraMTSSvcEnlist() Function

OraMTSSvcEnlistEx() Function

OraMTSEnlCtxGet() Function

OraMTSEnlCtxRel() Function

OraMTSJoinTxn() Function

OraMTSTransTest() Function

OraMTSOCIErrGet() Function

ODBC Integration with Microsoft Transaction Server Overview

Setting the Connection Attribute

Using the Oracle ODBC Driver

Using Microsoft's Oracle ODBC Driver

OO4O Integration with Microsoft Transaction Server Overview

Oracle Provider for OLE DB Integration with Microsoft Transaction Server Overview

Other API Integration with Microsoft Transaction Server Overview

6 Tuning Microsoft Transaction Server Performance

Improving Microsoft Transaction Server Application Performance

Managing Microsoft Transaction Server Connections

Increasing the Transaction Timeout Parameter on Windows NT

Changing Initialization Parameter File Settings

Starting MS DTC

7 Troubleshooting Oracle Services for Microsoft Transaction Server

Tracking Oracle Services for Microsoft Transaction Server Performance

Correcting Windows NT Explorer Problems

Correcting Oracle Net Changes that Impact Connection Pooling

Frequently Asked Questions About Oracle Services for Microsoft Transaction Server

Dropping the Microsoft Transaction Server Administrative User Account

A Using Oracle Services for Microsoft Transaction Server on Windows 2000

Microsoft Transaction Server Differences on Windows NT and Windows 2000

Increasing the Transaction Timeout Parameter on Windows 2000

Glossary

Index