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 for MTS

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

	What Products Must Be Installed?
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) DriverFoot 3 Oracle Provider for OLE DBFoot 3 Oracle Call Interface (OCI)Foot 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 The 9.0 releases 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 Oracle9i release 9.0, you no longer have 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 for MTS. 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.0	Delete the Oracle Service for MTS using the Oracle Manager for MTS Services snap-in. Note: If you have already deleted the database server, you cannot delete the Oracle Service for MTS 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 for MTS with the Oracle Manager for MTS Services Snap-In" "Using the Registry to Manually Delete the Oracle Service for MTS" if you have already deleted the database server
	Delete roles and privileges of the user associated with the deleted Oracle Service for MTS.	"Deleting Roles and Privileges of an Inactive Oracle Service for MTS User"
	Uninstall Oracle Services for Microsoft Transaction Server from the Windows NT computer where Microsoft Transaction Server is installed. Install the 9.0 release 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.0 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 for MTS 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 for MTS. Deleting the Oracle Service for MTS 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 abort transactions that did not successfully complete or recover. Before deleting the Oracle Service for MTS, ensure that all transactions are resolved by performing the following tasks.

• Task 1: Stop the Oracle Service for MTS

• Task 2: Stop and Restart the Database Server

• Task 3: Restart the Oracle Service for MTS

• Task 4: Monitor the Oracle Service for MTS Trace Files

• Task 5: Delete Oracle Service for MTS Table Information

• Task 6: Delete the Oracle Service for MTS

Task 1: Stop the Oracle Service for MTS

To stop the Oracle Service for MTS:

1. Go to the computer from which to delete an Oracle Service for MTS. You must modify an Oracle Service for MTS before deleting it. The Oracle Service for MTS 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 for MTS to modify in the Explorer window.

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

   
   
   Text description of the illustration ch22.gif

   A menu appears with several options.

5. Choose Stop Service.

   A message indicates that the Oracle Service for MTS 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:

      ENTER USER-NAME: / 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 for MTS

   To restart the Oracle Service for MTS:

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

   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 for MTS to start in the Explorer window.

   4. Right-click the Oracle Service for MTS icon.

      A menu appears with several options.

   5. Choose Start Service.

      A message indicates that the Oracle Service for MTS started.

   6. Click OK.

   Task 4: Monitor the Oracle Service for MTS Trace Files

   To monitor the Oracle Service for MTS trace files:

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

   2. Monitor the Oracle Service for MTS 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 for MTS icon in the Microsoft Management Console once this message appears.

   4. Choose Stop Service.

      A message indicates that the Oracle Service for MTS stopped.

   5. Click OK.

   Task 5: Delete Oracle Service for MTS Table Information

   To delete Oracle Service for MTS 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:

      ENTER USER-NAME: / 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 for MTS user (for example, mtssys).

      SQL> COMMIT;
      

   Task 6: Delete the Oracle Service for MTS

   To delete the Oracle Service for MTS:

   1. Go to the computer from which to delete the Oracle Service for MTS. The Oracle Service for MTS 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 for MTS to delete in the Explorer window.

   4. Right-click the Oracle Service for MTS 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 for MTS was successfully deleted.	"Deleting Roles and Privileges of an Inactive Oracle Service for MTS User"
      The Oracle Service for MTS was not deleted.	"Using the Registry to Manually Delete the Oracle Service for MTS"

   Deleting Roles and Privileges of an Inactive Oracle Service for MTS User

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

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

      ENTER USER-NAME: / 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 for MTS

   Before deleting the Oracle Service for MTS, 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 for MTS 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 for MTS.

   Table 2-3 Oracle Service for MTS 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 for MTS connects. If the Oracle Manager for MTS Services snap-in and the Oracle Service for MTS 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 for MTS 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 the Oracle Service for MTS with the Registry

   To manually delete the Oracle Service for MTS with the registry:

   1. Start the registry from the command prompt:

      C:\> regedt32
      

      The Registry Editor window appears.

   2. Go to HKEY_LOCAL_MACHINE\System\CurrentControlSet\ Services\OracleMTSServicen.

      where n is the number of the Oracle Service for MTS.

      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 for MTS username
      ORAMTS_SUPWD	The password for the Oracle Service for MTS username (encrypted in the registry)
      ORAMTS_ORADB	The net service name for the Oracle Service for MTS 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 for MTS connects:

      ENTER USER-NAME: 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 for MTS 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 for MTS connects. If you continue, Oracle Service for MTS 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 for MTS 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 for MTS to delete in the Explorer window.

   4. Right-click the Oracle Service for MTS.

      A menu appears with several options.

   5. Choose Delete.

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

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

      HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services \OracleMTSServicen.

      where n is the number of the Oracle Service for MTS.

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