Skip Headers
Oracle® Services for Microsoft Transaction Server Developer's Guide
10
g
Release 2 (10.2) for Microsoft Windows
Part Number B14320-01
Home
Book List
Index
Master Index
Contact Us
Next
View PDF
Contents
List of Examples
List of Figures
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Using Microsoft Transaction Server with Oracle Database
1.1
Microsoft Transaction Server Overview
1.1.1
Oracle Services for Microsoft Transaction Server Support for Serializable Transactions
1.1.2
Oracle Services for Microsoft Transaction Server Support for DTC
1.2
Microsoft Transaction Server and Oracle Integration Overview
1.3
Getting Started with Microsoft Transaction Server and Oracle
2
Installing and Migrating Oracle Products
2.1
Installing Oracle Services for Microsoft Transaction Server
2.1.1
Installation Requirements for Microsoft Transaction Server
2.1.1.1
Oracle Products
2.1.1.2
Non-Oracle Products
2.1.2
Installation Requirements for Oracle Database
2.1.2.1
Oracle Products
2.1.2.2
Non-Oracle Products
2.2
Upgrading Oracle Services for Microsoft Transaction Server
2.2.1
Deleting OraMTS with Oracle Manager for MTS Services
2.2.1.1
Stopping OraMTS
2.2.1.2
Stopping and Restarting the Database
2.2.1.3
Restarting the OraMTS
2.2.1.4
Monitoring the OraMTS Trace Files
2.2.1.5
Deleting OraMTS Table Information
2.2.1.6
Deleting the OraMTS
2.3
Deleting Roles and Privileges of an Inactive OraMTS User
2.4
Deleting Oracle Services for Microsoft Transaction Server Manually
2.4.1
Manually Deleting Oracle Services for Microsoft Transaction Server with the Registry
2.4.2
Deleting the OracleMTSService
n
Service
3
Managing Recovery Scenarios
3.1
Microsoft Transaction Server Configuration Requirements
3.2
Microsoft Transaction Server Transaction Recovery Overview
3.3
Scheduling Automatic Microsoft Transaction Server Transaction Recovery
3.3.1
Setting and Starting Up Database Job-Queue Processes
3.3.2
Creating and Scheduling Automatic Transaction Recovery
3.3.2.1
utl_oramts.show_indoubt Procedure
3.3.2.2
utl_oramts.recover_automatic Procedure
3.3.2.3
utl_oramts.forget_RMs Procedure
3.3.2.4
oramts_2pc_pending View
3.4
Viewing Microsoft Transaction Server In-Doubt Transactions
3.5
Modifying Registry Values for Oracle Fail Safe Configurations
4
Running the Microsoft Application Demo
4.1
Configuring Oracle Call Interface with the Microsoft Application Demo
4.1.1
Microsoft Application Demo Overview
4.1.2
Ensuring the Database Includes the Proper Microsoft Application Demo Tables
4.1.3
Running the Microsoft Application Demo
4.2
Configuring Oracle ODBC Driver with the Microsoft Application Demo
4.3
Configuring Oracle Provider for OLE DB with the Microsoft Application Demo
5
Programming with Microsoft Transaction Server and an Oracle Database
5.1
COM Component Integration in a Transaction
5.2
Microsoft Transaction Server Application Development
5.2.1
Microsoft Transaction Server Component Registration
5.2.1.1
Types of Registration Components
5.2.1.2
Registration of Components
5.2.2
Microsoft Transaction Server-Coordinated Component Transaction
5.2.3
Microsoft DTC-Coordinated Component Transaction
5.3
OCI Integration with Microsoft Transaction Server
5.3.1
Integrating COM Components
5.3.1.1
COM Components Running in an MTS-Coordinated Transaction
5.3.1.2
Non-Transactional COM Components Running with OCI Connection Pooling
5.3.1.3
COM Components Using MS DTC and OCI Connection Pooling
5.3.1.4
COM Components Using MS DTC and Nonpooling OCI Connection
5.3.2
Using OCI Functions
5.3.3
OraMTSSvcGet()
5.3.4
OraMTSSvcRel()
5.3.5
OraMTSSvcEnlist()
5.3.6
OraMTSSvcEnlistEx()
5.3.7
OraMTSEnlCtxGet()
5.3.8
OraMTSEnlCtxRel()
5.3.9
OraMTSJoinTxn()
5.3.10
OraMTSTransTest()
5.3.11
OraMTSOCIErrGet()
5.4
ODBC Integration with Microsoft Transaction Server Overview
5.4.1
Setting the Connection Attribute
5.4.2
Using Oracle ODBC Driver
5.4.3
Using Microsoft Oracle ODBC Driver
6
Tuning Microsoft Transaction Server Performance
6.1
Improving Microsoft Transaction Server Application Performance
6.2
Managing Microsoft Transaction Server Connections
6.2.1
Connection Pooling Registry Parameters
6.3
Increasing the Transaction Timeout Parameter
6.4
Changing Initialization Parameter Settings
6.5
Starting MSDTC
7
Troubleshooting Oracle Microsoft Transaction Server
7.1
Tracking Oracle Services for Microsoft Transaction Server Performance
7.2
Correcting Windows Explorer Problems
7.3
Correcting Oracle Net Changes that Impact Connection Pooling
7.4
Designing an Application that Uses Multiple Databases
7.5
Working with Different Types of Connection Pooling
7.6
Working with In-Doubt Transactions
7.7
Dropping the Microsoft Transaction Server Administrative User Account
Glossary
Index