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 1
    • Microsoft Transaction Server 1

C

  • Component Object Model (COM)
    • marking components as transactional 1
    • programming with Oracle Call Interface and Microsoft Transaction Server 1
    • registering in a Microsoft Transaction Server environment 1
    • running in a Microsoft Transaction Server
      • coordinated transaction 1
    • running in an MS DTC-coordinated transaction 1
    • using with Microsoft Oracle ODBC Driver 1
    • using with the Oracle ODBC Driver and Microsoft Transaction Server 1
  • computer on which Microsoft Transaction Server is installed
    • installation requirements 1
  • configuration requirements
    • on client computer 1
    • where Microsoft Transaction Server is installed 1
    • where Oracle Database is installed 1
  • connection
    • managing connection pooling 1
  • connection attribute
    • setting with ODBC 1
  • connection pooling
    • client side registry parameters 1
    • emptying connection pools 1
    • managing connections 1
    • obtaining service handles 1
    • releasing connections 1
    • using OraMTSSvcGet() function 1
  • CREATE SESSION role 1

D

  • database job-queue processes
    • starting 1
  • Data Manipulation Language (DML)
    • using in shared server configurations 1
  • DBMS_JOBS package 1
  • DBMS_TRANSACTION package 1
  • DCOM
    • See: Distributed Component Object Model (DCOM)
  • differences with OraMTSJoinTxn() function 1
  • Distributed Component Object Model (DCOM) 1
  • distributed transactions
    • in-doubt 1
    • RAC support 1
    • support for serializable isolation level 1
  • DML
    • See: Data Manipulation Language (DML)

F

  • FORCE_ANY_TRANSACTION privilege 1

G

  • getting started
    • with Microsoft Transaction Server and an Oracle Database 1

I

  • in-doubt transactions
    • JOB_QUEUE_PROCESSES initialization parameter 1
    • resolving 1
    • scheduling automatic recovery 1
    • starting database job-queue processes 1
    • viewing 1
  • initialization parameters
    • JOB_QUEUE_PROCESSES 1
    • PROCESSES 1
    • SESSIONS 1
  • installation requirements
    • for computer on which Microsoft Transaction Server is installed 1
    • installation requirements
      • for computer running Oracle Fail Safe 1
    • Microsoft Transaction Server 1
    • Oracle Database Client 1
    • Oracle ODBC Driver 1
    • Oracle Services for Microsoft Transaction Server 1
    • Service Pack 5.0 or greater 1

J

  • JOB_QUEUE_PROCESSES initialization parameter 1

L

  • local transactions
    • promoting 1
  • Local User, Domain User, Managed Services Account 1

M

  • Microsoft Distributed Transaction Coordinator (DTC) 1
  • Microsoft Distributed Transaction Coordinator (MS DTC)
    • COM components running in an MS DTC-coordinated transaction 1
    • in a cluster 1
    • starting 1
  • Microsoft Transaction Server
    • benefits 1
    • changing the administrator username 1
    • COM components running in a transaction 1
    • components running in an MS DTC-coordinated transaction 1
    • creating the administrator user account 1
    • definition 1
    • getting started with an Oracle Database 1
    • installation requirements 1
    • integration with an Oracle Database 1
    • programming with Microsoft Oracle ODBC Driver 1
    • programming with Oracle Call Interface 1
    • programming with Oracle ODBC Driver 1
    • registering COM components 1
    • scheduling transaction recovery 1
    • starting MS DTC 1
    • using with Microsoft Oracle ODBC Driver 1
    • using with the Oracle ODBC Driver 1
  • MTS Recovery Service 1
  • MTSSamples.dsn file
    • using with the Oracle ODBC Driver 1
  • mtssys username
    • changing the password 1
    • default administrator user account 1
  • mtxstop.exe file
    • running 1

N

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

O

  • OCI_THREADED flag
    • passing 1
  • OCIInitialize function
    • calling 1
  • ODBC
    • See: Open Database Connectivity (ODBC)
  • omtssamp.sql script 1
  • Open Database Connectivity (ODBC)
    • configuring Microsoft Oracle ODBC Driver with Microsoft Transaction Server 1
    • configuring the Oracle ODBC Driver with Microsoft Transaction Server 1
    • Oracle ODBC Driver installation requirements 1
    • programming with Microsoft Transaction Server 1
    • setting the connection attribute 1
    • using Microsoft Oracle ODBC Driver with Microsoft Transaction Server 1
    • using the MTSSamples.dsn file with the Oracle ODBC Driver 1
    • using the Oracle ODBC Driver with Microsoft Transaction Server 1
    • using the SQL_ATTR_ENLIST_IN_DTC parameter 1
    • using the SQLSetConnectAttr function 1
  • Oracle Call Interface (OCI)
    • enlisting an MS DTC-coordinated transaction 1
    • obtaining pooled Oracle Call Interface connections 1
    • obtaining pooled or standard Oracle Call Interface connections 1
    • OraMTSEnlCtxGet() function 1
    • OraMTSEnlCtxGet() function parameters 1
    • OraMTSJoinTxn() function 1
    • OraMTSOCIErrGet() function 1
    • OraMTSOCIErrGet() function parameters 1
    • OraMTSSvcEnlist() function 1
    • OraMTSSvcEnlist() function parameters 1
    • OraMTSSvcGet() function 1
    • OraMTSSvcGet() function parameters 1
    • OraMTSSvcRel() function 1
    • programming with Microsoft Transaction Server 1
    • releasing pooled Oracle Call Interface connections 1
  • Oracle Database
    • changing init.ora file parameter settings 1
    • integration with Microsoft Transaction server 1
  • Oracle Database Client
    • installation requirements 1
  • Oracle Fail Safe 1, 2
    • installation requirements 1
    • modifying registry parameters 1
  • Oracle Home User 1
  • Oracle MTS Recovery Service
    • resolving in-doubt transactions 1
    • trace file output 1
  • Oracle Recovery MTS Service 1
  • Oracle Services for Microsoft Transaction 1
  • Oracle Services for Microsoft Transaction Server
    • installation requirements 1
  • oramts_2pc_pending
    • views 1
  • ORAMTS_ABORT_MODE 1
  • ORAMTS_CFLG_SYSDBALOGN flag
    • using 1
  • ORAMTS_CFLG_SYSOPRLOGN flag
    • using 1
  • ORAMTS_CONN_POOL_TIMEOUT registry parameter 1
  • ORAMTS_NET_CACHE_MAXFREE registry parameter 1
  • ORAMTS_NET_CACHE_TIMEOUT registry parameter 1
  • ORAMTS_OSCREDS_MATCH_LEVEL registry parameter 1
  • oramts.dll file
    • definition 1
  • oramtsadmin.sql script
    • creating the PL/SQL package 1
  • OraMTSEnlCtxGet() function
    • Oracle Call Interface function 1
  • OraMTSEnlCtxRel() function
    • destroying a previously set up enlistment context 1
    • parameters 1
    • returning ORAMTSERR_NOERROR 1
    • syntax 1
  • ORAMTSERR_ILLEGAL_OPER
    • returning upon acquiring a connection 1
  • ORAMTSERR_NOERROR
    • returning upon acquiring a connection 1, 2
    • returning upon obtaining a connection 1
    • returning upon releasing a connection 1
  • OraMTSJoinTxn() function
    • enlisting a nonpooled Oracle Call Interface connection 1
    • Oracle Call Interface function 1
    • returning ORAMTSERR_NOERROR upon acquiring a connection 1
    • syntax 1
  • OraMTSOCIErrGet() function
    • parameters 1
    • retrieving the Oracle Call Interface error code 1
    • syntax 1
  • OraMTSSvcEnlist() function
    • enlisting pooled or standard Oracle Call Interface connections 1
    • Oracle Call Interface function 1
    • parameters 1
    • restrictions on use 1
    • returning ORAMTSERR_NOERROR upon acquiring a connection 1
    • syntax 1
  • OraMTSSvcEnlistEx() function
    • restrictions on use 1
    • returning ORAMTSERR_ILLEGAL_OPER upon acquiring a connection 1
    • syntax 1
  • OraMTSSvcGet() function
    • Oracle Call Interface function 1
    • overview 1
    • parameters 1
    • responsibilities 1
    • returning a pooled connection 1
    • returning ORAMTSERR_NOERROR upon acquiring a connection 1
    • syntax 1
  • OraMTSSvcRel() function
    • Oracle Call Interface function 1
    • overview 1
    • releasing a pooled connection 1
    • returning ORAMTSERR_NOERROR upon releasing a connection 1
    • syntax 1
  • OraMTSTransTest() function
    • syntax 1
  • ORAOCI registry parameter
    • setting 1

P

  • packages
    • DBMS_JOBS 1
    • DBMS_TRANSACTION 1
  • passwords
    • changing for mtssys username 1
  • pooled connection
    • releasing 1
  • privileges
    • FORCE_ANY_TRANSACTION 1
    • of administrator user account 1
    • utl_oramts.sql script 1
  • PROCESSES initialization parameter
    • changing the value 1
  • programming methods
    • optimizing to improve performance 1
  • promotable local transactions 1
  • public procedures
    • recover_automatic 1
    • show_indoubt 1
    • utl_oramts.forget_RMs 1

R

  • Real Application Clusters (RAC) 1
  • recover_automatic
    • public procedure 1
  • recovery
    • of in-doubt transactions 1
  • registry
    • modifying values for Oracle Fail Safe configurations 1
    • trace file settings 1
  • registry parameters
    • modifying for Oracle Fail Safe 1
    • ORAMTS_CONN_POOL_TIMEOUT 1
    • ORAMTS_NET_CACHE_MAXFREE 1
    • ORAMTS_NET_CACHE_TIMEOUT 1
    • ORAMTS_OSCREDS_MATCH_LEVEL 1
  • registry variables
    • ORAMTS_ABORT_MODE 1
  • roles
    • CREATE SESSION 1
    • of administrator user account 1
    • SELECT_CATALOG_ROLE 1

S

  • SELECT_CATALOG_ROLE role 1
  • serializable transactions 1
  • service handles 1
  • Service Pack 5.0 or greater
    • installation requirements 1
  • SESSIONS initialization parameter
    • changing the value 1
  • shared server configurations 1
  • show_indoubt
    • public procedure 1

T

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

U

  • utl_oramts.forget_RMs
    • public procedure 1

V

  • views
    • oramts_2pc_pending 1

W

  • Windows User Account 1