Will Migrating Your Oracle Database Affect Existing Applications Using Oracle Services for MTS?

(Doc ID 311085.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Services for Microsoft Transaction Server - Version: 9.2.0.1 and later   [Release: 9.2 and later ]
Microsoft Windows (32-bit)

Symptoms

***Checked for relevance on 23-Dec-2010***

You have applications that are using the Oracle Services for MTS (OraMTS) architecture to interact with your Oracle database in a distributed manner.  You want to upgrade your Oracle database and know that you will have to configure the new database to continue using the existing applications and existing Oracle Services for MTS architecture.  When the new database is created you will have to run the ORAMTSADMIN.SQL script and create a new MTS administrator account, possibly with a different username/password than used by the previous database.  Does this mean the OracleMTSRecoveryService will have to be configured in some way to continue to allow it to interact with the new database?

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms