1. Index

Index

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

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.2
  • configuration requirements
    • on client computer 3.1
    • where Microsoft Transaction Server is installed 3.1
    • where 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

  • database job-queue processes
  • Data Manipulation Language (DML)
    • using in shared server configurations 6.3
  • 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)

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
  • installation requirements
    • for computer on which Microsoft Transaction Server is installed 2.2
    • installation requirements
      • for computer running Oracle Fail Safe 2.1
    • Microsoft Transaction Server 2.1
    • Oracle Database Client 2.2.1
    • Oracle ODBC Driver 2.2.1
    • Oracle Services for Microsoft Transaction Server 2.2.1
    • Service Pack 5.0 or greater 2.2.2

J

  • JOB_QUEUE_PROCESSES initialization parameter 3.3.2.1

L

  • local transactions
  • Local User, Domain User, Managed Services Account 2.1

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
  • 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
  • MTS Recovery Service 2.4
  • 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

N

  • net service name
    • changes that impact connection pool 6.2
    • changes that impact connection pooling 6.2
  • nonpooled Oracle Call Interface connection
    • OraMTSJoinTxn function 4.3.9

O

  • OCI_THREADED flag
  • OCIInitialize function
  • 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.2.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 Oracle Call Interface connections 4.3.3
    • obtaining pooled or standard Oracle Call Interface connections 4.3.5
    • 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.2.1
  • Oracle Fail Safe 3.1, 3.5
    • installation requirements 2.1
    • modifying registry parameters 3.5
  • Oracle Home User 2.1
  • Oracle MTS Recovery Service
    • resolving in-doubt transactions 3.2
    • trace file output 6.1
  • Oracle Recovery MTS Service 2.4
  • Oracle Services for Microsoft Transaction 3.1
  • Oracle Services for Microsoft Transaction Server
    • installation requirements 2.2.1
  • oramts_2pc_pending
  • ORAMTS_ABORT_MODE 5.5
  • ORAMTS_CFLG_SYSDBALOGN flag
  • ORAMTS_CFLG_SYSOPRLOGN flag
  • ORAMTS_CONN_POOL_TIMEOUT registry parameter 5.2.1
  • ORAMTS_NET_CACHE_MAXFREE registry parameter 5.2.1
  • ORAMTS_NET_CACHE_TIMEOUT registry parameter 5.2.1
  • ORAMTS_OSCREDS_MATCH_LEVEL registry parameter 5.2.1
  • oramts.dll file
    • definition 6.1
  • oramtsadmin.sql script
    • creating the PL/SQL package 3.3.2.2
  • 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_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
  • OraMTSSvcEnlist() function
    • enlisting pooled or standard Oracle Call Interface connections 4.3.5
    • Oracle Call Interface function 4.3.5
    • 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
    • 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
  • ORAOCI registry parameter

P

  • packages
  • passwords
    • changing for mtssys username 3.3.2.2
  • pooled connection
  • privileges
  • PROCESSES initialization parameter
    • changing the value 5.4
  • programming methods
    • optimizing to improve performance 5.1
  • promotable local transactions 1.2.3
  • public procedures

R

  • Real Application Clusters (RAC) 1.2.2
  • recover_automatic
  • 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
    • ORAMTS_OSCREDS_MATCH_LEVEL 5.2.1
  • registry variables
    • ORAMTS_ABORT_MODE 5.5
  • roles

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.2.2
  • SESSIONS initialization parameter
    • changing the value 5.4
  • shared server configurations 6.3
  • show_indoubt

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.forget_RMs

V

W

  • Windows User Account 2.1