1/12
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
Changes in This Release for Oracle Services for Microsoft Transaction Server Developer's Guide
Changes in Oracle Database 12
c
Release 1 (12.1)
1
Using Microsoft Transaction Server with Oracle Database
Microsoft Transaction Server Overview
Microsoft Transaction Server and Oracle Integration Overview
Oracle Services for Microsoft Transaction Server Support for DTC
Distributed Transactions on Real Application Clusters (Oracle RAC)
Promotable Local Transactions
Read-Committed and Serializable Transactions
Getting Started with Microsoft Transaction Server and Oracle
2
Installing Oracle Services for Microsoft Transaction Server
Installation Introduction
Installation Requirements for Microsoft Transaction Server
Oracle Products
Non-Oracle Products
Using Oracle Services for MTS with Oracle Data Provider for .NET, Managed Driver
Manually Creating an Oracle MTS Recovery Service
3
Managing Recovery Scenarios
Microsoft Transaction Server Configuration Requirements
Microsoft Transaction Server Transaction Recovery Overview
Scheduling Automatic Microsoft Transaction Server Transaction Recovery
Creating an Access Control List (ACL)
Configuring Automatic Transaction Recovery
Setting and Starting Up Database Job-Queue Processes
Creating and Scheduling Automatic Transaction Recovery
Viewing Microsoft Transaction Server In-Doubt Transactions
Modifying Registry Values for Oracle Fail Safe Configurations
4
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
5
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
Additional Parameters
Starting MSDTC
6
Troubleshooting Oracle Microsoft Transaction Server
Tracking Oracle Services for Microsoft Transaction Server Performance
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
Scripting on this page enhances content navigation, but does not change the content in any way.