In most cases, you need not reconfigure the port number.
2.2 Upgrading Oracle Services for Microsoft Transaction Server Before uninstalling Oracle Services For Microsoft Transaction Server, you must use the Oracle Manager for MTS Services snap-in in the Microsoft Management Console Explorer to delete the existing OraMTS. The entire process is outlined in the following steps:. Delete OraMTS using the Oracle Manager for MTS Services snap-in. Alternatively, if you already deleted the database, delete the service from the registry. Delete roles and privileges of the user associated with the deleted OraMTS. Uninstall Oracle Services For Microsoft Transaction Server from the Windows computer where Microsoft Transaction Server is installed. Install release 11.1 of OO4O, Oracle Provider for OLE DB, Oracle ODBC Driver, or OCI, if you plan to build component object model (COM) components with these products.
Install Oracle Services For Microsoft Transaction Server release 11.1 into a single Oracle home. The Oracle MTS Recovery Service is installed automatically. Create the Microsoft Transaction Server administrator user account.
Schedule Microsoft Transaction Server transaction recovery jobs for all databases that participate in Microsoft Transaction Server transactions. Steps 1 and 2 are discussed in detail in this section. For Steps 3 through 5, see. For Steps 6 and 7, refer to. 2.2.1 Deleting OraMTS with Oracle Manager for MTS Services You must use Oracle Manager for MTS Services snap-in in the Microsoft Management Console Explorer to delete the OraMTS. Deleting the OraMTS in any other way (such as with the Delete button on the keyboard) causes data inconsistencies in the database. These inconsistencies require the database administrator to manually commit or terminate transactions that did not successfully complete or recover.
Before deleting the OraMTS, ensure that all transactions are resolved by completing these steps:. 2.2.1.1 Stopping OraMTS. Go to the computer from which to delete an OraMTS. You must modify an OraMTS before deleting it. The OraMTS can be running on this computer or on a remote computer that you can access from this computer.
From the Start menu, select Programs, then Oracle - HOMENAME, then Application Development, then Oracle Manager for Microsoft Transaction Server. The Microsoft Management Console appears. Find the OraMTS to modify in the Explorer window. Right-click the OraMTS icon to modify; MTSDEMO in this example.
2.2.1.4 Monitoring the OraMTS Trace Files To monitor the OraMTS trace files:. Do not enable any new transactions to use the OraMTS. Monitor the OraMTS trace file, located at ORACLEBASE ORACLEHOME oramts trace, for a message indicating that the recovery completed successfully: 2515156: 2096 OracleMTSService - Accepting new enlistment requests.
Right-click the OraMTS icon in the Microsoft Management Console once message 2515156 appears. Choose Stop Service. A message indicates that the OraMTS stopped. 2.2.1.6 Deleting the OraMTS To delete the OraMTS:.
On the computer from which the OraMTS should be deleted, from the Start menu, select Programs, then Oracle - HOMENAME, then Application Development, then Oracle Manager for Microsoft Transaction Server. The Microsoft Management Console appears. Find the OraMTS to delete in the Explorer window.
Right-click the OraMTS icon. A menu with several options appears. Choose Delete. If you receive a message indicating that the OraMTS was successfully deleted, see. If OraMTS was not deleted successfully, see. 2.3 Deleting Roles and Privileges of an Inactive OraMTS User Ensure that you delete the roles and privileges assigned to an OraMTS user that you no longer use, or whose service you have deleted. To delete roles and privileges of an inactive OraMTS user:.
Go to ORACLEBASE ORACLEHOME oramts admin. Open the file revokeuser.sql with a text editor. Replace mtsuser with the username from which to revoke roles and privileges. This script uses the username mtssys and the password mtssys. If you have changed the password or are using an OraMTS username other than mtssys, you must substitute the correct username and password. Save the changes and exit revokeuser.sql.
Start SQL.Plus: C: sqlplus /NOLOG. Connect to the database as SYSDBA: SQL CONNECT / AS SYSDBA.
Run the modified script: SQL @ ORACLEBASE ORACLEHOME oramts admin revokeuser.sql; The roles and privileges for the user are deleted. Exit SQL.Plus: SQL EXIT.
2.4 Deleting Oracle Services for Microsoft Transaction Server Manually Before deleting OraMTS, it must be cleanly disassociated from the Oracle Database to which it connects. Sometimes this disassociation fails. Follow the instructions in this section only if:.
The deletion procedures in were unsuccessful. You have already deleted the Oracle Database and cannot use the Oracle Manager for MTS Services snap-in. Oracle Manager for MTS Services snap-in of the Microsoft Management Console Explorer can fail to delete or modify the OraMTS under three distinct conditions:. The Oracle Manager for MTS Services snap-in cannot connect to the Oracle Database using the information in the registry. Ensure that the Oracle Database and its listener are started. Use SQL.Plus or a different tool to verify that the Oracle Database accepts new connections. The information in the Oracle Database does not match the information in the registry.
The Oracle Manager for MTS Services snap-in is connecting to a different Oracle Database than the one to which the OraMTS connects. If the Oracle Manager for MTS Services snap-in and the OraMTS run on the same computer, they may be using tnsnames.ora files from different Oracle homes. If they run on different computers (for example, the Oracle Manager for MTS Services snap-in is configuring a service on a remote computer), the entry in their tnsnames.ora file is pointing to different databases. Whether it is a local or remote problem, resolve it by ensuring that the entry in the tnsnames.ora file for both the Oracle Manager for MTS Services snap-in and the OraMTS points to the same database instance. Oracle Manager for MTS Services snap-in cannot delete the service information stored in Oracle Database.
Oracle Database is unstable or is not working properly. Check if any database trace files are being created that indicate a database process failure.
Trace files are located in ORACLEBASE ORACLEHOME oramts trace. 2.4.1 Manually Deleting Oracle Services for Microsoft Transaction Server with the Registry To manually delete OraMTS with the registry:. Start the registry from the command prompt: C: regedt32 The Registry Editor window appears.
Select the HKEYLOCALMACHINE. Go to System CurrentControlSet Services OracleMTSService n, where n is the number of the OraMTS. The right-hand side of the window shows various parameters and values associated with OracleMTSService n:.
ORAMTSSUNAME is the OraMTS username. ORAMTSSUPWD is the password for the OraMTS username, encrypted in the registry.
ORAMTSOCIOBJMODE Initializes OCI in object mode or threaded mode. ORAMTSORADB is the for the OraMTS to use in connecting to the Oracle Database. Start SQL.Plus: C: sqlplus /NOLOG. Connect to the Oracle Database; use the same username and net service name with which the OraMTS connects: CONNECT as username/ password@n etservicename where netservicename is the net service name for connecting to the database. The password is stored in the registry in encrypted form. Use plain text passwords when connecting with SQL.Plus.
Verify that the Oracle Database is the same one to which the OraMTS connects by checking the following database information: SQL SELECT NAME, DBID FROM V$DATABASE;. Check that the NAME value matches the registry ORAMTSDBNAME value, and that the DBID value matches the ORAMTSDBID value. Check service information: SQL SELECT RMGUID FROM mtsproxyinfo;. Check that the RMGUID value matches the registry ORAMTSRMGUID value. Proceed only if all values match. If all values do not match, the Oracle Database is not the same one to which the OraMTS connects. If you continue, OraMTS installation on the database fails.
This can leave the database in an inconsistent state that requires database administrator intervention to correct. Because of mismatched tnsnames.ora files, SQL.Plus and OraMTS did not connect to the same database.
Delete the service information stored in the database: SQL DELETE FROM mtsproxyinfo; SQL COMMIT;. Exit from SQL.Plus.
2.4.2 Deleting the OracleMTSService n Service To delete the OracleMTSService n service:. Restart the computer. From the Start menu, select Programs, then Oracle - HOMENAME, then Application Development, then Oracle Manager for Microsoft Transaction Server. The Microsoft Management Console appears. Find the OraMTS to delete in the Explorer window. Right-click OraMTS.
A menu with several options appears. Click Delete. If successful, a message indicates that the OraMTS was deleted. If unsuccessful, a message indicates that the OraMTS was not deleted. In this case, use the registry to delete the service's registry entry. In the HKEYLOCALMACHINE, delete the following key: System CurrentControlSet Services OracleMTSService n, where n is the number of the OraMTS.
Scripting on this page enhances content navigation, but does not change the content in any way.