Before You Begin

1 Using Microsoft Transaction Server with an Oracle8i Database

Using Microsoft Transaction Server with an Oracle8i Database

What is Microsoft Transaction Server?

How are Microsoft Transaction Server and an Oracle8i Database Integrated?

How Do I Get Started?

2 Installing and Migrating Oracle Products

Oracle Product Layouts

What Do You Need to Install?

Migrating From a Previous Installation of Oracle Service for MTS

3 Creating a New Oracle Service for MTS

What Do You Need to Configure?

Verifying INIT.ORA File Parameter Values

Verifying Oracle Service for MTS User Name

Creating a New Oracle Service for MTS

4 Using the Microsoft Application Demo

Using OCI with the Microsoft Application Demo

Microsoft Application Demo Overview

Ensuring the Oracle8i Database Includes the Proper Tables

Running the Microsoft Application Demo

Using Oracle's ODBC Driver with the Microsoft Application Demo

5 Programming with Microsoft Transaction Server and an Oracle8i Database

Component Integration In a Transaction

Programming with Microsoft Transaction Server and an Oracle8i Database

Registering Microsoft Transaction Server Components

Components Running in a Microsoft Transaction Server-Coordinated Transaction

Components Not Running in a Microsoft Transaction Server-Coordinated Transaction, But Using MS DTC

Integrating OCI with Microsoft Transaction Server

OCI Function Overview

OraMTSSvcGet()

OraMTSSvcRel()

OraMTSSvcEnlist()

OraMTSSvcEnlistEx()

OraMTSTransTest()

Integrating ODBC with Microsoft Transaction Server

Setting the Connection Attribute

Using Oracle's ODBC Driver

Using Microsoft's Oracle ODBC Driver

Integrating Oracle Objects for OLE with Microsoft Transaction Server

Integrating Other APIs with Microsoft Transaction Server

6 Tuning Oracle Service for MTS Performance

Improving Performance

Managing Connections

Increasing the Transaction Timeout Parameter

Changing INIT.ORA File Parameter Settings

7 Troubleshooting

Using Trace Files

Correcting Windows NT Explorer Crashes

Identifying Oracle Service for MTS Startup Problems

Using the Event Viewer

Accessing the Event Viewer

Reading the Event Viewer

Using the Event Viewer

Starting MS DTC

Viewing Oracle Service for MTS Configuration Information

Correcting Net8 Changes that Impact Connection Pooling

Common Questions

A Manually Creating Oracle Service for MTS Users

Manually Creating the MTSSYS User

Manually Creating a Custom Oracle Service for MTS User

Creating a New Operating System Authenticated Oracle Service for MTS

Enabling an Existing Oracle Service for MTS to be Operating System Authenticated

B Deleting or Modifying an Existing Oracle Service for MTS

How Do I Modify or Delete an Oracle Service for MTS?

Preparing to Modify or Delete an Existing Oracle Service for MTS

Deleting an Existing Oracle Service for MTS

Modifying Oracle Service for MTS Connection Information

Modifying Oracle Service for MTS Trace File and MS DTC Information

Manually Deleting or Modifying the Oracle Service for MTS with the Registry

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

Index

---