Skip Headers
Oracle® Services for Microsoft Transaction Server Developer's Guide
11g Release 1 (11.1) for Microsoft Windows

B28377-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

2 Installing and Migrating Oracle Products

This chapter describes installation and migration requirements for the Microsoft Transaction Server and Oracle Database environment.

This chapter contains these topics:

2.1 Installing Oracle Services for Microsoft Transaction Server

You can install OraMTS by choosing the Custom installation type when you install Oracle Database.

This section describes the Oracle and non-Oracle products you must install for OraMTS. Additional installation requirements include:

2.1.1 Installation Requirements for Microsoft Transaction Server

The Windows computer where Microsoft Transaction Server is installed has the following product requirements:

2.1.1.1 Oracle Products

Notes:

  • OO4O, Oracle ODBC Driver, ODP.NET, Oracle Provider for OLE DB, and OCI are only required if you are building or using components with which they are required.

  • Depending on the installation, you are prompted to enter the port number on which the Oracle MTS Recovery Service will listen for requests to resolve in-doubt transactions

2.1.1.2 Non-Oracle Products

  • Microsoft Transaction Server version 2.0 or later versions

  • Windows operating system

  • Fully-functioning networking protocol software

  • COM+ or Enterprise Services; these are later versions of Microsoft Transaction Server

2.1.2 Installation Requirements for Oracle Database

The computer where Oracle Database is installed has the following product requirements:

2.1.2.1 Oracle Products

  • Oracle Server (the Oracle Database) Oracle Net Services for the server

  • SQL*Plus

2.1.2.2 Non-Oracle Products

  • Fully enabled networking protocol

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:

  1. Delete OraMTS using the Oracle Manager for MTS Services snap-in.

    Alternatively, if you already deleted the database, delete the service from the registry.

  2. Delete roles and privileges of the user associated with the deleted OraMTS.

  3. Uninstall Oracle Services For Microsoft Transaction Server from the Windows computer where Microsoft Transaction Server is installed.

  4. 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.

  5. Install Oracle Services For Microsoft Transaction Server release 11.1 into a single Oracle home. The Oracle MTS Recovery Service is installed automatically.

  6. Create the Microsoft Transaction Server administrator user account.

  7. 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 Oracle Database Installation Guide for Windows. For Steps 6 and 7, refer to Chapter 3, "Managing Recovery Scenarios".

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

  1. 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.

  2. From the Start menu, select Programs, then Oracle - HOME_NAME, then Application Development, then Oracle Manager for Microsoft Transaction Server.

    The Microsoft Management Console appears.

  3. Find the OraMTS to modify in the Explorer window.

  4. Right-click the OraMTS icon to modify; MTSDEMO in this example.

    Figure 2-1 Microsoft Management Console

    Description of Figure 2-1 follows
    Description of "Figure 2-1 Microsoft Management Console"

    A menu with several options appears.

  5. Choose Stop Service.

    A message indicates that the OraMTS has stopped.

  6. Click OK.

2.2.1.2 Stopping and Restarting the Database

To stop and restart the database:

  1. Go to the computer on which the Oracle Database is running.

  2. Start SQL*Plus:

    C:\> sqlplus /NOLOG
    
  3. Connect to the database as SYSDBA:

    SQL> CONNECT / AS SYSDBA
    
  4. Shut down the Oracle Database:

    SQL> SHUTDOWN
    
  5. Restart the Oracle Database:

    SQL> STARTUP
    
  6. Exit SQL*Plus:

    SQL> EXIT
    

2.2.1.3 Restarting the OraMTS

To restart the OraMTS:

  1. On the computer where OraMTS is modified, from the Start menu, select Programs, then Oracle - HOME_NAME, then Application Development, then Oracle Manager for Microsoft Transaction Server.

    The Microsoft Management Console appears.

  2. Find the OraMTS to start in the Explorer window.

  3. Right-click the OraMTS icon.

    A menu with several options appears.

  4. Choose Start Service.

    A message indicates that the OraMTS started.

  5. Click OK.

2.2.1.4 Monitoring the OraMTS Trace Files

To monitor the OraMTS trace files:

  1. Do not enable any new transactions to use the OraMTS.

  2. Monitor the OraMTS trace file, located at ORACLE_BASE\ORACLE_HOME\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.

  3. Choose Stop Service.

    A message indicates that the OraMTS stopped.

  4. Click OK.

2.2.1.5 Deleting OraMTS Table Information

To delete OraMTS table information:

  1. Go to the computer on which the Oracle Database is running.

  2. Start SQL*Plus:

    C:\> sqlplus /NOLOG
    
  3. Connect to the database as SYSDBA:

    SQL> CONNECT / AS SYSDBA
    
  4. Delete this information from the mts_proxy_info table:

    SQL> DROP TABLE mtsadmin_username.mts_proxy_info;
    

    where mtsadmin_username is the OraMTS user, such as mtssys.

    SQL> COMMIT;
    

2.2.1.6 Deleting the OraMTS

To delete the OraMTS:

  1. On the computer from which the OraMTS should be deleted, from the Start menu, select Programs, then Oracle - HOME_NAME, then Application Development, then Oracle Manager for Microsoft Transaction Server.

    The Microsoft Management Console appears.

  2. Find the OraMTS to delete in the Explorer window.

  3. Right-click the OraMTS icon.

    A menu with several options appears.

  4. Choose Delete.

  5. If you receive a message indicating that the OraMTS was successfully deleted, see "Deleting Roles and Privileges of an Inactive OraMTS User".

    If OraMTS was not deleted successfully, see "Deleting Oracle Services for Microsoft Transaction Server Manually".

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:

  1. Go to ORACLE_BASE\ORACLE_HOME\oramts\admin.

  2. Open the file revokeuser.sql with a text editor.

  3. Replace mts_user 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.

  4. Save the changes and exit revokeuser.sql.

  5. Start SQL*Plus:

    C:\> sqlplus /NOLOG
    
  6. Connect to the database as SYSDBA:

    SQL> CONNECT / AS SYSDBA
    
  7. Run the modified script:

    SQL> @ORACLE_BASE\ORACLE_HOME\oramts\admin\revokeuser.sql;
    

    The roles and privileges for the user are deleted.

  8. Exit SQL*Plus:

    SQL> EXIT
    

    See Also:

    Oracle Database Installation Guide for Windows for instructions on installing the latest Oracle Services For Microsoft Transaction Server release

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:

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:

  1. 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.

  2. 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.

  3. 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 ORACLE_BASE\ORACLE_HOME\oramts\trace.

2.4.1 Manually Deleting Oracle Services for Microsoft Transaction Server with the Registry

To manually delete OraMTS with the registry:

  1. Start the registry from the command prompt:

    C:\> regedt32
    

    The Registry Editor window appears.

  2. Select the HKEY_LOCAL_MACHINE.

    Go to System\CurrentControlSet\Services\OracleMTSServicen,

    where n is the number of the OraMTS.

    The right-hand side of the window shows various parameters and values associated with OracleMTSServicen:

    • ORAMTS_SUNAME is the OraMTS username.

    • ORAMTS_SUPWD is the password for the OraMTS username, encrypted in the registry.

    • ORAMTS_OCI_OBJ_MODE Initializes OCI in object mode or threaded mode.

    • ORAMTS_ORADB is the net service name for the OraMTS to use in connecting to the Oracle Database.

  3. Start SQL*Plus:

    C:\> sqlplus /NOLOG
    
  4. Connect to the Oracle Database; use the same username and net service name with which the OraMTS connects:

    CONNECT as username/password@net_service_name
    

    where net_service_name 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.

  5. 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; 
    
  6. Check that the NAME value matches the registry ORAMTS_DBNAME value, and that the DBID value matches the ORAMTS_DBID value.

  7. Check service information:

    SQL> SELECT RMGUID FROM mts_proxy_info; 
    
  8. Check that the RMGUID value matches the registry ORAMTS_RMGUID value.

  9. 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.

  10. Delete the service information stored in the database:

    SQL> DELETE FROM mts_proxy_info; 
    SQL> COMMIT; 
    
  11. Exit from SQL*Plus.

    SQL> EXIT
    

2.4.2 Deleting the OracleMTSServicen Service

To delete the OracleMTSServicen service:

  1. Restart the computer.

  2. From the Start menu, select Programs, then Oracle - HOME_NAME, then Application Development, then Oracle Manager for Microsoft Transaction Server.

    The Microsoft Management Console appears.

  3. Find the OraMTS to delete in the Explorer window.

  4. Right-click OraMTS.

    A menu with several options appears.

  5. 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 HKEY_LOCAL_MACHINE, delete the following key:

    \System\CurrentControlSet\Services\OracleMTSServicen,

    where n is the number of the OraMTS.

    Go to "Deleting Roles and Privileges of an Inactive OraMTS User".