Oracle Developer’s Guide for Microsoft Transaction Server

Kennedy M., Rothenberg T.

This guide is the primary source of introduction, installation, configuration, usage, and administration information for using Microsoft Transaction Server withOracle.Oracle Developer’s Guide for Microsoft Transaction Server is intended for application developers who perform the following tasks:■ Use component object model (COM) components with Microsoft TransactionServer■ Register COM components as transactional and have Microsoft Transaction Server control the transaction■ Use client-side connection pooling in Microsoft Transaction Server”

---

Table of contents :
Contents……Page 3
Send Us Your Comments……Page 7
Preface……Page 9
What’s New in Oracle Services for Microsoft Transaction Server?……Page 19
Oracle9i Release 9.0 New Features in Oracle Services for Microsoft Transaction Server……Page 20
1 Using Microsoft Transaction Server with Oracle……Page 23
Microsoft Transaction Server Overview……Page 24
Microsoft Transaction Server and Oracle Integration Overview……Page 25
Getting Started with Microsoft Transaction Server and Oracle……Page 27
2 Installing and Migrating Oracle Products……Page 29
Microsoft Transaction Server and Oracle Installation Overview……Page 30
Oracle Services for Microsoft Transaction Server Installation Requirements……Page 31
Migrating From a Previous Oracle Services for Microsoft Transaction Server Installation……Page 33
Deleting an Oracle Service for MTS with the Oracle Manager for MTS Services Snap-In……Page 34
Deleting Roles and Privileges of an Inactive Oracle Service for MTS User……Page 38
Using the Registry to Manually Delete the Oracle Service for MTS……Page 39
Task 1: Manually Delete the Oracle Service for MTS with the Registry……Page 40
Task 2: Delete the OracleMTSServicen Service……Page 41
3 Managing Recovery Scenarios……Page 43
Microsoft Transaction Server Configuration Requirements……Page 44
Microsoft Transaction Server Transaction Recovery Overview……Page 45
Scheduling Automatic Microsoft Transaction Server Transaction Recovery……Page 46
Task 1: Set and Start Up SNP Processes……Page 47
Task 2: Create and Schedule Automatic Transaction Recovery……Page 48
utl_oramts.show_indoubt Procedure……Page 49
utl_oramts.recover_automatic Procedure……Page 50
oramts_2pc_pending View……Page 51
Viewing Microsoft Transaction Server In-Doubt Transactions……Page 52
Modifying Registry Values for Oracle Fail Safe Configurations……Page 53
4 Running the Microsoft Application Demo……Page 55
Configuring OCI with the Microsoft Application Demo……Page 56
Ensuring the Database Includes the Proper Microsoft Application Demo Tables……Page 57
Running the Microsoft Application Demo……Page 59
Configuring Oracle Provider for OLE DB with the Microsoft Application Demo……Page 61
5 Programming with Microsoft Transaction Server and an Oracle Database Server……Page 63
COM Component Integration in a Transaction Overview……Page 64
Microsoft Transaction Server Component Registration Overview……Page 67
Microsoft Transaction Server-Coordinated Component Transaction Overview……Page 69
MS DTC-Coordinated Component Transaction Overview……Page 70
OCI and Microsoft Transaction Server Function Overview……Page 71
OraMTSSvcGet() Function……Page 75
OraMTSSvcRel() Function……Page 78
OraMTSSvcEnlist() Function……Page 79
OraMTSSvcEnlistEx() Function……Page 81
OraMTSEnlCtxGet() Function……Page 82
OraMTSEnlCtxRel() Function……Page 84
OraMTSJoinTxn() Function……Page 85
OraMTSTransTest() Function……Page 86
OraMTSOCIErrGet() Function……Page 87
Using the Oracle ODBC Driver……Page 88
Using Microsoft’s Oracle ODBC Driver……Page 90
Other API Integration with Microsoft Transaction Server Overview……Page 91
6 Tuning Microsoft Transaction Server Performance……Page 93
Improving Microsoft Transaction Server Application Performance……Page 94
Managing Microsoft Transaction Server Connections……Page 95
Increasing the Transaction Timeout Parameter on Windows NT……Page 98
Changing Initialization Parameter File Settings……Page 100
Starting MS DTC……Page 101
7 Troubleshooting Oracle Services for Microsoft Transaction Server……Page 103
Tracking Oracle Services for Microsoft Transaction Server Performance……Page 104
Correcting Windows NT Explorer Problems……Page 105
Correcting Oracle Net Changes that Impact Connection Pooling……Page 106
Frequently Asked Questions About Oracle Services for Microsoft Transaction Server……Page 107
Dropping the Microsoft Transaction Server Administrative User Account……Page 110
A Using Oracle Services for Microsoft Transaction Server on Windows 2000……Page 111
Microsoft Transaction Server Differences on Windows NT and Windows 2000……Page 112
Increasing the Transaction Timeout Parameter on Windows 2000……Page 113
Glossary……Page 115
Index……Page 119