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
  
  
• Oracle Services for Microsoft Transaction Server Installation Requirements
  
  
• Migrating From a Previous Oracle Services for Microsoft Transaction Server Installation
  
  
• Using the Registry to Manually Delete the Oracle Service

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 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:

• At least 256 MB of RAM is required if the database server, Microsoft Transaction Server, and Oracle Services for Microsoft Transaction Server (MTS) are installed on the same computer.
  
  
• An Oracle MTS Recovery Service is also automatically installed on the same computer in the middle tier as Oracle Services for Microsoft Transaction Server. One Oracle MTS Recovery Service for each computer is allowed.
  
  
• For Oracle Fail Safe cluster configurations (or any failover configuration), install Microsoft Transaction Server on the node running the Microsoft Distributed Transaction Coordinator (MS DTC) component. This ensures that the Oracle MTS Recovery Service migrates with the client application during failover. You can configure this when scheduling recovery transactions.

  Note: Microsoft Transaction Server integration with a database server is not currently supported on Windows 95 or Windows 98.

  Table 2-1 Installation Requirements

  On This Computer...	Oracle Products	Non-Oracle Products
  Client computer	None required	Fully-functioning networking protocol software Web browser
  Windows NT computer where Microsoft Transaction Server is installed	Oracle Services for Microsoft Transaction ServerFoot 1 Oracle Net Services for the clientFoot 2 Oracle Objects for OLE (OO4O)Foot 3 Oracle Open Database Connectivity (ODBC) Driver3 Oracle Provider for OLE DB3 Oracle Call Interface (OCI)3 Oracle Net Manager SQL*Plus	Microsoft Internet Information Server (IIS)Foot 4 Microsoft Transaction Server release 2.0Foot 5 Windows NT 4.0 Service Pack 5 or higherFoot 6 Fully-functioning networking protocol software
  Computer where the database server is installed	Oracle Server (the database server)Foot 7 Oracle Net Services for the server SQL*Plus	Fully-functioning networking protocol software

  1 See the Oracle9i Database Installation Guide for Windows for installation instructions. During 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 Oracle Net Services is automatically installed with Oracle Services for Microsoft Transaction Server. 3 Release 8.1.3 of OO4O, Oracle ODBC Driver, Oracle Provider for OLE DB, and OCI are only required if you are building or using components with which they are required. 4 An applications server like IIS is not required, but is beneficial if using Microsoft Transaction Server. Install the applications server on the same computer as Microsoft Transaction Server. The applications server you choose must support extensions. 5 Microsoft Transaction Server is currently available as part of the Microsoft Windows NT 4.0 Option Pack. Microsoft Management Console is automatically installed with Microsoft Transaction Server. 6 After installing Microsoft Transaction Server 2.0, Oracle Corporation recommends that you install Windows NT 4.0 Service Pack 5 or higher. You must re-install any service packs installed prior to Microsoft Transaction Server 2.0 installation. 7 If the database server is a release prior to 8.0.6, you cannot use the integration described in this guide. See "Using Microsoft's Oracle ODBC Driver" for a description of what functionality is available for pre-8.0.6 database servers.

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	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
-	Delete roles and privileges of the user associated with the deleted Oracle Service.	"Deleting Roles and Privileges of an Inactive Oracle Service User"
-	Uninstall Oracle Services for Microsoft Transaction Server from the Windows NT computer where Microsoft Transaction Server is installed. 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. 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
-	Create the Microsoft Transaction Server administrator user account 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
  
  
• Task 2: Stop and Restart the Database Server
  
  
• Task 3: Restart the Oracle Service
  
  
• Task 4: Monitor the Oracle Service Trace Files
  
  
• Task 5: Delete Oracle Service Table Information
  
  
• Task 6: Delete the Oracle Service

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 the illustration mts3.gif

A menu appears with several options.

5. Choose Stop Service.

   A message indicates that the Oracle Service has stopped.

6. 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:

• The deletion procedures in "Deleting an Oracle Service with the Oracle Manager for MTS Services Snap-In" were unsuccessful
  
  
• You have already deleted the database server and cannot use the Oracle Manager for MTS Services snap-in

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