Step 3: 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. Run the mtsora102 command after the Oracle InForm installation is completed.
   For more information, see mtsora102.
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 Oracle InForm Application Server.

   For more information, see oramtsadmin.sql.

   Note:

   In an environment with more than one database, 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.