(cid:226) Oracle Developer’s Guide for Microsoft Transaction Server Release 9.0.1 for Windows June 2001 Part No. A90170-01 Oracle Developer’s Guide for Microsoft Transaction Server, Release 9.0.1 for Windows Part No. A90170-01 Copyright © 1996, 2001, Oracle Corporation. All rights reserved. Authors: Mark Kennedy and Tamar Rothenberg Contributors: Vivek Raja and Eric Wang The Programs (which include both the software and documentation) contain proprietary information of Oracle Corporation; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of the Programs is prohibited. The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. Oracle Corporation does not warrant that this document is error free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle Corporation. If the Programs are delivered to the U.S. Government or anyone licensing or using the programs on behalf of the U.S. Government, the following notice is applicable: Restricted Rights Notice Programs delivered subject to the DOD FAR Supplement are "commercial computer software" and use, duplication, and disclosure of the Programs, including documentation, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, Programs delivered subject to the Federal Acquisition Regulations are "restricted computer software" and use, duplication, and disclosure of the Programs shall be subject to the restrictions in FAR 52.227-19, Commercial Computer Software - Restricted Rights (June, 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065. The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle Corporation disclaims liability for any damages caused by such use of the Programs. Oracle is a registered trademark, and Oracle Store, SQL*Net, PL/SQL, and SQL*Plus are trademarks or registered trademarks of Oracle Corporation. Other names may be trademarks of their respective owners Contents Send Us Your Comments.................................................................................................................. vii Preface............................................................................................................................................................ ix Audience.................................................................................................................................................. x Organization............................................................................................................................................ x Related Documentation........................................................................................................................ xi Conventions........................................................................................................................................... xii Documentation Accessibility............................................................................................................. xvi What’s New in Oracle Services for Microsoft Transaction Server?....................... xix Oracle9i Release 9.0 New Features in Oracle Services for Microsoft Transaction Server.......... xx 1 Using Microsoft Transaction Server with Oracle Microsoft Transaction Server Overview......................................................................................... 1-2 Microsoft Transaction Server and Oracle Integration Overview.............................................. 1-3 Getting Started with Microsoft Transaction Server and Oracle................................................ 1-5 2 Installing and Migrating Oracle Products Microsoft Transaction Server and Oracle Installation Overview.............................................. 2-2 Oracle Services for Microsoft Transaction Server Installation Requirements....................... 2-3 Migrating From a Previous Oracle Services for Microsoft Transaction Server Installation 2-5 Deleting an Oracle Service for MTS with the Oracle Manager for MTS Services Snap-In 2-6 Deleting Roles and Privileges of an Inactive Oracle Service for MTS User....................... 2-10 iii Using the Registry to Manually Delete the Oracle Service for MTS...................................... 2-11 Task 1: Manually Delete the Oracle Service for MTS with the Registry............................. 2-12 Task 2: Delete the OracleMTSServicen Service...................................................................... 2-13 3 Managing Recovery Scenarios Microsoft Transaction Server Configuration Requirements...................................................... 3-2 Microsoft Transaction Server Transaction Recovery Overview................................................. 3-3 Scheduling Automatic Microsoft Transaction Server Transaction Recovery.......................... 3-4 Task 1: Set and Start Up SNP Processes.................................................................................... 3-5 Task 2: Create and Schedule Automatic Transaction Recovery ........................................... 3-6 utl_oramts.show_indoubt Procedure........................................................................................ 3-7 utl_oramts.recover_automatic Procedure................................................................................. 3-8 utl_oramts.forget_RMs Procedure............................................................................................. 3-9 oramts_2pc_pending View.......................................................................................................... 3-9 Viewing Microsoft Transaction Server In-Doubt Transactions............................................... 3-10 Modifying Registry Values for Oracle Fail Safe Configurations............................................ 3-11 4 Running the Microsoft Application Demo Configuring OCI with the Microsoft Application Demo........................................................... 4-2 Microsoft Application Demo Overview.................................................................................... 4-3 Ensuring the Database Includes the Proper Microsoft Application Demo Tables............. 4-3 Running the Microsoft Application Demo................................................................................ 4-5 Configuring Oracle ODBC Driver with the Microsoft Application Demo ............................ 4-7 Configuring Oracle Provider for OLE DB with the Microsoft Application Demo ............... 4-7 5 Programming with Microsoft Transaction Server and an Oracle Database Server COM Component Integration in a Transaction Overview......................................................... 5-2 Microsoft Transaction Server Application Development Overview........................................ 5-5 Microsoft Transaction Server Component Registration Overview....................................... 5-5 Microsoft Transaction Server-Coordinated Component Transaction Overview................ 5-7 MS DTC-Coordinated Component Transaction Overview.................................................... 5-8 iv OCI Integration with Microsoft Transaction Server Overview................................................. 5-9 OCI and Microsoft Transaction Server Function Overview................................................... 5-9 OraMTSSvcGet() Function ....................................................................................................... 5-13 OraMTSSvcRel() Function......................................................................................................... 5-16 OraMTSSvcEnlist() Function ................................................................................................... 5-17 OraMTSSvcEnlistEx() Function ............................................................................................... 5-19 OraMTSEnlCtxGet() Function ................................................................................................. 5-20 OraMTSEnlCtxRel() Function .................................................................................................. 5-22 OraMTSJoinTxn() Function ...................................................................................................... 5-23 OraMTSTransTest() Function................................................................................................... 5-24 OraMTSOCIErrGet() Function ................................................................................................ 5-25 ODBC Integration with Microsoft Transaction Server Overview........................................... 5-26 Setting the Connection Attribute.............................................................................................. 5-26 Using the Oracle ODBC Driver................................................................................................ 5-26 Using Microsoft’s Oracle ODBC Driver.................................................................................. 5-28 OO4O Integration with Microsoft Transaction Server Overview........................................... 5-29 Oracle Provider for OLE DB Integration with Microsoft Transaction Server Overview... 5-29 Other API Integration with Microsoft Transaction Server Overview.................................... 5-29 6 Tuning Microsoft Transaction Server Performance Improving Microsoft Transaction Server Application Performance........................................ 6-2 Managing Microsoft Transaction Server Connections................................................................ 6-3 Increasing the Transaction Timeout Parameter on Windows NT............................................. 6-6 Changing Initialization Parameter File Settings.......................................................................... 6-8 Starting MS DTC................................................................................................................................ 6-9 7 Troubleshooting Oracle Services for Microsoft Transaction Server Tracking Oracle Services for Microsoft Transaction Server Performance............................... 7-2 Correcting Windows NT Explorer Problems ................................................................................ 7-3 Correcting Oracle Net Changes that Impact Connection Pooling............................................ 7-4 Frequently Asked Questions About Oracle Services for Microsoft Transaction Server...... 7-5 Dropping the Microsoft Transaction Server Administrative User Account............................ 7-8 v A Using Oracle Services for Microsoft Transaction Server on Windows 2000 Microsoft Transaction Server Differences on Windows NT and Windows 2000................... A-2 Increasing the Transaction Timeout Parameter on Windows 2000............................................ A-3 Glossary Index vi Send Us Your Comments Oracle Developer’s Guide for Microsoft Transaction Server, Release 9.0.1 for Windows Part No. A90170-01 Oracle Corporation welcomes your comments and suggestions on the quality and usefulness of this document. Your input is an important part of the information used for revision. n Did you find any errors? n Is the information clearly presented? n Do you need more information? If so, where? n Are the examples correct? Do you need more examples? n What features did you like most? If you find any errors or have any other suggestions for improvement, please indicate the document title and part number, and the chapter, section, and page number (if available). You can send comments to us in the following ways: n E-mail: [email protected] n FAX - (650) 506-7365 Attn: Oracle Database for Windows Documentation n Postal service: Oracle Corporation Oracle Database for Windows Documentation Manager 500 Oracle Parkway, Mailstop 1op6 Redwood Shores, CA 94065 USA If you would like a reply, please give your name, address, telephone number, and (optionally) electronic mail address. If you have proble ms with the software, please contact your local Oracle Support Services. Contact information for Oracle Support Services is available at this Web site: http://www.oracle.com/support/ vii viii Preface This guide is the primary source of introduction, installation, configuration, usage, and administration information for using Microsoft Transaction Server with Oracle. This preface contains these topics: n Audience n Organization n Related Documentation n Conventions n Documentation Accessibility ix Audience Oracle Developer’s Guide for Microsoft Transaction Server is intended for application developers who perform the following tasks: n Use component object model (COM) components with Microsoft Transaction Server n Register COM components as transactional and have Microsoft Transaction Server control the transaction n Use client-side connection pooling in Microsoft Transaction Server Organization This document contains: Chapter1, "Using Microsoft Transaction Server with Oracle" This chapter describes the integration of Microsoft Transaction Server and an Oracle database server. Chapter2, "Installing and Migrating Oracle Products" This chapter describes installation and migration requirements for Microsoft Transaction Server and database server environments. Chapter3, "Managing Recovery Scenarios" This chapter describes how to schedule Microsoft Transaction Server transaction recovery. Chapter4, "Running the Microsoft Application Demo" This chapter describes how to use the sample Microsoft COM-based application demo that is integrated with Microsoft Transaction Server. Chapter5, "Programming with Microsoft Transaction Server and an Oracle Database Server" This chapter describes how to program with Microsoft Transaction Server and a database server. Chapter6, "Tuning Microsoft Transaction Server Performance" This chapter describes how to tune Microsoft Transaction Server performance. x