【翻译自mos文章】services与rac中的 Distributed Transaction Processing (DTP)

最新推荐文章于 2021-04-25 23:53:19 发布

翻译最新推荐文章于 2021-04-25 23:53:19 发布 · 2.4k 阅读

Oracle DB 同时被 3 个专栏收录

772 篇文章

订阅专栏

MOS文章翻译

86 篇文章

订阅专栏

dtp

1 篇文章

订阅专栏

本文解决Oracle RAC环境下使用分布式事务处理时出现的警告问题，通过检查和启用服务来确保分布式事务在同一个实例中运行，并能平滑迁移至新实例，避免因实例故障导致的问题。

来源于：

Services and Distributed Transaction Processing in Oracle RAC(DTP) (文档 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 may find the following message in alert log when application servers which perform distributed transactions connects to the database at first.

"Running Distributed Transactions in RAC without DTP service."

CAUSE

If you are running any kind of distributed transactions, the service that the application uses to connect to the RAC database should be enabled for DTP. This keeps all parts of a distributed transaction on the same instance, and allows the service to migrate to a new instance in case of instance failure.

Note: DTP services are not needed in 11.2. As long as the database initialization parameter GLOBAL_TXN_PROCESSES is greater than zero,Oracle11.2 allows different branches of the same global transaction to span multiple RAC instances.

SOLUTION

1.Check for what services do 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
15 Developing Applications with Oracle XA