What is oracle services for microsoft transaction server

Oracle Data Provider for. DTC implements a two-phase commit protocol that makes sure that the transaction outcome is consistent across all data resources involved in a transaction. With Oracle Database Release Previously developers needed to manually manage this process, individually redirecting all the branches to a single Oracle RAC instance. Promotable local transactions allow all transactions to remain local until more than one database is brought into the transaction, at which point, they are promoted to distributed transactions.

The flexibility of the promotable transaction feature ensures more efficient resource usage for transactional applications. Distributed transactions require significant overhead versus local transactions. Therefore, local transactions are preferred if only one database is used. At design-time, it may not be known when transactions are local or distributed. Prior to this feature, developers always had to use distributed transactions, even if local ones occurred most of the time, leading to unnecessary resource usage.

This feature is supported with Oracle Database 11 g Release 1 and higher. Earlier database versions and other resource managers can participate in a promotable transaction as long as the first connection is to an Oracle Database 11 g Release 1 data source or higher.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Learn more. Asked 1 year, 4 months ago.

Active 1 year, 4 months ago. Viewed 2k times. Improve this question. RazorWing RazorWing 35 5 5 bronze badges. Did you try to specify the IP address of the host as the message suggests, or, if possible, to specify hostname without domain? I have tried installing with a response file and through the wizard neither of which seem to allow you to specify additional installation commands for oramtsctl.

This issue never came up when using the 11g or 12c client installation. Add a comment. Active Oldest Votes. Improve this answer. Sign up or log in Sign up using Google.