??????? ??? ??????? Oracle ?? ?????? Microsoft Transaction Server ? + COM

?????? ????????? ?????? ?????????
???? ???????: 193893 - ??? ???????? ???? ????? ????? ??? ???????.
?????? ??? ?????? ????????? ??????? ??????? ????? ??????? Oracle ?? Microsoft COM + ??????? Microsoft Transaction Server (MTS) ? ??? ?? ??? ????? ??????? ???? ??????? ?? Microsoft Transaction Server (MTS) 2.0.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??????? COM + ???????? MTS ?? ?????? ??? 7 Oracle ? Oracle 8 8i Oracle ? ?????? ????? ???????? 9i Oracle. ???? ?????? ??? ?????? ????? ?????? Oracle ?? Microsoft Windows NT ? Windows 2000 UNIX ? ????? ????? ????. ???? ?????? ??? ?????? ?????? ????? Oracle ? Oracle ??????? ?????? ?????? Parallel Oracle.

?????? ????? ????? ?????? + COM ? MTS ?? ????????? ?????? ?? "???? ??????" ? ?? ???? ?????? ?? ??????? ?? "???? ??????" ???? ????? 8.1.7. ???? ???? ??????? ?????? ??? ???? Oracle 8.1.7 ??????? ???? ?? ???? Oracle. ??? ???? ??? ??????? ?????? Oracle ?????? ??? ???? ?? ?????????.

??????? ????

???? ??????? ??????? ????? ????????? ??????? ?? ???????? COM + ???????? MTS ????? ?? ????? ?????? Oracle. ?? ???? ??? ????? ?????? ??????? ???????? ?????? ?? ?? ???? ???????? ??? ?? ????? ????? ????? ?? ???????.

???? ??????? Windows 2000

?????? ?? ?? ???? ?????? COM + ????????? ?? Oracle ???? ??????? ???????:
  1. ????? Windows 2000.
  2. ????? "???? ??????" 8.1.7 ?? ??????? 8.1.7.1.5. ?????? ??? ??????? ??? ????? ????? ??? ????? ???? Oracle.
  3. ????? Net8 Oracle ?? ???? ?????????.
  4. ????? Microsoft Data Access Components (MDAC) 2.6 Service Pack 1 (SP1) ?? ??????? ??????.
  5. ????? ?????? ??????? ???????? ??????. ????? ?? ?????????? ???? "?????? 7: ?????? ??????? ?????? ???? ?????? Update."

Windows NT 4.0

?????? ?? ?? ???????? MTS ????????? ???? ?? Oracle ???? ??????? ???????:
  1. ????? Windows NT ?? SP6a ?? ??????? ??????.
  2. ????? "???? ??????" 8.1.7 ?? ??????? 8.1.7.1.5. ?????? ??? ??????? ??? ????? ????? ??? ????? ???? Oracle.
  3. ????? Net8 Oracle ?? ???? ?????????.
  4. ????? Windows NT Option Pack.
  5. ????? SP6a Windows NT.
  6. ????? MDAC 2.6 SP1 ?? ????.
  7. ????? ?????? ??????? ???????? ??????. ????? ?? ?????????? ???? "?????? 7: ?????? ??????? ?????? ???? ?????? Update."
????? ?? ????????? ??? ??????? ???? ??? "????? ??? Oracle".

?????? ???? ???? ????? ????????? ??????? ?? ??? ??????? ??????? ?? ????? ???? ??? ????? ???????. ???? ???? ???????? ???? ????????? ???????? ?? ???? ????? Microsoft ???????? Oracle. ?? ???? ????????? ??????? ?? ??? ???????? ???? ??? ????? ?? ??? ??????? ???? ????? ?? ??? ??????? ???? ??? ?? ???????.

????? ??? Oracle

?????? Oracle ????? ?? ????????? ?????? COM + ???????? MTS ???? ??????? ???????.

?????? 1: ?????? ???? ????? ?????? Oracle ?????

????? ?????? ???? ????? ?????? Oracle ??? ?????? ???? ????? ????????. ??? ??? ???? COM +/ ??????? MTS ??? ?????? ?????? Oracle ?? Windows NT ?? Windows 2000 UNIX? ???? ?? ????? Oracle ???? ???? ??? ??????. ?????? ??? ??? ????????? Oracle ?? Windows NT ?? Windows 2000 ?? ?????? ???? ????? Oracle ???????:
https://metalink.oracle.com
????? ?????? ??? ?????? ???? ??????? ??? ???? ?????? ??????. ????? ?? ??? ????????? ???? ??? ???? Oracle ?? ????? ?????? ???? MS Windows NT/2000 ????? ?????. ?????? ??? ??????? ??? ????? ????? ??? ????? ???? Oracle.

?????? ???? ?????? ???? Oracle ?COM +/ MTS ??? ????? ??????? ??????.
????? ??? ??????? XA Oracle
??? ??? ?????? Oracle 8 ?? 8i Oracle ? ?? ???? ???????? ?? ???:
  • ???? ?? ?? ????? ????? $ XATRANS $ V ?????? ????? DBA_PENDING_TRANSACTIONS ?? ?? ??????? ?? Oracle 8 ?? ????? ?????? 8i Oracle. ??? ???? ????? ????? ??? ??? ??????, ??? ?? ??????? ????? ?????? Oracle ?????? ????? ???????? ????? ???? ?????? Oracle ?????? XAVIEW.SQL. ???? ?????? ??? ??? ????? ?? ?????? \ADMIN Installation folder. ??? ?? ??? ????? ??? ???????? ????? SQL ??????? Oracle "????".
  • ??? ?? ???? ????? ?????? Oracle ??? ?????? SELECT ?????? ?????? ????? DBA_PENDING_TRANSACTIONS.
????? ????? ????????? ??????? ?????????
?? Oracle "???? ?????" ? ???? ??????? ???????:
  1. ?? ??????? ???? ??? ??? ????? ??????? ?? ???? ??? ?????? ????? ?? ????? ??????.
  2. ?? ????? ??????? ??? ?????? ??? ?? ?? ?????? ??????? distributed_transactions ?????? ?????????? MTS ???? ????????? ?????? ????? ???????? ?? ??? ?????.
????? ?? ?????????? ???? ?? "????? Oracle ???? ?????? ?? ???????" ??????.
????? ?????? ????????
?????? ??? ??? ???? COM +/ ?????? MTS ????? ????? ???? ????? ???? ????? ???? ??? ??????? ?????? ?????? Oracle ? ??? ??????? ?????? ????????. ?????? ??? ?? ??? ???? ????????? ????? ???? ????? ?????? ????? ?????? ???? ????? ?? ??? ????? ??? DSN. ?? ???? ????????? ??????? ?????? ???????? ?? ????? ???? ??? ??????.

?? ???? ??????? ?????? ???????? ??? ????? Microsoft ??????? ??????? ???? (MSDTC) ????? ??? ???? ????? ???? ????? ???? ???? ?????? ??????? ?????? ?????? Oracle. ??? ????? ??? ????? ??????? ????? ???????? MSDTC ???? ????? ???????? Oracle ?????? ???? ????????? ???????.

???? ?????? ???????? ?????? ?????? Oracle ????? ??? ?????? Windows NT ?? Windows 2000 ?????? ?? ??? ??????? ????? ????????. ????? ?????? ?? ????? ?????? ??? Oracle ??? ????? ???? ????? ?????? ?????? ?? ???? ??????. ???? ?????????? ???????? ???? ????? ???? ???? ????? ???? ????? ??? Windows NT ?? Windows 2000 ? Oracle.

?????? ?????? ??? ???? ??????? ???? ???????? ?? ????? ??????? ??? ?? ???? ???? (/). ?????? ???? ???? ???? ?????? ????? ??????:
cn.Open "PROVIDER=MSDAORA.1;DATA SOURCE=TESTORA;USER ID=/;PASSWORD=;"
??? ????? MSDTC / ?????? COM + ??? ???? ???? ?????? Microsoft ?????? ???? ??? MSDTC ???? ??? ????? ?? ???? ????? ?? ?????? ????? ?????? Microsoft Server ??????.

?????? ???? ????? ?????? ?? MSDTC ???? ??????? ???????:
  1. ???? ??? ???? ? ???? ??? ??????? ?? ???? ??? ???? ??????.
  2. ??? ????? ?????? ???????? "?????".
  3. ???? ????? ??????? ??? MSDTC.
  4. ???? ??? ????? ?????? ?? ?? ?? ?????? ???? ????? ???? ????? ????.

    ?????? ??????? ????? ????? ?????? Oracle ?????? ?? ????? ???? ????? ?????? ???? ????? ???? ????? ???????? Oracle.
?????? ??? ???? ?? ????????? ??? Oracle ????????? Windows NT ? Windows 2000 ?????? ??????? ? ???? ????? Oracle.
????? ???? Multi-Threaded Oracle ?????
??? ?? ???? ?????? ???? ???? Multi-Threaded Oracle ??? ??? ???? ?? ??? ?????? ????? ?????? ??? ????? ?????? Oracle ?? ???. ??? ?? ???? ?????? ??? ?????? ??? ????? ?????? Oracle ?????? ??? ??????? XA. ??? ?? ???? ????? ???????? Oracle ?????? ??? ??? ??????? XA ??? ???????? (?? ??? ??????) ? ???? ?? ???? ?? ???? ?? ?????? ??????? ???? ??????? ???. ????? ?? ???? ???? ??? ??????? ???? ?????? ??????? ?????? ???????? ???????. ????? ?????? ?????? ??? ?? ???? Multi-Threaded Oracle.

??? ?? ??? ????? ???? ???? Multi-Threaded Oracle ???? ????, Oracle ??????? ?? ????? ????? ???????:
24777 ORA: ?? ???? ????? migratable ????????
?????? ???? Oracle ??? ???? Server Multi-Threaded ?? ?????? Read Microsoft MTS. ??????? ?? ??? ??????? ???? ??? MTS Microsoft ?? ?????? Read MTS.
????? Oracle ???? ???? ?? ?????????
??? ???? ????? ???? ?? ??? ??????? dozen ?????? ?????? Oracle ??? ????? ???? Oracle ???? ??????? ????? ?????? ??????. ????? ?? ?????????? ???? "????? Oracle ???? ?????? ?? ???????" ?? ?????? "?????? Oracle ? MSDTC".

???? 2: Oracle ????? ?????? ?????? ?? ???? ?????????

????? ?????? ???? ?????? ?? ???? ????????? ??? ???? COM +/ MTS ??????. ???? Oracle 8.1.7 ? ?? ??????? ???? 8.1.7.1.5 ? ???? ???? ???? ?? COM ????????? +/ MTS ????????.

??? ???? ?? ????? Net8 Oracle ??? ????? "???? ??????" 8.1.7. ???????? ??? ???? ??? ??????? Oracle 8.1.7 ?? ??? ?????? ????? Oracle ?? MTS ??? ??? ?????? ????? ????? Microsoft OLEDB/ODBC. ????? Oracle ?? MTS ??? ????? COM +/ ?????? MTS ????? ???? ???? ?? ????? ?????? Oracle.

??????? ???? ????? ?????? ??? ????????? ??????? Oracle ??? ???? ????? ??? ????? ?????? Oracle ?????? ??? ???? ?? ???? ????? ????? ??????? Oracle ??? ?????? ???? ????? ??? ?????? ??? COM +/ MTS ????????. ?? ????? Oracle ?????? ?? ??????? ???? ???? ??? ??? ?????? ??????? XA. ??? ????? ???? ??????? ??????? Oracle COM ????? ?? +/ MTS ??????. ?????? ??? ??? ????????? Oracle ?? Windows NT ?? ?????? ???? ????? Oracle ???????:
https://metalink.oracle.com
????? ?????? ??? ?????? ???? ??????? ??? ???? ?????? ??????. ????? ?? ??? ????????? ???? ??? ???? Oracle ?? ????? ?????? ???? MS Windows NT/2000 ????? ?????. ?????? ??? ??????? ??? ????? ????? ??? ????? ???? Oracle.

?????? 3: ????? MTS 2.0

????? MTS 2.0. ?????? ????? ?? ?????? Windows NT 4 Option Pack. ??? ????? ??????? 2.0 MTS ??? ????? ??????? ???????:
  • 2.0 MTS ??? ?? ??? ??? .dll ????? ??????? Oracle Microsoft (OCI) (Mtxoci.dll)
  • ????? ????? ????? ODBC Microsoft 3.5
  • ????? ODBC Microsoft ?? Oracle
  • ?????? ?????? ActiveX (ADO)
?????? ????? ??? ?????? ????? ??????? Windows 2000.

?????? 4: ????? Windows NT 4.0 6a SP

????? ????? Windows NT 4.0 SP 6a ????? ??????? ?? ???????? ???????? XA MSDTC.

??? ??? ????? Windows NT 4.0 Option Pack ??? ????? Windows NT 4.0 SP 6a ????? ????? ?????? "???? NT 4.0 Service Pack ???????" ??? ?????? MTS MSDTC ??? ?? ?????? ????? Windows NT 4.0 Option Pack.

?????? ????? ??? ?????? ????? ??????? Windows 2000.

???? 5: ????? MDAC 2.6 SP1 ?? ????

????? MDAC 2.6 SP1 ?? ???? ??????? ?????? ????????? ???? ???? ????? ??????? Windows 2000. ?????? ??? MDAC 2.6 ?????? ????? ?????? SP1 ?? ????? ?? ?????? ???? Microsoft ?????? ??? ?????:
http://msdn2.microsoft.com/en-us/data/aa937712.aspx#MDAC

?????? ???????: ??????? Component Checker ?????? ?? ??? ???? ???? ??? ????? ?? ???????

??? ????? MDAC ????? ??????? Component Checker ?????? ?? ??? ???? ???? ??? ????? ?? ???????. ?? ????? ???? ???? ???????? ?? ????? ??????? ????? ????? ?????? ??????? ???? ???? ?? MDAC. ????? ???? ?????? ??? ????? ??????? ???????:
  • Windows 95
  • ???? ??????? Windows 98
  • Windows NT 4.0
  • ???? ??????? Windows 2000
??? ?????? ????? ??????? 32 ?? ? 64 ?? ???. ?? ????? ???? ???? ????? ???????? MDAC 2.6. ??? ????? ??? ??????? ?????? ????? ???? Microsoft ?????? ??? ?????:
http://msdn2.microsoft.com/en-us/data/aa937695.aspx

???? 7: ?????? ??????? ?????? "???? ??????" ?????

??? ??? ?????? ?? ????? ?? ?????? ??? ????? ?????? ?? ????? ????? ???????. ??? ???? ?? ???? ?????? ????? ?? ???? ????? ????? ?????? ??? ?????. ????? ???? ?? ???? ??????? ??????? ??????. ?????? ??? ??????? ??????? ??? ???? ???????? ?? ????? ??? ??????. ?? ????? ??????? ????? ?? ???? ???? ?????. ?????? ??? ???? ?? ????????? ??? ????? ??? ???? ???????? ?? ????? ????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
322756????? ??? ???? ???????? ? ??????? ??????? ?? Windows

?????? ??? ??????? ??? ????? ????? ??????? ???? ???????? ??????? ?? ??????? ???? ??????? ":
  • ????? ???????? ??????
  • ????? ??????? ?? ??????? ??????
  • ????? ?????? ???????
?????? ???? ????? ????? ????????? ??????? ??? ??????. ??? ??? ???? ?????? Windows NT ?? Windows 2000 ??? ????? ????? ???? ??? ??????? ?????? ??????? (ERD).

?? ???? ??????? ?????? ???? ?????? 8.1.7 ????? ??? ?????? ??????? ??????? ?????? ?? ???? ????? ??? ??????? ??? ???:
Oracle   Windows NT or Windows 9x           Windows 2000 
Client

8.1.7    [HKEY_LOCAL_MACHINE\SOFTWARE       [HKEY_LOCAL_MACHINE\SOFTWARE
         \Microsoft\Transaction Server      \Microsoft\MSDTC\MTxOCI]
         \Local Computer\My Computer]       "OracleXaLib"="oraclient8.dll" 
         "OracleXaLib"="oraclient8.dll"     "OracleSqlLib"="orasql8.dll"  
         "OracleSqlLib"="orasql8.dll"       "OracleOciLib"="oci.dll"
         "OracleOciLib"="oci.dll" 

Oracle   Windows Server 2003 
Client

9i       [HKEY_LOCAL_MACHINE\SOFTWARE
         \Microsoft\MSDTC\MTxOCI] 
         "OracleXaLib"="oraclient9.dll" 
         "OracleSqlLib"="orasql9.dll" 
         "OracleOciLib"="oci.dll"

?????? ??????? ???????? COM +/ ??? MTS Oracle

??? ????? ??? Oracle ???????? ??? ?? ???? ?? ????? Oracle. ????? ??????? ??????? ??????? ?????? ?? ??? ???????:
  • ???? ????? Oracle
  • ?????? ?????? Oracle
??????? ??? XA OCI Oracle ?????? ??? ??????? ??? COM +/ MTS ????????. ???? ???????? Oracle ?????? ?? ??? ??? ????? ??????? ????? ????? ?????? XA Oracle ??????? ?????? ?????? Oracle. ?????? ??? ??????? ?????? Oracle ???????? ??????? ????????. ?? ??? ???????? COM +/ MTS ?? MSDTC. ????? ??? ??????? ??? ??? ??? ??????? ?????? ?? ?????? Oracle ???? ??? ???? ????? ?? ?????. ??? ??? ???????? ????? ???????? ??? ???? ????? ????? ? Oracle ????? ????? ?? ??????? ?????? ??? Oracle ?????? ??? ???? ?? ?????????.

??? ?? ?? ????? ????? ??? ??????????, ????? ??????? ????? ??? ????? ??????? ?????? ??????? (???? ????? "??????? ??????? ??? ????? ?????? ?? ??? ??????? Oracle ????????"). ????? ????? ????? ??????? ????? ??????? ?????? ???????.

???? ????? Oracle

????? ??????? ?????? ??????? Oracle ?????? ??? ???:
  • ???? ?? ????? ?????? ??????? Oracle.
  • ?????? ??????? ???? Oracle.
?????? ??? ?????? ??????? Oracle
????? ????? ?????? ??????? ?? "???? ??????? ?? Microsoft":
?? ??? ??????????? ??? ??????
Download
Download the OraStress.exe package now.
?????? ??? ???? ?? ????????? ??? ????? ????? ????? ??? Microsoft? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
119591????? ?????? ??? ????? ??? Microsoft ?? ??????? ??? ??????
???? Microsoft ???? ??? ????? ????? ?? ?????????. ??????? Microsoft ???? ?? ?????? ??? ??????? ??????? ??? ??????? ???? ?? ??? ?????. ??? ????? ????? ??? ?????? ????? ?????? ???? ????? ??? ??? ????? ??? ??????? ??? ???? ?? ??? ?????.

????? ??????? ?????? ??????? ??????? C++ ????? ????????? ???????? ??????. ??? ??? ????? ????? ???? ??????? Oracle ???? ??? ???????? ?????? OracleStress.exe.
????? ???? ??????? Oracle
?????? ?????? ??????? Oracle ???? ??????? ???????.

?????? ????? ??????? ??????? ?????? ???????? OracleStress.exe.
  1. ???? ?? ????? ???? ??????? ?????? ???.
  2. ???? ???? ???????.
  3. ????? ?? ????????? ??? ????? ??????? ?????? ????? ???? ????? ?????? ??? ?????? ??? ???? OracleStress.exe ???? OracleStress.exe ?? ???? ??????? ?? ?? ???? ENTER.

    ???? ????????? ??????? ??? ??????:

    ???? ?????? ???????? ?? ???? OracleStress:<server>
    OracleStress.exe -S<server> -Q<SQL> [-U<username>] [-P<password>]
    [-T<threads>] [-I<iterations>] -[V<version>] [-N] [-W] [-O]
    [-F<Log File Name>]
    
    -S - Name of oracle server to connect to.
    -Q - SQL statement that each thread will execute.
    -U - Optional. Username. Defaults to "scott".
    -P - Optional. Password. Defaults to "tiger".
    -T - Optional. Number of threads to apply stress with. Defaults to "1".
    -I - Optional. Number of iterations per thread. Defaults to "100".
    -V - Optional. Version. Specifies Oracle version number. Can be one of: 7, 8, 8i, or 9i. Defaults to 8.
    -N - Optional. If specified, disables the use of XA transactions.
    -W - Optional. If specified, disables the display of warning level XA error messages.
    -O - Optional. If specified, open and close connection at each iteration.
    -F - Optional. Log file name. Defaults to "Ostress.txt". 
    ??????:
    C:>OracleStress -SMyOracleServer -Q"Insert into Order Values (1, 'My order')" -UMyUserName  
    -PMySpecialPassword -T10 -V8i
    ??????MyOracleServer ?? ??? ?????? ???? ???????. MyUserName ?? ??? ???????? ??? MySpecialPassword ???? ?????? ??????.
  4. ??? ??????? ???? ?? ?????? ????????? Ostress.txt. ???? ??? ?? Microsoft Notepad ?? ???? ??? ??? ????? ?????.
  5. ??? ????? ?? ????? ?????? ????? ????? Oracle ???? ?????? ??? Oracle ??? ??????? ??? ??????? COM +/ MTS ???????.
??????? ??? ??????? ?????? ??????? Oracle ?? ???? Oracle ?????? ???????
?? ???? ???????? ????????? ??????? ??? ??????? ?????? ??????? Oracle:
  • ??? ?? ???? ????? SQL ????? ?? ??????? ??????????? ?????? ??????? ?? ??????? ????? ??.
  • ??? ?????? ??????? (-T) ??? ?? ???? ???? ???? ?????? ???? ?????? ?? ????????? ????????? ???????? ?? ??????? ????? ??. ??? ???? ??????? ??? ??? ???? ?????? ???? ????????? ????????? ????? ?? ??????? ????? ?? 10, ??? ?? ???? ??? ?????? ??????? 30.
  • ????? ??? ???? ?? ????? ???????? ??? ?????? ??????? ????? ??????? ????????? ??????? ??????.
?????? ???? ????? Oracle ??????? ??? ???? ????? ?????? Oracle ???? ??? ? ??? ??????? ???? ?? ??? COM +/ MTS ???? ????? ?? Oracle. ?? ???? ????? ?????? ??????? Oracle ?? ??? ????? ? ??? ?? ???? ??????? ???????:
  1. ????? ????? ????? ???? ???? ??? ????? ?????? ???? ??????? Oracle.
  2. ??? ??? ?????? ?????? ???? ?? ??????? ????? ??? ?????? ?????? ??????? Oracle. ??????? ?????? Oracle ??????? ?? ????? *.trc. ????? ??? ?????? Oracle ??? ??????? ????? ??????? ?????? ?????? ?? ????? ???????.
  3. ???? ?????? ??? Oracle ?????? ??? ???? ?? ?????????.

?????? ?????? Oracle

??? ????? ??? Oracle ???????? ??? ??????? ?????? Oracle ?????? ?????? ?? ??? ????? Oracle. ????? ???????? ?????? Oracle ?? ?????? ??? ?? Windows NT ???? TestOracleXAConfig.exe ? ??? ????? ??????? Windows 2000 ?????? Msdtcora.exe.
?????? ??? ?????? ?????? Oracle ?? COM + ??? Windows 2000
????? ?????? ??? ????????? ???????? ?????? ?????????? ???????? ?????? ?? Platform SDK ?? ?? "???? ??????? ?? Microsoft".

????? ????? ?????? ??????? ?? "???? ??????? ?? Microsoft":
?? ??? ??????????? ??? ??????
Download
Download the Dtcora.exe package now.
?????? ??? ???? ?? ????????? ??? ????? ????? ????? ??? Microsoft? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
119591????? ?????? ??? ????? ??? Microsoft ?? ??????? ??? ??????
???? Microsoft ???? ??? ????? ????? ?? ?????????. ??????? Microsoft ???? ?? ?????? ??? ??????? ??????? ??? ??????? ???? ?? ??? ?????. ??? ????? ????? ??? ?????? ????? ?????? ???? ????? ??? ??? ????? ??? ??????? ??? ???? ?? ??? ?????.

?????? ????? ??????? ?????? TestOracleXAConfig.exe ?????? ?? ????? Oracle ??????? ??????? ???????? ???? ????? Oracle ??? ??? ???? ?????? ???? ????? ???? ?? Windows 2000. ??? ??? ???? ?????? Windows 2000 ??????? ???? Msdtcora.exe. ?????? ???? Msdtcora.exe ?????? ??????? ??????? ?? ?????? ?????? ??????? ?????? "???? ?????? ???????" ????? ??????? Windows 2000.
?????? ??? ?????? ?????? Oracle ?? MTS ??? Windows NT
?????? ??? ?? ?? "????????? ???????? ??????" ? "??? ?????? ??????? ?????? Oracle Oracle 8 ? Oracle ?????? ???????? ?????? ??? Oracle 7.3 ?? ?????? ????" ???? ??????? ?? Microsoft "??? ?????":
http://www.microsoft.com/downloads/details.aspx?FamilyId=791CA202-0641-426D-8977-4D639C8755B0
?????? ??? ????? ?????? ?????? Oracle 7 Oracle ???????? ??? ????? MTS. ????? ??????? ?????? ??????? ??????? C++ ????? ????????? ???????? ?????? ?? Oracle 8. ??? ??? ????? ????? ???????? ?????? Oracle ???? ??? ???????? ?????? TestOracleXaConfig.exe.
????? ???????? ?????? Oracle
?????? ????? ??????? ??????? ?????? ???????? TestOracleXaConfig.exe.
  1. ???? ?? ????? ???? ??????? ?????? ???.
  2. ????? ODBC ??? ???? ?????? (DSN) ???? ???? ??? ????? ???????? Oracle. ???? ?? ?? ???? DSN ?????? ?????? ????? ODBC Oracle Microsoft.
  3. ???? ?? ????? ??? XA Oracle.
  4. ??? ???? ??????? ???????? ?????? Oracle ?? ????????? ???? ????? ??? COM +/ ?????? MTS ?????? ??? ????? ?????? Oracle. ?????? ????? ?????? ?????? Windows ?????? ???? ?? ?? ???? ???? ????? *.trc. ??? ??? ?????? ?????? Oracle ????? ????? ?????? ??? ????? ???? ???????. ??? ??? ???? ???? ????? ?????? ????? ????? ????? ?????? ??? ?? ????? ?? ??????? ?????? ??????.
  5. ?? ???? ???????? ?? ?????? ?????? ?????? Oracle (Msdtcora.exe ?? TestOracleXaConfig.exe) ?? ?? ?????? ???? ???????? ???? Oracle ???? ?????? ?? service_name. ???? ????????? ??????? ??? ???? ??????? ??? ??? ?????? ??? Msdtcora.exe:
    C: > msdtcora.exe U <user id > -P <Password > -S <Service_Name as contained in the TNS file >
    ????? ????? ????????? ??????? ??? ??? ?????? ??? TestOracleXaConfig.exe:
    C: > TestOracleXaConfig.exe U <user id > -P <Password > -S <Service_Name as contained in the TNS file >
??? ??? ?????? ?????? ?????? ???? ?? ????? ???? ???????? ??????? ???????? ???? ??? ???????? ????????. ???? ?????? ?????? ??????? ??? ?? ????? ?????? ???? ???? ?? ??????? ??? ?? ??? ??? ?? ????? ?????.

?????? ???? ??????? ???????? ?????? Oracle ??? ???? ????? ?????? Oracle ???? ?????, ??? ??????? ???? ?? ??? COM +/ MTS ???? ????? ?? Oracle. ??? ??? ???????? ?????? Oracle ?? ??? ?????, ???? ??????? ???????:
  1. ????? ????? ????? ???? ???? ??? ????? ?????? ?????? ?????? Oracle.
  2. ??? ??? ?????? Oracle ?? ?????? ??? ????? ?????? ?????? Oracle. ??????? ?????? Oracle ??????? ?? ????? *.trc. ????? ??? ?????? Oracle ??? ??????? ????? ??????? ?????? ?????? ?? ????? ???????.
  3. ???? ?????? ??? Oracle ?????? ??? ???? ?? ?????????.

??????? ??????? ??? ????? ?????? ?? ??? ??????? Oracle ????????

??? ??????? ?????? Oracle ?????? ?????? ?? ??? ??????? Oracle ???????? ??? ???? ??????? ??????? ??? ????? ???? ?? ?????? ?? MTS ?????? ?? ??? ???? MTS ?????? ??? ????? ???????? Oracle.

??????? ??????? ??? ????? ?????? ?? ??? ??? Oracle

  1. ??????? ?????? ?????? Oracle ?????? MTS ?????? ?? ?? ?????? Oracle ???? ????? ???? ????. ??? ??? ???????? ?????? Oracle ?? ??? ?????, ??? ????? ??????? ??? ????????.
  2. ??? ???? ????? ???????? Oracle ????? ????. ??? ?????? ??????. ???? ?????? ?????? ????? ????? ???? ??????:
    Owner			    scott
    
    Name of Table              Account
    Column 1 Name              AccountNo of type  NUMBER
    Column 2 Name              Balance of type NUMBER 
    
  3. ????? ???? ???? ?? ???? ??? ?????. ???? ?????? ?????? ????? ????? ??????:
    AccountNo                  Balance
    
         1                      1000
         2                      1000 
  4. ??? ???? ????? ???????? Oracle ????? ????. ??? ?????? ???????. ???? ?????? ?????? ????? ????? ???? ????:
    Owner                       scott
    
    Name of Table               Receipt
    Column 1 Name               NextReceipt of type NUMBER 
  5. ????? ???? ???? ?? ?? ???? ??? ?????. ???? ?????? ?????? ????? ????? ??????:
    NextReceipt
    1000 
  6. ??????? ?????? ???????? ??????? ODBC ?????? ??? DSN. ??? ??? DSN MTSSamples ?? ????? ??? DSN ?????? ???? ???? ???????? ??????. ???? ?????? ?????? ????? ????? ???? ???? ???????? ??? ??? DSN:
    [ODBC]
    DRIVER=Microsoft ODBC for Oracle
    UID=scott
    PWD=mypassword
    ConnectString=myserver
    SERVER=myserver
  7. ??? ??? DSN ?? ?? ?????? ???? ??? ?????.

????? Oracle ? MSDTC

????? ???? ???????? MSDTC

????? ???? ???? ??????? Microsoft (MSDTC) ????????? ?? ??? ????? ?????? ?? ????? Windows NT "??" ????? Windows 2000. ?????? MSDTC ??? ????????? ??? ???? ????????? ?? ????? ?????? ??????? ?? XA ??? ?? ??? Oracle. ??? ??? ?????? ???? ???????? ??? ????? MSDTC ???? ??? ?????? ?? ?? MSDTC ?????? ???????? ?????? ??? ????????? ???? ?? ??????? ?? ??? ????? ?????? ?? ???????. ??? ??? ?????? ???? ???????? MSDTC ? MSDTC ?? ???? ?????? ??? ????????? ?? ??????? ????? ?????? ? ???? ????? ????? ??????? ?? ??? ????? Windows NT:
??? ???? ??????? XATM ????? ????? ??????? ?????
?????? ??? ???????? ???? ??????? ???????:
  1. ????? MSDTC.
  2. ????? ???? ???????? MSDTC ??? ?????? ???????. ????? ?? ???? ????? ????? ????? ?????? ??? ???????? ????????. ?????? ???? ???????? ????? ?????? ???? ??????? ???????:
    1. ?? "???? ??????" ? ?? ?????? ?????? ???????.
    2. ???? ????? ??????? ??? ??????? ?? MSDTC ?? ?? ?????? ???? ????? ?????? ??????.
  3. ????? ????? MS DTC.

????? Oracle ???? ?????? ?? ???????

??? ???? ????? ???? ?? ??? ??????? dozen ?????? ?????? Oracle ??? ????? ???? Oracle ???? ??????? ????? ?????? ??????. ?? ???? ??? ?????? ??? ?? ???? ???? ?? ???? ?? ??????? ???????:
  • ??? ??? ????????? SQLConnect.
  • ??? ?????? ??? ?????? ?????? ????????? ???? ?? ???? ???? ?? ???? ?? ??????? ??????? ?? ??? ?????? Oracle:
    • ??? ???? ???? ?? ????? ?????.
    • ??? ?????? TNS ??? ???? ??? ??????.
    • ????????? ??????? ????? ????.
  • ?? ???? ???? ????? ?????? ????? ????? ????????. ???? ??? ??????? ???? ??? ?? ??? ????? ???????? ????????? ????? ?? ??? ??? ????????? ??????.
  • ????? ??????? ????? ????????? ???? ??????? ??? ????????? ???????.
If you experience one or more of these problems, consider increasing the following Oracle server configuration parameters:
Oracle Configuration Parameter                        Recommended

Processes                                                Three times the maximum number                                                   
                                                         of connections you expect to make
                                                         to the database

Sessions                                                 (1.1 * PROCESSES) + 5

Transactions                                             (1.1 * SESSIONS)

Distributed_transactions                                 Transactions

Dml_locks                                                (4 * TRANSACTIONS)

MAX_TRANSACTION_BRANCHES                                 32 (OBSOLETE in Oracle 8i)

Open_cursors                                             1000

distributed_lock_timeout                                 300 (OBSOLETE in Oracle 8i)

Queuesize                                                Read Queuesize section 

????? ??? ???? ?????

??? ?? ???? ???? ?????? ??? ???? ???? ?????? ??? ??????? ????? ???????? ???? ??????? ????????? ???? ?????.

????? ??????? QUEUESIZE

?? ???? ??? ????? ??????? QUEUESIZE ?????? ???? Oracle ????? ???? ??? ??????? ?? ???? ????? ??? ????? ????????. ???? ??? ??????? ??? ????? ???? ????? ??? ???? ???? ?? ????? ??????? ????? ????? ???????? ?????? ???. ?????? ???? ????? ??? ????? ????? ????? ???????:
12541 ORA: ????? ??
????? ??? ???? ?? ????? ?????? ??? ????? ????? ???????:
econrefused
?????? ??? ???????? ???? ??????? ???????:
  1. ????? ??????? ???? Oracle ??? ?????? ???? ????? ??? ???? ????? ?????? Oracle.
  2. ????? ??????? QUEUESIZE ?? ??? Listener.ora ?? ??? Tnsnet.ora ?? ??? Names.ora ??? ???? ???? ????? ?????? Oracle.

    ?????? ????? ???? ??????? QUEUESIZE ???????? ??? ??? ????????? ????????? ?? ??????? ????????? ???? ?????. ?? ???????? ????? ???? ?????? ??????? QUEUESIZE ??? ?????? Oracle 7.3 ????? ???? ????? ????? ??? ????? ???????? ? Oracle 8 ?? 8i Oracle ???? ????? ????? ??? ????? ???????? ??? ????? ????? ???????? ????????? ??? ??????? ????? ??. ????? ???? ????? ?????? ???? Oracle ???? ?????? ?? ?? ????? ?????. ??? ???? ??????? ??????? ????? 100 ????? ????? Listener.ora ??? ???:
    QUEUESIZE = 100 
    
    
  3. ????? ????? ????? ???? Oracle.

???? ???? COM +/ ??? MTS Oracle

COM +/ MTS ? Oracle ??????? ?? MTS

????? Oracle ?? MTS ??? ????? COM +/ ????????? MTS ??? ??? ?????? ???? Microsoft OLEDB/ODBC. ?? ??? ?????? ????? Oracle ?? MTS ????? ????? ???? 8i Oracle. ??? ?? ????? ??? ??????? ?? ?? ?? ???? ????????? ???? ???? ??? ??? ?????? ????? Oracle ?? MTS ?? ???? Microsoft ODBC/OLE DB. ??????? ???? Oracle ???? ??? ????? ????? ???????? ????? Oracle ?? MTS.

8i Oracle ? ??????? OLE

???? 8i Oracle ??????? OLE. ????? ??? ?????? ??????? ?????? ????? ODBC Oracle. ???? Oracle ?????? ??? ??????? ??? ????? ???????? ??????? ??? ?????? ????????? ???????? ??? ????? ??? ???.

?????? ????? ODBC Oracle Microsoft ? Oracle 8

??????? ?? ???? ?????? ????? ODBC Oracle Microsoft (Msorcl32.dll) ?? ?????? ???? Compaq Alpha Oracle 8. ?? ??? ????? ??? ??????? ?? ????? ???????.

Ociw32.dll Oracle corrupts MSDTC ????? ??? ???????

???? ??? ??????? ????? ??? ?? MTS ? MSDTC ????? ??? Ociw32.dll Oracle ??? ???? ??????? ??????? ????? ??? ??? ?????? ????? ??? ????? ?? ?????? ?????? ?????? Oracle. ??? ??? MTS ????? ????? Mtxoci.dll ??? ??????? ????? ?? ?? ????? ??? ??? ????? ????? ?????? Oracle. ??? ??? MSDTC ????? ????? Mtxoci.dll ???? ?? ????? ??? ????? ??????? ????? ???????? Oracle. ???? ?? ???? ?????? MTS ?? ??? ??? ??????? ????? ?? ?? ???? ?? ??????? ????? ?????? Oracle ? ????? ????? ????? Ociw32.dll. ????? Ociw32.dll ????? ??? ????? ???? ?? ??????? ???? ??????? ???? ??? ????? Oracle ??? ????? Windows NT. Oracle ??? Windows NT ???? attaches ???? ???????. ???? Oracle ??? ?????? ???? ?? ?????? ???? ??????? ???? ??? ????? ???? ??????? ??? ????? ???????? ?? ?????? ????? ?????? ???? ????? ?????? ????? ??.

??????? ?????? ??? ??? ??????? ????? ????? ????? ?? ??? ??? .dll ??? ????? ?????? Oracle ?? Microsoft (Mtxoci.dll) ??? ??? ?? ?????? Oracle ?? MTS ?? MSDTC. ??? ??? MTS ? MSDTC ???? ?? ??? ?? ????? ??? Mtxoci.dll. ????? ??? Mtxoci.dll ?? ??? Ociw32.dll Oracle. ?????? ????? ???? ???? ??? ???? ?? ???? ????? ???? ????? ??? Mtxoci.dll MTS ? MSDTC. ??? ???? ?? ?????? ?????? ??? ?? ??????? ?????? ?????? Oracle ?? ???? ??? ???? ??? ????? .dll.

?????? ?????? ?? ??? ?? ??? ???? ??? ?????? ?? ????? Ociw32.dll ??? ????? ?? COM +/ MTS ??????. ??? ??? ???? ??? ??? ?? ??? ????? ????? ??? ???? ?? ??? .dll ??? ???? ???? ??? ?????.

???? Microsoft ??????? ??? ??????? ?????? ????? ???? ???????? ?? ?????? ??? ????? ??????. ?? ??? ????? ??????? ??? ??????? ??? ???? ?????. ??? ???? Microsoft ??? ??? ????????? ???? ???????.

?????? ?????? ?????? ???????? ?? ??? ??????? ???? ????? ?????? ?????? ?? Microsoft. ?? ???? Microsoft ?? ???? ? ?????? ?? ??????? ????? ???? ?? ???? ?????? "?? ??? ????????.

?????

????? ?? ?????????? ???? ??? ????? ???????? ??????? ?????? ?? "????? ??????? ?? Microsoft:
246006MTS ???????? TRC Oracle
230145FIX: ????? ?????? ????? Mtxoci.dll
191168??? "-2147168246 (8004d00a)" ??? ?????? ??? ??????? ?????? ??????
193941???? ???? FTP ??????? ????? Oracle

???????

???? ???????: 193893 - ????? ??? ??????: 28/????/1428 - ??????: 8.3
????? ???
  • Microsoft Transaction Services 2.0
  • Microsoft COM+ 1.0
????? ??????: 
kbmt kbdatabase kbinfo kboracle KB193893 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????193893
????? ??????? ?? ????? ???? ?? ????? ???????
?? ????? ????? ?????? ???? ???? ???? ??? ??????? ??? ?? ? ?? ??? ??????? Microsoft ??? ????? ??? ??????? ????? ?????? ?????

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com