Skip Headers

Oracle Services for Microsoft Transaction Server Developer's Guide
Release 9.2 for Windows

Part Number A95496-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to next page

2
Installing and Migrating Oracle Products

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

This chapter contains these topics:

Microsoft Transaction Server and Oracle Installation Overview

Figure 2-1 shows a typical Microsoft Transaction Server and multiple database server installation layout.

Figure 2-1 Microsoft Transaction Server and Multiple Database Server Installation Layout

Text description of 82mts007.gif follows
Text description of the illustration 82mts007.gif


Oracle Services for Microsoft Transaction Server Installation Requirements

Table 2-1 lists the Oracle and non-Oracle products you must install. After reviewing the installation requirements, see the Oracle9i Database Installation Guide for Windows for instructions on installing the required Oracle products. Key guidelines to understand are:

Migrating From a Previous Oracle Services for Microsoft Transaction Server Installation

Starting with Oracle release 1 (9.0.1), you were no longer required to create the Oracle Service for MTS. However, before proceeding to uninstall 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 Oracle Service. Table 2-2 shows the procedures to follow.

Table 2-2 Migration Requirements
If You... Then... See...

Migrate the release 8.1.x database server to the current release and create a new installation of release 9.2



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

    Note: If you have already deleted the database server, you cannot delete the Oracle Service using the Oracle Manager for MTS Services snap-in. Instead, delete the service from the registry. This is not the preferred way.

"Deleting an Oracle Service with the Oracle Manager for MTS Services Snap-In"

"Using the Registry to Manually Delete the Oracle Service" if you have already deleted the database server

-

  1. Delete roles and privileges of the user associated with the deleted Oracle Service.

"Deleting Roles and Privileges of an Inactive Oracle Service User"

-

  1. Uninstall Oracle Services for Microsoft Transaction Server from the Windows NT computer where Microsoft Transaction Server is installed.

  2. Install release 9.2 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.

  3. Install Oracle Services for Microsoft Transaction Server release 9.2 into a single Oracle home. The Oracle MTS Recovery Service is also automatically installed.

The Oracle9i Database Installation Guide for Windows



-

  1. Create the Microsoft Transaction Server administrator user account

  2. Schedule Microsoft Transaction Server transaction recovery jobs for all database servers that participate in Microsoft Transaction Server transactions.

Chapter 3, "Managing Recovery Scenarios"



Deleting an Oracle Service with the Oracle Manager for MTS Services Snap-In

You must use the Oracle Manager for MTS Services snap-in in the Microsoft Management Console Explorer to delete the Oracle Service. Deleting the Oracle Service in any other way (such as with the keyboard's Delete button) causes data inconsistencies in the database server. These inconsistencies require the database administrator to manually commit or terminate transactions that did not successfully complete or recover. Before deleting the Oracle Service, ensure that all transactions are resolved by performing the following tasks.

Task 1: Stop the Oracle Service

To stop the Oracle Service:

  1. Go to the computer from which to delete an Oracle Service. You must modify an Oracle Service before deleting it. The Oracle Service can be running on this computer or on a remote computer that you can access from this computer.

  2. Choose Start > Programs > Oracle - HOME_NAME > Application Development > Oracle Manager for Microsoft Transaction Server.

    The Microsoft Management Console appears.

  3. Find the Oracle Service to modify in the Explorer window.

  4. Right-click the Oracle Service icon to modify (named MTSDEMO in this example):

    Text description of mts3.gif follows.

    Text description of the illustration mts3.gif

A menu appears with several options.

  1. Choose Stop Service.

    A message indicates that the Oracle Service has stopped.

  2. Click OK.

Task 2: Stop and Restart the Database Server

To stop and restart the database server:

  1. Go to the computer on which the database server is running.

  2. Start SQL*Plus:

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

    SQL> CONNECT / AS SYSDBA
    
    
  4. Shut down the database server:

    SQL> SHUTDOWN
    
    
  5. Restart the database server:

    SQL> STARTUP
    
    
  6. Exit SQL*Plus:

    SQL> EXIT
    

Task 3: Restart the Oracle Service

To restart the Oracle Service:

  1. Return to the computer from which to modify the Oracle Service.

  2. Choose Start > Programs > Oracle - HOME_NAME > Application Development > Oracle Manager for Microsoft Transaction Server.

    The Microsoft Management Console appears.

  3. Find the Oracle Service to start in the Explorer window.

  4. Right-click the Oracle Service icon.

    A menu appears with several options.

  5. Choose Start Service.

    A message indicates that the Oracle Service started.

  6. Click OK.

Task 4: Monitor the Oracle Service Trace Files

To monitor the Oracle Service trace files:

  1. Do not enable any new transactions to use the Oracle Service.

  2. Monitor the Oracle Service trace file for a message indicating that recovery completed successfully:

    2515156: [2096] OracleMTSService - Accepting new enlistment requests.
    
    

    This file is located in ORACLE_BASE\ORACLE_HOME\oramts\trace.

  3. Right-click the Oracle Service icon in the Microsoft Management Console once this message appears.

  4. Choose Stop Service.

    A message indicates that the Oracle Service stopped.

  5. Click OK.

Task 5: Delete Oracle Service Table Information

To delete Oracle Service table information:

  1. Go to the computer on which the database server 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 following table:

    SQL> DROP TABLE mtsadmin_username.mts_proxy_info;
    
    

    where mtsadmin_username is the Oracle Service user (for example, mtssys).

    SQL> COMMIT;
    

Task 6: Delete the Oracle Service

To delete the Oracle Service:

  1. Go to the computer from which to delete the Oracle Service. The Oracle Service can be running on this computer or on a remote computer that you can access from this computer.

  2. Choose Start > Programs > Oracle - HOME_NAME > Application Development > Oracle Manager for Microsoft Transaction Server.

    The Microsoft Management Console appears.

  3. Find the Oracle Service to delete in the Explorer window.

  4. Right-click the Oracle Service icon.

    A menu appears with several options.

  5. Choose Delete.

  6. Go to the section listed in the following table based on the message that you receive:



    If a Message Indicates That... Go To...

    The Oracle Service was successfully deleted.

    "Deleting Roles and Privileges of an Inactive Oracle Service User"

    The Oracle Service was not deleted.

    "Using the Registry to Manually Delete the Oracle Service"

Deleting Roles and Privileges of an Inactive Oracle Service User

Ensure that you delete the roles and privileges assigned to an Oracle Service user that you no longer use or whose service you have deleted.

To delete roles and privileges of an inactive Oracle Service 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.


    Note:

    This script uses the username mtssys and the password mtssys. If you have changed the password or are using an Oracle Service 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
    
    
  9. See the Oracle9i Database Installation Guide for Windows for instructions on installing the latest Oracle Services for Microsoft Transaction Server release.

Using the Registry to Manually Delete the Oracle Service

Before deleting the Oracle Service, it must be cleanly disassociated from the database server to which it connects. Sometimes this disassociation fails. Follow the instructions in this section only if:

Table 2-3 describes the scenarios in which the Oracle Manager for MTS Services snap-in of the Microsoft Management Console Explorer can fail to delete or modify the Oracle Service.

Table 2-3 Oracle Service Deletion or Modification Failures
Scenario Solution

The Oracle Manager for MTS Services snap-in cannot connect to the database server using the information in the registry.



Ensure that the database server and its listener are started. Use SQL*Plus or a different tool to verify that the database server accepts new connections.



The information in the database server does not match the information in the registry.



The Oracle Manager for MTS Services snap-in is connecting to a different database server than the one to which the Oracle Service connects. If the Oracle Manager for MTS Services snap-in and the Oracle Service 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 Oracle Service points to the same database instance.



The Oracle Manager for MTS Services snap-in cannot delete the service information stored in the database server.



The database server 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.



Task 1: Manually Delete Oracle Service with the Registry

To manually delete Oracle Service with the registry:

  1. Start the registry from the command prompt:

    C:\> regedt32
    
    

    The Registry Editor window appears.

  2. Select the HKEY_LOCAL_MACHINE window.

    Go to System\CurrentControlSet\Services\OracleMTSServicen.

    where n is the number of the Oracle Service.

    The right-hand side of the window shows various parameters and values associated with OracleMTSServicen, including those listed in the following table:

    Parameter This Parameter Contains...

    ORAMTS_SUNAME

    The Oracle Service username

    ORAMTS_SUPWD

    The password for the Oracle Service username (encrypted in the registry)

    ORAMTS_ORADB

    The net service name for the Oracle Service to use in connecting to the database server

  3. Start SQL*Plus:

    C:\> sqlplus /NOLOG
    
    
  4. Connect to the database server with the same username and net service name with which the Oracle Service 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 database server is the same one to which the Oracle Service connects by checking the following database information:

        SQL> SELECT NAME, DBID FROM V$DATABASE; 
    
    

    which displays information similar to the following:

        NAME      DBID 
        --------------------- 
        ORCL      12345678 
    
    
  6. Check that these values match the registry values ORAMTS_DBNAME (ORCL in this example) and ORAMTS_DBID (12345678 in this example).

  7. Check the service information:

    SQL> SELECT rmguid FROM mts_proxy_info; 
    
    

    which displays information similar to the following:

    RMGUID 
    ------------------------- 
    2320b23e93e09fff02a231974 
    
    
  8. Check that this information matches the registry value ORAMTS_RMGUID.

  9. Proceed only if all values match.

    If not all values match, the database server is not the same one to which the Oracle Service connects. If you continue, Oracle Service installation on the database server fails. This can leave the database server in an inconsistent state that requires database administrator intervention to correct. The reason SQL*Plus connected to a different database server than the Oracle Service is mismatching tnsnames.ora files.

  10. Delete the service information stored in the database:

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

    SQL> EXIT
    

Task 2: Delete the OracleMTSServicen Service

To delete the OracleMTSServicen service:

  1. Reboot the computer.

  2. Choose Start > Programs > Oracle - HOME_NAME > Application Development > Oracle Manager for Microsoft Transaction Server.

    The Microsoft Management Console appears.

  3. Find the Oracle Service to delete in the Explorer window.

  4. Right-click the Oracle Service.

    A menu appears with several options.

  5. Choose Delete.

    If successful, a message indicates that the Oracle Service was deleted.

  6. If unsuccessful, a message indicates that the Oracle Service was not deleted. In this case, use the registry to delete the service's registry entry. In the HKEY_LOCAL_MACHINE window, delete the following key:

    \System\CurrentControlSet\Services\OracleMTSServicen.

    where n is the number of the Oracle Service.

  7. Go to "Deleting Roles and Privileges of an Inactive Oracle Service User".

Go to previous page Go to next page
Oracle
Copyright © 1996, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback