Configure Oracle to support MTS distributed transactions

Source: Internet
Author: User
1. According to Q193893, we need to build two views within Oracle.

Information about using Oracle with Microsoft Transaction Server and COM + components
http://support.microsoft.com/?id=193893

Based on our past experience, we can try to run Oracle's own scripts with the SYS account. The default path for the script is:
C:oracleora92dbmsadminxaview.sql

Please run the script in SQL Plus.

2. The above command will create two views. We also need to manually add public permissions to these two newly established 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;

The above operation is done on the computer where the Oracle database resides. The following actions are performed on a computer that deploys a COM + component:

1. According to Q193893, we need to revise the registry:

Hkey_local_machinesoftwaremicrosoftmsdtcmtxoci

"OracleXaLib" = "Oraclient9.dll"
"OracleSqlLib" = "Orasql9.dll"
"OracleOciLib" = "Oci.dll"

If it is Windows 2003 or Windows XP2, we also need to build:

Hkey_local_machinesoftwaremicrosoftmsdtcxadll

Then add the name:
The Mtxoci.dll string key, which reads:

C:windowssystem32mtxoci. Dll

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.