Oracle Database cannot load _ OraMTS _

Operate on the Oracle database machine:

◆ 1. Create two views in Oracle Based on KB 193893. Use the SYS account.

The default script path is oracleora92rdbmsadminxaview.

◆ 2. After creating two views, you need to add Public permissions to these two newly created 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;

On the computer where the COM component is deployed, perform the following operations:

◆ 1. Modify the registry according to KB 193893:

HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSDTCMTxOCI

"OracleXaLib" = "oraclient9.dll"

"OracleSqlLib" = "orasql9.dll"

"OracleOciLib" = "oci. dll"

For Windows 2003 or Windows XP2

HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSDTCXADLL

Then add the following name:

String key of mtxoci. dll

Content: C: WINDOWSSYSTEM32MTXOCI. DLL

◆ 2. If you are on Windows 2003 or Windows XP, we need to set the corresponding permissions for the MSDTC account. MSDTC runs under the Network Service account. Add the Network Service account to the Administrators group.

◆ 3. Copy msvcrtd. dll to C: windowssystem32

◆ 4. Restart. Run the program.