![]() ![]() Microsoft APGC Internet Developer Support Team. In enterprise environments, customers sometimes need to set MSDTC transaction to work with remote Oracle target server. Because the cross- product setup is complicated, sometimes we may face Transaction Failure issue when updating data to a linked Oracle database, for example: Server: Msg 7. Level 1. 6, State 1, Line 1. The operation could not be performed because the OLE DB provider . On the Windows Server 2. Add/Remove Program” console, “Enable network dtc access” in Windows Components must be enabled. Enable it under Windows Components\Application Server\Enable Network dtc access. Refer to: 8. 17. 06. Troubleshooting BizTalk Server Dependencies Troubleshooting Problems with MSDTC. Services Management console. How to troubleshoot MSDTC transaction failure issue with. Contact MSDTC support team to get further. Msdtc.exe is the Micorosoft Distributed Transaction Coordinator console program. Msdtc.exe is a 32/64-bit executable for a graphics UI style application. The file msdtc.exe is the main component of the Microsoft Distributed Transaction Coordinator (MSDTC) by Microsoft Corporation. The Microsoft Distributed. How to enable network DTC access in Windows Server 2. EN- US; 8. 17. 06. Open DCOMCNFG, ensure the MSDTC settings are correct in the Security tab: 3. Open Registry table, in the Security key, ensure the Registry values matches the UI settings: HKEY. The Oracle modules configuration is correct in registry table: HKEY. To download this provider, visit the following Microsoft Web site: http: //www. Family. ID=4. F5. D4. 29- 1. 7DC- 4. EA- BFB3- 0. 76. D1. ![]() ![]() The Distributed Transaction Coordinator (MSDTC) service is a component of modern versions of Microsoft Windows that is responsible for coordinating transactions that.
C0. 52. 52. 4 (http: //www. Family. ID=4. F5. D4. 29- 1. 7DC- 4. EA- BFB3- 0. 76. D1. C0. 52. 52. 4)For other versions Oracle client (7/8) registry key settings, refer to: 1. Information about using Oracle with Microsoft Transaction Server and COM+ componentshttp: //support. EN- US; 1. 93. 89. Find the service name of the linked Oracle server from SQL management console, if you are not sure how to find the Oracle service name, please check with local Oracle admin team. Create an ODBC data source name (DSN) that refers to your Oracle database. Make sure that your DSN uses the Microsoft Oracle ODBC driver. Open Data Source dialog box from Administration Tools: b. Click the Add button in the User DSN tab, choose Microsoft ODBC for Oracle, and then complete the Wizard: Run this command, we should get the correct result, which means pure Oracle transaction working fine: Msdtcora. U< username to oracle> - P< password to oracle> - S< service name we found at step 5> The Msdtcora. Utility/1/NT5/EN- US/DTCOra. This tool will skip MSDTC and use Oracle Transaction directly. If the Oracle Test program can connect to your Oracle database server without error, it is very likely that COM+/MTS will also work with Oracle. If this step failed, should contact Oracle Support for more information. Make sure Network Service account (this is new account for MSDTC in Win. Oracle home folder, should do the same), force all sub objects inherit the same settings from parent folders. Otherwise the MSDTC service may fail to talk with Oracle libraries. You must install Oracle Services for Microsoft Transaction Server (Ora. MTS) from Oracle Client Installation package. After this, an Oracle MTS Recovery Service is also automatically installed on the same computer. If the transaction to Oracle still failed even step 6 returns successful information by Msdtcora, we should check if the pure MSDTC service working fine. You may raise MSDTC distributed transaction to other linked SQL server (the link SQL server should also follow steps 1,2,3) to see how things are going. Contact MSDTC support team to get further troubleshooting ideas if any difficulties happen. More Information==============2. How to set up and troubleshoot a linked server to an Oracle database in SQL Serverhttp: //support. EN- US; 2. 80. 10. Regards,Freist Li.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
October 2017
Categories |