Configuring DTP Services

To create distributed transaction processing (DTP) services for distributed transaction processing, perform the following steps:

1. Create a singleton service using Oracle Enterprise Manager or SRVCTL.

   For an administrator-managed database, define only one instance as the preferred instance. You can have as many available instances as you want, for example:

   $ srvctl add service -db crm -service xa_01.example.com -preferred RAC01
       -available RAC02,RAC03
   

   For a policy-managed database, specify the server pool to use, and set the cardinality of the service to SINGLETON, for example:

   $ srvctl add service -db crm -service xa_01.example.com -serverpool dtp_pool
       -cardinality SINGLETON
   

2. Set the DTP parameter (-dtp) for the service to TRUE (the default value is FALSE). You can use Oracle Enterprise Manager or SRVCTL to modify the DTP property of the singleton service. The following example shows how to modify the xa_01.example.com service using SRVCTL:

   $ srvctl modify service -db crm -service xa_01.example.com -dtp TRUE