Distributed transaction on Oracle Real Application Cluster database

This entry describes a solution for an exception occurred when trying to implement distributed transaction on Oracle Real Application Cluster database.

One of our partners got the following errors, while they were trying to test their .Net application on RAC.

Application Error / Event Log
System.Runtime.InteropServices.COMException (0x8004D00A): New
transaction cannot enlist in the specified transaction coordinator.

OR

SQL*Net Trace
ORA-24798: cannot resume the distributed transaction branch on another instance

//Environments
App. developed by Microsoft .Net
DB configured as a Oracle Real Application Cluster.(As well as there was no problem, when the partner created same workload on a single instance.)
They have 4 application server nodes and load balancing is active on app. side.
App. uses Microsoft Transaction Management Server
and OraOLEDB.Oracle provider calls distributed transactions.

For solution, I created more than one services then set preferred and
available instances for each service.

 -r "<preferred_list>"
 -a "<available_list>"

srvctl add service -d DB_UNIQUE_NAME -s SERVICE_NAME1 -r NODE1 -a NODE2
srvctl add service -d DB_UNIQUE_NAME -s SERVICE_NAME2 -r NODE2 -a NODE1

and fixed DTP => TRUE for these services.

execute dbms_service.modify_service (service_name => 'SERVICE_NAME1' ,dtp => true);
execute dbms_service.modify_service (service_name => 'SERVICE_NAME2' ,dtp => true);

We repeated to load same workload one more time using this service architecture and we did not get any error, it worked well!

Most of the errors caused by distributed transactions on RAC can be solved by this service settings.

Finally, very happily our solution has published as a support.oracle note to share with our partners and customers!

Article ID : 1443954.1 ORA-24798 Distributed Transaction Exception when Connecting to a RAC Instance from a Windows Application

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=BULLETIN&id=1443954.1

Sezgi.

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Oracle ECEMEA Partner Hubs Migration Center Team

We share our skills to maximize your revenue!
Our dedicated team of consultants can rapidly and successfully assist you to adopt and implement the latest of Oracle Technology in your solutions.

Stay Connected
partner.imc
@
beehiveonline.oracle-DOT-com
Google+

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
3
4
5
6
9
10
11
12
13
14
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today