Previous Topic

Next Topic

Book Contents

Set up Oracle XA Transaction Support

To set up the Oracle database to support MTS transactional components, enable Oracle XA Transaction Support. You must enable Oracle XA Transaction Support for both development and production environments.

  1. Select the Prep Oracle checkbox during the InForm installation. For more information, see Step 2: Install the InForm core software on the InForm Application Server.

    or

    Run the mtsora102 command during or after the Oracle installation.

    You must run the mtsora102 command only if you are manually setting up XA Transaction Support.

    For more information, see mtsora102.

    Note: In a multi-tier environment, select the Prep Oracle checkbox during the InForm installation on each InForm application server, and run the mtsora102 command on each InForm database server. Restart the server if the script changes any of the MSDTC\Security or MSDTC\XADLL registry keys.

  2. Run the oramtsadmin.sql command from the ...\oramts\admin folder of the Oracle Client home (where Oracle Services for Microsoft Transaction Server was installed).

    You must run it as a user with the SYSDBA role. Run the script against all Oracle instances connected to the InForm Application Server.

    For more information, see oramtsadmin.sql.

Send Feedback