Using Microsoft Transaction Server with Oracle8i A68065-01

Library Product Contents

Index

Symbols

%ORACLE_HOME%, explained, xix

A

ACCOUNT table

using with Microsoft application demo, 4-3, A-2, A-5

ACCOUNT.IDI, 4-5

Administrator privileges

for creating an Oracle Service for MTS, 3-7

B

backslash (\), defined, xviii

BUILDALL.SQL script

creating MTSSYS user name, 3-4, 4-3

C

C:\>, defined, xviii

C:\ORANT, defined, xix

C:\ORAWIN, defined, xix

C:\ORAWIN95, defined, xix

Choose Start >, defined, xviii

client computer

configuration requirements, 3-2

installation requirements, 2-4

code conventions, used in this guide, xviii

COM components

deploying, 1-2

integration in a transaction, 5-2

marking as transactional, 1-3

ODBC, 2-4

Oracle Objects for OLE, 2-4

programming with OCI and Microsoft Transaction Server, 5-9

programming with ODBC and Microsoft Transaction Server, 5-24

programming with Oracle Objects for OLE and Microsoft Transaction Server, 5-27

registering in a Microsoft Transaction Server environment, 5-5

running in a Microsoft Transaction Server

coordinating transactions, 5-7

running in an MS DTC-coordinated transaction, 5-8

using OCI, 1-3

using ODBC, 1-3

using Oracle Objects for OLE, 1-3

using with Microsoft's Oracle ODBC Driver and Microsoft Transaction Server, 5-26

using with Oracle's ODBC Driver and Microsoft Transaction Server, 5-24

computer on which Microsoft Transaction Server is installed

configuration requirements, 3-2

installation requirements, 2-4

computer on which Oracle8i database is installed

configuration requirements, 3-2

installation requirements, 2-4

configuration requirements

on client computer, 3-2

on computer on which Microsoft Transaction Server is installed, 3-2

on computer on which Oracle8i database is installed, 3-2

verifying INIT.ORA file parameter values, 3-3

connection

managing connection pooling, 6-3

connection attribute

setting with ODBC, 5-24

connection pooling

client side registry parameters, 6-3

differences between OCI, Microsoft Transaction Server, and Net8 connection pooling, 7-15

editing registry parameters, 6-9

emptying connection pools, 7-13

integration with Microsoft Transaction Server, 5-3

managing connections, 6-3

obtaining environment handles, 5-13

obtaining service handles, 5-13

releasing connections, 5-16

responsibilities, 5-3

server side registry parameters, 6-3

using OraMTSSvcGet() function, 5-13

contact information

Oracle Support Services, xii

controlling tracing, 7-4

custom user name

creating for Oracle Service for MTS, A-5

running the MTSUSER.SQL script, A-2, A-6, A-7

D

database links

with Microsoft Transaction Server, 7-14

DCOM, 1-2

demo

directory installation location, 4-3

Microsoft application demo, 1-5, 4-2, 4-8

running the Microsoft application demo, 4-5

running the OMTSSAMP.SQL script, 4-4

using the MTSDEMOUSR user name, 4-4

using Visual C++, 4-5

verifying Microsoft application demo installation, 4-5

verifying Oracle8i database includes proper tables, 4-3

directory names, convention used, xviii

documentation conventions, used in this guide, xviii

DTCSETUP.EXE

installation requirements, 2-4

E

environment handles, 5-13

error messages

appearing in the Event Viewer, 7-6

resolving, x

Event Viewer

accessing, 7-6

blue (informational) icon, 7-7

IDs, 7-8

Oracle Service for MTS events displayed, 7-6

reading, 7-7

red (stop sign) icon, 7-7

using, 7-6

yellow (exclamation point) icon, 7-8

F

file names, convention used, xviii

G

getting started

with Microsoft Transaction Server and an Oracle8i database, 1-5

H

hardware configuration

optimizing to improve performance, 6-2

HOME_NAME, defined, xx

HOMEID

defined, xx

I

infowin@us.oracle.com, xi

INIT.ORA file

changing parameter settings, 6-12

OS_ROLES parameter, 6-6

PROCESSES parameter, 6-12

SESSIONS parameter, 6-12

verifying parameter values, 3-3

in-process components

definition, 7-3

installation

of Microsoft Transaction Server and Oracle8i database on same computer, 2-2

of Microsoft Transaction Server and Oracle8i database on separate computers, 2-2, 5-4

using IP load balancing, 2-2

installation layouts, 2-2

installation requirements

for client computer, 2-4

for computer on which Microsoft Transaction Server is installed, 2-4

for computer on which Oracle8i database is installed, 2-4

for computer running Oracle Service for MTS, 2-3

Microsoft Internet Information Server, 2-4

Microsoft Transaction Server, 2-3, 2-4

Net8 Assistant, 2-4

Net8 Client, 2-4

Net8 Server, 2-4

ODBC, 2-4

one Oracle Service for MTS for each Oracle8i database, 2-3

Oracle Objects for OLE, 2-4

Oracle Services for Microsoft Transaction Server, 2-4

Oracle8i database, 2-4

required RAM, 2-3

Service Pack 4.0, 2-4

special downloadable MS DTC file, 2-4

SQL*Plus, 2-4

IP load balancing, 2-2

italic letters, defined, xviii

L

local computer

creating an Oracle Service for MTS, 3-6

M

Microsoft application demo

installation location, 4-3

overview of database contents, 4-3

running, 4-5

running the OMTSSAMP.SQL script, 4-4

setting sufficient INIT.ORA parameter values, 3-3

using Microsoft Developer Studio, 4-7

using OCI, 4-2

using Oracle's ODBC driver, 4-8

using the MTSDEMOUSR user name, 4-4

using Visual C++, 4-5

verifying installation, 4-5

verifying Oracle8i database includes proper tables, 4-3

Microsoft Developer Studio

using with Microsoft application demo, 4-7

Microsoft HTML Help, 2-3, 2-4

Microsoft Internet Information Server

installation requirements, 2-4

Microsoft Management Console

installation methods, 2-4

Microsoft Transaction Server, 1-2

benefits, 1-2

client computer responsibilities, 5-3

COM components running in a transaction, 5-7

components running in an MS DTC-coordinated transaction, 5-8

connection pooling responsibilities, 5-3

database links, 7-14

definition, 1-2

getting started with an Oracle8i database, 1-5

increasing timeout parameter, 6-10

installation requirements, 2-3, 2-4

integration with Oracle8i database, 1-3

MS DTC responsibilities, 5-3

OCI responsibilities, 5-3

ODBC responsibilities, 5-3

Oracle Objects for OLE responsibilities, 5-3

Oracle Service for MTS responsibilities, 5-3

Oracle8i database responsibilities, 5-4

programming with OCI, 5-9

programming with ODBC, 5-24

programming with Oracle Objects for OLE, 5-27

programming with the Oracle8i database, 5-4

registering COM components, 5-5

starting MS DTC, 7-10

three-tiered architecture model, 1-2

using OCI with the Microsoft application demo, 4-2

using with Microsoft's Oracle ODBC Driver, 5-26

using with Oracle's ODBC Driver, 5-24

Microsoft Transaction Server demos

using Oracle's ODBC driver with the Microsoft application demo, 4-8

MS DTC, 5-18, 5-21

COM components running in an MS DTC-coordinated transaction, 5-8

modifying the location, B-10

responsibilities, 5-2, 5-3

special downloadable file for installation, 2-4

starting, 7-10

using with Oracle Service for MTS, 2-3

MTSDEMO, 4-3

Net8 network connection, 3-9

MTSDEMOUSR user name

using the Microsoft application demo, 4-4

MTSSamples.dsn

using with Oracle's ODBC driver, 5-25

MTSSYS user name

changing the password, 3-5, A-3

connecting with, 3-5

for use with Oracle Service for MTS, 3-4

manually creating for Oracle Service for MTS, A-2

manually creating with the ORAMTS.SQL script, A-3, A-6

password, 3-4

required roles and privileges, 3-4

verifying inclusion in Oracle8i database, 3-4

MTSUSER.SQL script

editing to create a custom user, A-7

running, A-7

MTX.EXE

running, 7-3

MTXSTOP.EXE

running, 7-13

multiple Oracle homes

defined, xix

N

net service names

changes that impact connection pooling, 7-13

Net8

MTSDEMO net service name, 3-9

Net8 Assistant

creating a network connection, 3-6

installation requirements, 2-4

Net8 Client

installation requirements, 2-4

Net8 Easy Config

creating a network connection, 3-6

Net8 Server

installation requirements, 2-4

network connections

changes that impact connection pooling, 7-13

creating with Net8 Assistant or Net8 Easy Config, 3-6

network interconnects

optimizing to improve performance, 6-2

non-COM components

using, 5-12

O

OCI

connection pooling differences with OCI, Net8, and Microsoft Transaction Server, 7-15

enlisting an MS DTC-coordinated transaction, 5-21

enlisting or de-enlisting an MS DTC-coordinated transaction, 5-18

obtaining pooled OCI connections, 5-14

obtaining pooled or standard OCI connections, 5-19

OraMTSSvcEnlist() function, 5-18

OraMTSSvcEnlist() function parameters, 5-18

OraMTSSvcEnlistEx() function, 5-21

OraMTSSvcEnlistEx() function parameters, 5-21

OraMTSSvcGet() function, 5-13

OraMTSSvcGet() function parameters, 5-13

OraMTSSvcRel() function, 5-16

OraMTSSvcRel() function parameters, 5-16, 5-23

OraMTSTransTest() function, 5-23

overview of connection pooling, 5-9

programming with Microsoft Transaction Server, 5-9

releasing pooled OCI connections, 5-16

responsibilities, 5-3

sample file location, 5-11

using with the Microsoft application demo, 4-2

warnings against using OCITransCommit() and OCITransAbort(), 5-9

OCI_THREADED flag

passing, 5-10

OCIInitialize

calling, 5-10

ODBC

configuring Microsoft's Oracle ODBC Driver with Microsoft Transaction Server, 5-26

configuring Oracle's ODBC Driver with Microsoft Transaction Server, 5-25

installation requirements, 2-4

programming with Microsoft Transaction Server, 5-24

responsibilities, 5-3

setting the connection attribute, 5-24

using Microsoft's Oracle ODBC Driver with Microsoft Transaction Server, 5-26

using MTSSamples.dsn with Oracle's ODBC driver, 5-25

using Oracle's ODBC Driver with Microsoft Transaction Server, 5-24

using Oracle's ODBC driver with the Microsoft application demo, 4-8

using the SQL_ATTR_ENLIST_IN_DTC parameter, 5-24

using the SQLSetConnectAttr function, 5-24

OLE

integration with Microsoft Transaction Server, 5-3

OMTSSAMP.SQL script, 4-4, 5-26

OO4O. See Oracle Objects for OLE

operating system authentication

authenticating a new Oracle Service for MTS user name, A-9

authenticating an existing Oracle Service for MTS user name, A-12

available platforms, 7-15

of Oracle Service for MTS user, 3-5

with OCI function OraMTSSvcGet(), 5-15

Optimal Flexible Architecture

directory naming conventions, 4-2

Oracle Manager for MTS Services snap-in, 7-4

definition, 1-3

displaying in the Microsoft Management Console, 3-8

using Microsoft HTML Help, 2-3

Oracle Objects for OLE

installation requirements, 2-4

programming with Microsoft Transaction Server, 5-27

responsibilities, 5-3

with Microsoft Transaction Server, 5-3

Oracle Service for MTS

authenticating a new Oracle Service for MTS user name, A-9

authenticating an existing Oracle Service for MTS user name, A-12

creating a custom user name, A-5

creating a new service, 3-6

creating on a local computer, 3-6

creating on a remote computer, 3-6

creating with Administrator privileges, 3-7

definition, 1-3

deleting, B-5

deleting roles and privileges of inactive users, B-16

installation requirements, 2-3

manually creating the MTSSYS user name, A-2

modifying connection information to an Oracle8i database, B-7

modifying Oracle Service for MTS in the registry, B-13

modifying trace file and MS DTC information, B-10

preparing to delete or modify, B-3

reasons for failing to be deleted or modified, B-13

requirements for deleting, B-2

requirements for modifying, B-2

responsibilities, 5-3

special MTSSYS user name, 3-4

starting the service, 3-11

troubleshooting startup problems, 7-5

using with MS DTC, 2-3

verifying the MTSSYS user name, 3-4

Oracle Services for Microsoft Transaction Server

installable product, 1-3, 3-2

installation methods, 2-4

installation requirements, 2-4

Oracle Support Services

contact information, xii

contacting, x

ORACLE_BASE

explained, xix, 4-2

ORACLE_HOME

explained, xix, 4-2

Oracle8i database

authenticating an existing Oracle Service for MTS user name, A-12

changing INIT.ORA file parameter settings, 6-12

creating a custom Oracle Service for MTS user name, A-2, A-5

installation requirements, 2-4

integration with Microsoft Transaction server, 1-3

responsibilities, 5-4

verifying inclusion of MTSSYS user name, 3-4

with Microsoft Transaction Server, 1-2

ORAMTS.DLL

definition, 7-2

ORAMTS.SQL script

creating MTSSYS user, 3-4

running, 4-3

running to create the MTSSYS user, A-3, A-6

ORAMTS_CFLG_ALLDEFAULT flag

description, 5-13

ORAMTS_CFLG_NOIMPLICIT flag

description, 5-14

ORAMTS_CFLG_PRELIMAUTH

using, 5-15

ORAMTS_CFLG_PRELIMAUTH flag

description, 5-14

ORAMTS_CFLG_SYSDBALOGN

using, 5-15

ORAMTS_CFLG_SYSDBALOGN flag

description, 5-14

ORAMTS_CFLG_SYSOPRLOGN

using, 5-15

ORAMTS_CFLG_SYSOPRLOGN flag

description, 5-14

ORAMTS_CFLG_UNIQUESRVR flag

description, 5-14

ORAMTS_CONN_POOL_TIMEOUT registry parameter, 6-3, 6-5

ORAMTS_CP_TRACE_LEVEL registry parameter, 7-2

ORAMTS_ENFLG_DEFAULT flag

description, 5-19

ORAMTS_ENFLG_DETCHTX flag

description, 5-19

ORAMTS_ENFLG_RESUMTX flag

description, 5-19

ORAMTS_NET_CACHE_MAXFREE registry parameter, 6-3, 6-5

ORAMTS_NET_CACHE_TIMEOUT registry parameter, 6-3, 6-5

ORAMTS_ORADB registry parameter, B-14

ORAMTS_OSCREDS_MATCH_LEVEL registry parameter, 6-3, 6-6

ORAMTS_RPC_TRACE_LEVEL registry parameter, 7-2

ORAMTS_SUNAME registry parameter, B-14

ORAMTS_SUPWD registry parameter, B-14

ORAMTS_SVC_CONN_POOL_TIMEOUT

registry parameter, 6-3

ORAMTS_SVC_CONN_POOL_TIMEOUT registry parameter, 6-3, 6-7

ORAMTS_SVC_NET_CACHE_MAXFREE registry parameter, 6-3, 6-8

ORAMTS_SVC_NET_CACHE_TIMEOUT registry parameter, 6-3, 6-7

ORAMTSERR_NOERROR

returning upon acquiring a connection, 5-19, 5-21

returning upon obtaining a connection, 5-14

returning upon releasing a connection, 5-16

OraMTSSvcEnlist() function

enlisting pooled or standard OCI connections, 5-19

OCI function, 5-18

overview, 5-9, 5-12

parameters, 5-18

returning ORAMTSERR_NOERROR upon acquiring a connection, 5-19

syntax, 5-18

OraMTSSvcEnlistEx() function

differences with OraMTSSvcEnlist() function, 5-21

OCI function, 5-21

overview, 5-9, 5-12

parameters, 5-21

returning ORAMTSERR_NOERROR upon acquiring a connection, 5-21

syntax, 5-21

OraMTSSvcEnlistl() function

ORAMTS_ENFLG_DEFAULT flag, 5-19

ORAMTS_ENFLG_DETCHTX flag, 5-19

ORAMTS_ENFLG_RESUMTX flag, 5-19

OraMTSSvcGet()

using with operating system authentication, 5-15

OraMTSSvcGet() function

OCI function, 5-13

ORAMTS_CFLG_ALLDEFAULT flag, 5-13

ORAMTS_CFLG_NOIMPLICIT flag, 5-14

ORAMTS_CFLG_PRELIMAUTH flag, 5-14

ORAMTS_CFLG_SYSDBALOGN flag, 5-14

ORAMTS_CFLG_SYSOPRLOGN flag, 5-14

ORAMTS_CFLG_UNIQUESRVR flag, 5-14

overview, 5-9, 5-12

parameters, 5-13

responsibilities, 5-13

returning a pooled connection, 5-14

returning ORAMTSERR_NOERROR upon obtaining a connection, 5-14

syntax, 5-13

OraMTSSvcRel() function

OCI function, 5-16

overview, 5-9, 5-12

parameters, 5-16, 5-23

releasing a pooled connection, 5-16

returning ORAMTSERR_NOERROR upon releasing a connection, 5-16

syntax, 5-16

OraMTSSvcTransTest() function

OCI function, 5-23

OraMTSTransTest() function, 5-23

ORAOCI

setting in the registry, 5-27

OS_ROLES parameter, 6-6

out-of-process components

definition, 7-3

P

password

changing for MTSSYS user name, 3-5, A-3

for MTSSYS user name, 3-4

performance

improving, 6-2

pooled connection

releasing, 5-16

privileges

deleting privileges of an inactive Oracle Service for MTS user, B-16

PROCESSES parameter

changing the value, 6-12

verifying INIT.ORA file value, 3-3

programming

with OCI and Microsoft Transaction Server, 5-9

with ODBC and Microsoft Transaction Server, 5-24

with Oracle Objects for OLE and Microsoft Transaction Server, 5-27

with Oracle's ODBC Driver and Microsoft Transaction Server, 5-24

programming methods

optimizing to improve performance, 6-2

R

RECEIPT table

using with Microsoft application demo, 4-3

REGEDT32, 6-9, B-14

registry

modifying the connection pooling parameters, 6-9

modifying the Oracle Service for MTS database connection, B-13

REGEDT32, B-14

trace file settings, 7-2

registry parameter

editing connection pooling parameters, 6-9

ORAMTS_CONN_POOL_TIMEOUT, 6-3, 6-5

ORAMTS_CP_TRACE_LEVEL, 7-2

ORAMTS_NET_CACHE_MAXFREE, 6-3, 6-5

ORAMTS_NET_CACHE_TIMEOUT, 6-3, 6-5

ORAMTS_ORADB, B-14

ORAMTS_OSCREDS_MATCH_LEVEL, 6-3, 6-6

ORAMTS_RPC_TRACE_LEVEL, 7-2

ORAMTS_SUNAME, B-14

ORAMTS_SUPWD, B-14

ORAMTS_SVC_CONN_POOL_TIMEOUT, 6-7

ORAMTS_SVC_NET_CACHE_MAXFREE, 6-3, 6-8

ORAMTS_SVC_NET_CACHE_TIMEOUT, 6-3, 6-7

remote computer

creating an Oracle Service for MTS, 3-6

requirements

for modifying or deleting an Oracle Service for MTS, B-2

REVOKEUSER.SQL script

running, B-16

RM

responsibilities, 5-2, 5-3

roles

deleting roles of an inactive Oracle Service for MTS user, B-16

S

samples

Microsoft application demo, 4-2, 4-8

SCOTT user name

using the ACCOUNT and RECEIPT tables, 4-3, A-2, A-5

using with Microsoft application demo, 4-3, 4-7, A-2, A-5

SCOTT.SQL script

running, 4-3, A-2, A-5

running with ORAMTS.SQL, 3-4

service

creating a new Oracle Service for MTS, 3-6

deleting, B-5

modifying connection information to an Oracle8i database, B-7

preparing to delete or modify, B-3

starting Oracle Service for MTS, 3-11

service handles, 5-13

Service Pack 4.0

correcting Windows NT Explorer crashes, 7-5

installation requirements, 2-4

SESSIONS parameter

changing the value, 6-12

verifying INIT.ORA file value, 3-3

SQL*Plus

installation requirements, 2-4

square brackets, defined, xviii

symbols, list of, xx

syntax, 5-23

T

three-tiered architecture, 1-2, 1-4, 5-2

timeout parameter

increasing for Microsoft Transaction Server, 6-10

trace files

file name conventions, 7-2

level 4 warning, 7-4

modifying trace levels and file names, B-10

registry settings, 7-2

trace levels, 7-3

using, 7-2

trace levels

available range, B-12

controlled by Oracle Manager for MTS Services snap-in, 7-4

file location, B-12

trace parameters

setting as environmental variables, 7-3

setting in the registry, 7-4

transaction

increasing the transaction timeout parameter, 6-10

overview of COM component integration, 5-2

troubleshooting, x

correcting Net8 changes that impact connection pooling, 7-13

correcting Windows NT Explorer crashes, 7-5

increasing the transaction timeout parameter, 6-10

Oracle Service for MTS startup problems, 7-5

reason a deletion or modification of Oracle Service for MTS fails, B-13

starting MS DTC, 7-10

using the Event Viewer, 7-6

using trace files, 7-2

tuning

changing the SESSIONS and PROCESSES INIT.ORA parameters, 6-12

improving performance, 6-2

increasing the transaction timeout parameter, 6-10

managing connection pooling, 6-3

U

user name

custom, A-2, A-6, A-7

MTSSYS, 3-4

operating system authenticated, A-12

V

variables, convention used, xviii

VCACCT.DLL, 4-2

building, 4-7

Visual C++

using with the Microsoft application demo, 4-5

vsa@us.oracle.com, xiii

W

Windows NT Explorer

correcting crashes, 7-5

Prev

Copyright © 1999 Oracle Corporation. All Rights Reserved.

Library Product Contents