Setting Up MTS to Access Oracle

You can enable an Oracle 7.3.3 database (with Oracle patch 7.3.3.20) to work with transactional MTS components on Windows NT and Windows 95. To enable an Oracle database to work with MTS components that support transactions, system administrators need to create views known as V$XATRANS$. To create these views, the administrator must run an Oracle-supplied script named Xaview.sql. This file can usually be found in C:\Orant\Rdbms73\Admin.

To create the V$XATRANS$ views

  1. Grant select access to the public on these views.

  2. In the Oracle Instance Manager, click Advanced Mode on the View menu and select Initialization Parameters in the left pane.

  3. In the right pane, select Advanced Tuning and increase the "distributed_transactions" parameter to allow for more concurrent MTS transactions to update the database at a single time.

See your Oracle Server documentation for more information about configuring your database to handle XA transactions.

© 1997 Microsoft Corporation. All rights reserved.