"Translated from MOS article" Services and Distributed Transaction Processing (DTP) in RAC

From:

Services and distributed Transaction processing in Oracle RAC (DTP) (document ID 1307751.1)

Applies To:Oracle database-enterprise edition-version 10.2.0.1 to 10.2.0.5 [Release 10.2]
information in this document applies to any platform.
Symptoms

You could find the following message in alert log when application servers which perform distributed transactions connects T o the database at first.

"Running distributed transactions in RAC without DTP service." Cause

If you is running any kind of distributed transactions, the service that the application uses to connect to the RAC Datab ASE should is enabled for DTP. This keeps all parts of a distributed transaction in the same instance, and allows the service to migrate to a new Instanc E In case of instance failure.

NOTE:DTP Services is not needed in 11.2. As long as the database initialization parameter global_txn_processes is greater than zero,oracle11.2 allows different bra Nches of the same global transaction to span multiple RAC instances.

Solution

1.Check for what services does you have enabled?:

SELECT * from V$active_services;

2. Enable all services for the application which uses DTP:

EXECUTE Dbms_service. Modify_service (service_name = ", dtp=>true);

Or alternately you can use Oracle Enterprise Manager or SRVCTL to modify the DTP property of the singleton service. Set the DTP option (-X) for the service to TRUE
(The default value is FALSE).

The following example shows how to modify the Xa_01.example.com service using SRVCTL:

Srvctl Modify service-d crm-s xa_01.example.com-x TRUE

Please see the following for more information:

Oracle Database Oracle Clusterware and Oracle Real application Clusters Administration and Deployment guide 10g Release 2 (10.2) Part number b14197-09
6 Introduction to Workload Management
Services and distributed Transaction processing in Oracle RAC


Oracle Database Advanced Application Developer ' s Guide
11g Release 2 (11.2)
Part number e25518-03
Developing applications with Oracle XA

"Translated from MOS article" Services and Distributed Transaction Processing (DTP) in RAC