Skip Headers
Oracle® Services for Microsoft Transaction Server Developer's Guide
11g Release 2 (11.2) for Microsoft Windows

E26104-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

Index

A  C  D  E  F  G  I  J  L  M  N  O  P  R  S  T  U  V 

A

administrator username
dropping, 6.6
Microsoft Transaction Server, 3.3.2.2

C

Component Object Model (COM)
marking components as transactional, 1.2
programming with Oracle Call Interface and Microsoft Transaction Server, 4.3
registering in a Microsoft Transaction Server environment, 4.2.1
running in a Microsoft Transaction Server
coordinated transaction, 4.2.2
running in an MS DTC-coordinated transaction, 4.2.3
using with Microsoft Oracle ODBC Driver, 4.4.3
using with the Oracle ODBC Driver and Microsoft Transaction Server, 4.4.2
computer on which Microsoft Transaction Server is installed
installation requirements, 2.1.1
computer on which Oracle Database is installed
installation requirements, 2.1.2
configuration requirements
modifying for Oracle Fail Safe, 3.5
on client computer, 3.1
on computer on which Microsoft Transaction Server is installed, 3.1
on computer on which Oracle Database is installed, 3.1
connection
managing connection pooling, 5.2
connection attribute
setting with ODBC, 4.4.1
connection pooling
client side registry parameters, 5.2
emptying connection pools, 6.2
managing connections, 5.2
obtaining service handles, 4.3.3
releasing connections, 4.3.4
using OraMTSSvcGet() function, 4.3.3
CREATE SESSION role, 3.3.2.2

D

Data Manipulation Language (DML)
using in shared server configurations, 6.3
database job-queue processes
starting, 3.3.2.1
DBMS_JOBS package, 3.3.2.2
DBMS_TRANSACTION package, 3.3.2.2
DCOM. See Distributed Component Object Model (DCOM)
differences with OraMTSJoinTxn() function, 4.3.6
Distributed Component Object Model (DCOM), 1.1
distributed transactions
in-doubt, 6.5
RAC support, 1.2.2
support for serializable isolation level, 1.2.4
DML. See Data Manipulation Language (DML)

E

Enterprise Services, 1.2.1

F

FORCE_ANY_TRANSACTION privilege, 3.3.2.2

G

getting started
with Microsoft Transaction Server and an Oracle Database, 1.3

I

in-doubt transactions
JOB_QUEUE_PROCESSES initialization parameter, 3.3.2.1
resolving, 3.2
scheduling automatic recovery, 3.3
starting database job-queue processes, 3.3.2.1
viewing, 3.4
initialization parameters
JOB_QUEUE_PROCESSES, 3.3.2.1
PROCESSES, 5.4
SESSIONS, 5.4
installation
of Oracle MTS Recovery Service, 2.1
installation requirements
for computer on which Microsoft Transaction Server is installed, 2.1.1
for computer on which Oracle Database is installed, 2.1.2
for computer running Oracle Fail Safe, 2.1
Microsoft Transaction Server, 2.1
Oracle Database Client, 2.1.1.1
Oracle Objects for OLE, 2.1.1.1
Oracle ODBC Driver, 2.1.1.1
Oracle Services for Microsoft Transaction Server, 2.1.1.1
required RAM, 2.1
Service Pack 5.0 or greater, 2.1.1.2
SQL*Plus, 2.1.2.1

J

JOB_QUEUE_PROCESSES initialization parameter, 3.3.2.1

L

local transactions
promoting, 1.2.3

M

Microsoft Distributed Transaction Coordinator (DTC), 1.2.1
Microsoft Distributed Transaction Coordinator (MS DTC)
COM components running in an MS DTC-coordinated transaction, 4.2.3
in a cluster, 3.5
starting, 5.6
using with Oracle Service for MTS, 2.1
Microsoft Transaction Server
benefits, 1.1
changing the administrator username, 3.3.2.2
COM components running in a transaction, 4.2.2
components running in an MS DTC-coordinated transaction, 4.2.3
creating the administrator user account, 3.3.2.2
definition, 1.1
getting started with an Oracle Database, 1.3
installation requirements, 2.1
integration with an Oracle Database, 1.2
programming with Microsoft Oracle ODBC Driver, 4.4
programming with Oracle Call Interface, 4.3
programming with Oracle ODBC Driver, 4.4
registering COM components, 4.2.1
scheduling transaction recovery, 3.3
starting MS DTC, 5.6
using with Microsoft Oracle ODBC Driver, 4.4.3
using with the Oracle ODBC Driver, 4.4.2
MTSSamples.dsn file
using with the Oracle ODBC Driver, 4.4.2
mtssys username
changing the password, 3.3.2.2
default administrator user account, 3.3.2.2
mtxstop.exe file
running, 6.2

N

net service name
changes that impact connection pool, 6.2
changes that impact connection pooling, 6.2
.NET, Enterprise Services, 1.2.1
nonpooled Oracle Call Interface connection
OraMTSJoinTxn function, 4.3.9

O

OCI_THREADED flag
passing, 4.3
OCIInitialize function
calling, 4.3
ODBC. See Open Database Connectivity (ODBC)
omtssamp.sql script, 4.4.3
Open Database Connectivity (ODBC)
configuring Microsoft Oracle ODBC Driver with Microsoft Transaction Server, 4.4.3
configuring the Oracle ODBC Driver with Microsoft Transaction Server, 4.4.2
Oracle ODBC Driver installation requirements, 2.1.1.1
programming with Microsoft Transaction Server, 4.4
setting the connection attribute, 4.4.1
using Microsoft Oracle ODBC Driver with Microsoft Transaction Server, 4.4.3
using the MTSSamples.dsn file with the Oracle ODBC Driver, 4.4.2
using the Oracle ODBC Driver with Microsoft Transaction Server, 4.4.2
using the SQL_ATTR_ENLIST_IN_DTC parameter, 4.4.1
using the SQLSetConnectAttr function, 4.4.1
Oracle Call Interface (OCI)
enlisting an MS DTC-coordinated transaction, 4.3.5
obtaining pooled or standard Oracle Call Interface connections, 4.3.5
obtaining pooled Oracle Call Interface connections, 4.3.3
OraMTSEnlCtxGet() function, 4.3.7
OraMTSEnlCtxGet() function parameters, 4.3.7
OraMTSJoinTxn() function, 4.3.9
OraMTSOCIErrGet() function, 4.3.11
OraMTSOCIErrGet() function parameters, 4.3.11
OraMTSSvcEnlist() function, 4.3.5
OraMTSSvcEnlist() function parameters, 4.3.5
OraMTSSvcGet() function, 4.3.3
OraMTSSvcGet() function parameters, 4.3.3
OraMTSSvcRel() function, 4.3.4
programming with Microsoft Transaction Server, 4.3
releasing pooled Oracle Call Interface connections, 4.3.4
Oracle Database
changing init.ora file parameter settings, 5.4
integration with Microsoft Transaction server, 1.2
Oracle Database Client
installation requirements, 2.1.1.1
Oracle Fail Safe
installation requirements, 2.1
modifying registry parameters, 3.5
Oracle MTS Recovery Service
installation, 2.1
resolving in-doubt transactions, 3.2
trace file output, 6.1
Oracle Objects for OLE (OO4O)
installation requirements, 2.1.1.1
Oracle Service for MTS
using with MS DTC, 2.1
Oracle Services for Microsoft Transaction, 3.1
Oracle Services for Microsoft Transaction Server
installation requirements, 2.1.1.1
oramts_2pc_pending
views, 3.3.2.2.4
ORAMTS_ABORT_MODE, 5.5
ORAMTS_CFLG_ALLDEFAULT flag
description, 4.3.3
ORAMTS_CFLG_SYSDBALOGN flag
description, 4.3.3
using, 4.3.3
ORAMTS_CFLG_SYSOPRLOGN flag
description, 4.3.3
using, 4.3.3
ORAMTS_CONN_POOL_TIMEOUT registry parameter, 5.2.1
ORAMTS_ENFLG_DEFAULT flag
description, 4.3.5, 4.3.6
ORAMTS_NET_CACHE_MAXFREE registry parameter, 5.2.1
ORAMTS_NET_CACHE_TIMEOUT registry parameter, 5.2.1, 5.2.1
ORAMTS_OSCREDS_MATCH_LEVEL registry parameter, 5.2.1
oramtsadmin.sql script
creating the Microsoft Transaction Server administrator user account, 3.3.2.2
creating the PL/SQL package, 3.3.2.2
oramts.dll file
definition, 6.1
OraMTSEnlCtxGet() function
Oracle Call Interface function, 4.3.7
OraMTSEnlCtxRel() function
destroying a previously set up enlistment context, 4.3.8
parameters, 4.3.8
returning ORAMTSERR_NOERROR, 4.3.8
syntax, 4.3.8
ORAMTSERR_ILLEGAL_OPER
returning upon acquiring a connection, 4.3.6
ORAMTSERR_ILLEGAL_OPER returning upon acquiring a connection, 4.3.6
ORAMTSERR_NOERROR
returning upon acquiring a connection, 4.3.5, 4.3.9
returning upon obtaining a connection, 4.3.3
returning upon releasing a connection, 4.3.4
OraMTSJoinTxn() function
enlisting a nonpooled Oracle Call Interface connection, 4.3.9
Oracle Call Interface function, 4.3.9
returning ORAMTSERR_NOERROR upon acquiring a connection, 4.3.9
syntax, 4.3.9
OraMTSOCIErrGet() function
parameters, 4.3.11
retrieving the Oracle Call Interface error code, 4.3.11
syntax, 4.3.11
OraMTSSvcEnlist() function
enlisting pooled or standard Oracle Call Interface connections, 4.3.5
Oracle Call Interface function, 4.3.5
ORAMTS_ENFLG_DEFAULT flag, 4.3.5, 4.3.6
parameters, 4.3.5
restrictions on use, 4.3.5
returning ORAMTSERR_NOERROR upon acquiring a connection, 4.3.5
syntax, 4.3.5
OraMTSSvcEnlistEx() function
restrictions on use, 4.3.6
returning ORAMTSERR_ILLEGAL_OPER upon acquiring a connection, 4.3.6
syntax, 4.3.6
OraMTSSvcGet() function
Oracle Call Interface function, 4.3.3
ORAMTS_CFLG_ALLDEFAULT flag, 4.3.3
ORAMTS_CFLG_SYSDBALOGN flag, 4.3.3
ORAMTS_CFLG_SYSOPRLOGN flag, 4.3.3
overview, 4.3
parameters, 4.3.3
responsibilities, 4.3.3
returning a pooled connection, 4.3.3
returning ORAMTSERR_NOERROR upon acquiring a connection, 4.3.3
syntax, 4.3.3
OraMTSSvcRel() function
Oracle Call Interface function, 4.3.4
overview, 4.3
releasing a pooled connection, 4.3.4
returning ORAMTSERR_NOERROR upon releasing a connection, 4.3.4
syntax, 4.3.4
OraMTSTransTest() function
syntax, 4.3.10
ORAOCI registry parameter
setting, 4.4.3

P

packages
DBMS_JOBS, 3.3.2.2
DBMS_TRANSACTION, 3.3.2.2
passwords
changing for mtssys username, 3.3.2.2
pooled connection
releasing, 4.3.4
privileges
FORCE_ANY_TRANSACTION, 3.3.2.2
of administrator user account, 3.3.2.2
utl_oramts.sql script, 3.3.2.2
PROCESSES initialization parameter
changing the value, 5.4
programming methods
optimizing to improve performance, 5.1
promotable local transactions, 1.2.3
prvtoramts.plb file, 3.3.2
public procedures
exposing, 3.3.2.2
recover_automatic, 3.3.2.2.2
show_indoubt, 3.3.2.2.1
utl_oramts.forget_RMs, 3.3.2.2.3

R

Real Application Clusters (RAC), 1.2.2
recover_automatic
public procedure, 3.3.2.2.2
recovery
of in-doubt transactions, 3.2
registry
modifying values for Oracle Fail Safe configurations, 3.5
trace file settings, 6.1
registry parameters
modifying for Oracle Fail Safe, 3.5
ORAMTS_CONN_POOL_TIMEOUT, 5.2.1
ORAMTS_NET_CACHE_MAXFREE, 5.2.1
ORAMTS_NET_CACHE_TIMEOUT, 5.2.1, 5.2.1
ORAMTS_OSCREDS_MATCH_LEVEL, 5.2.1
registry variables
ORAMTS_ABORT_MODE, 5.5
roles
CREATE SESSION, 3.3.2.2
of administrator user account, 3.3.2.2
SELECT_CATALOG_ROLE, 3.3.2.2

S

SELECT_CATALOG_ROLE role, 3.3.2.2
serializable transactions, 1.2.4
service handles, 4.3.3
Service Pack 5.0 or greater
installation requirements, 2.1.1.2
SESSIONS initialization parameter
changing the value, 5.4
shared server configurations, 6.3
show_indoubt
public procedure, 3.3.2.2.1
SQL*Plus
installation requirements, 2.1.2.1

T

three-tiered architecture, 1.1
tnsnames.ora file
setting for shared server configurations, 6.3
trace files
filename conventions, 6.1
Oracle MTS Recovery Service, 6.1
oramts.dll, 6.1
registry settings, 6.1
using, 6.1
transaction recovery
JOB_QUEUE_PROCESSES initialization parameter, 3.3.2.1
Oracle Fail Safe environment, 3.2
overview, 3.2
scheduling, 3.3
starting database job-queue processes, 3.3.2.1
troubleshooting, 3.4
transactions
ensuring consistency across data resources, 1.2.1
transparent RAC support of distributed transactions, 1.2.2
troubleshooting
correcting Oracle Net changes that impact connection pooling, 6.2
dropping the administrator user account, 6.6
starting MS DTC, 5.6
transaction recovery, 3.4
using trace files, 6.1
tuning
change, 5.4
managing connection pooling, 5.2
two-phase commit protocol, 6.5

U

utl_oramts PL/SQL package
exposing public procedures, 3.3.2.2
utl_oramts.forget_RMs
public procedure, 3.3.2.2.3
utl_oramts.sql script, 3.3.2
privileges and roles granted, 3.3.2.2

V

views
oramts_2pc_pending, 3.3.2.2.4