How to load _OraMTS_ into Oracle database

[seedfox]

The operation on the Oracle database machine:

1.According to KB 193893, create two views in Oracle, please use the SYS account.

The default path is : oracleora92rdbmsadminxaview

2.Add public authority to the new views:

SQL>grant select on v$xatrans$ to public with grant option;

SQL>grant select on v$pending_xatrans$ to public with grant option;

SQL>grant select any table to public;

Do the following on the computer which has the deployment of COM+ components:

1.According to KB 193893, modify the registry:

HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSDTCMTxOCI

“OracleXaLib”=”oraclient9.dll”

“OracleSqlLib”=”orasql9.dll”

“OracleOciLib”=”oci.dll”

If it is Windows 2003 or Windows XP, we also need to set up:

HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSDTCXADLL

Then, add the name: mtxoci.dll string keys

The content is: C:WINDOWSSYSTEM32MTXOCI.DLL

2. If you are using Windows 2003 or Windows XP, We need to set MSDTC account the corresponding authority. MSDTC is running on the Network Service account. Please add the Network Service account to the Administrators group inside.

3. Copy msvcrtd.dll to C:windowssystem32

4. Restart. Operate procedures.