Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience

Organization

Related Documentation

Conventions

Documentation Accessibility

1 Using Microsoft Transaction Server with Oracle

Microsoft Transaction Server Overview

Oracle Services for Microsoft Transaction Server Support for Serializable Transactions

Microsoft Transaction Server and Oracle Integration Overview

Getting Started with Microsoft Transaction Server and Oracle

2 Installing and Migrating Oracle Products

Oracle Services For Microsoft Transaction Server Installation Requirements

Upgrading from a Previous Oracle Services For Microsoft Transaction Server Installation

Deleting an Oracle Service for MTS with Oracle Manager for MTS Services

Task 1: Stopping the Oracle Service for MTS

Task 2: Stopping and Restart the Database

Task 3: Restarting the Oracle Service for MTS

Task 4: Monitoring the Oracle Service for MTS Trace Files

Task 5: Deleting Oracle Service for MTS Table Information

Task 6: Deleting the Oracle Service for MTS

Deleting Roles and Privileges of an Inactive Oracle Service for MTS User

Using the Registry to Manually Delete the Oracle Service for MTS

Task 1: Manually Deleting Oracle Service for MTS with the Registry

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

Task 1: Setting and Starting Up Database Job-Queue Processes

Task 2: Creating and Scheduling Automatic Transaction Recovery

utl_oramts.show_indoubt Procedure

Type

Arguments

Returns

Description

utl_oramts.recover_automatic Procedure

Type

Arguments

Returns

utl_oramts.forget_RMs Procedure

Type

Arguments

Returns

oramts_2pc_pending View

Formatid

global_transaction_id

branch_id

local_tx_id

state

protocol

endpoint

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

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

Syntax

Parameters

Returns

Comments

OraMTSSvcRel() Function

Syntax

Parameters

Returns

Comments

OraMTSSvcEnlist() Function

Syntax

Parameters

Returns

Comments

OraMTSSvcEnlistEx() Function

Syntax

Parameters

Returns

Comments

OraMTSEnlCtxGet() Function

Syntax

Parameters

Returns

Comments

OraMTSEnlCtxRel() Function

Syntax

Parameters

Returns

Comments

OraMTSJoinTxn() Function

Syntax

Parameters

Returns

Comments

OraMTSTransTest() Function

Syntax

Parameters

Returns

Comments

OraMTSOCIErrGet() Function

Syntax

Parameters

Returns

Comments

ODBC Integration with Microsoft Transaction Server Overview

Setting the Connection Attribute

Using Oracle ODBC Driver

Using Microsoft Oracle ODBC Driver

Integration 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 Settings

Starting MSDTC

7 Troubleshooting Oracle Services for Microsoft Transaction Server

Tracking Oracle Services for Microsoft Transaction Server Performance

Correcting Windows 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 Operating Systems

Microsoft Transaction Server Differences on Windows Platforms

Increasing the Transaction Timeout Parameter on Windows 2000

Glossary

Index