2
Installing and Migrating Oracle Products

This chapter describes installation and migration requirements for your Microsoft Transaction Server and Oracle8 database environment.

Specific topics discussed are:

• Oracle Product Layouts

• What Do You Need to Install?

• Migrating From a Previous Installation of Oracle Service for MTS

Oracle Product Layouts

This figure shows three possible installation layouts for your Microsoft Transaction Server and Oracle8 database environment:

What Do You Need to Install?

The table on the following page lists the Oracle and non-Oracle products you must install. After reviewing your installation responsibilities, see your Oracle installation documentation for instructions on installing the required Oracle products. On Windows NT, for example, these instructions are included in Oracle8i Installation Guide for Windows NT and Oracle8i Client Installation Guide for Windows NT. Key guidelines to follow are:

• You need at least 128 MB of RAM if the Oracle8 database, Microsoft Transaction Server, and Oracle Services for Microsoft Transaction Server are installed on the same computer.

• Install the Oracle Services for Microsoft Transaction Server on a stable computer that is always running, reliable, fast, and easily recoverable. If the service is not running, a connection fails if the component is marked transactional.

• One installation of the Oracle Services for Microsoft Transaction Server can create multiple services.

• There must be only one Oracle Service for MTS for each database instance. This service does not need to be on the same computer as the Oracle8 database.

• Microsoft Transaction Server must be installed for the Oracle Service for MTS to run. However, the Oracle Service for MTS can use a Microsoft Distributed Transaction Coordinator (MS DTC) on a different computer. Configure this when creating or modifying the Oracle Service for MTS. See "Component Integration In a Transaction" for additional information on the role of MS DTC.

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

  Note: To use the Oracle Manager for MTS Services snap-in online help in the Microsoft Management Console, you must download and install version 1.2 of Microsoft HTML Help. If you use an earlier version, you can have problems displaying the online help.

  	What Products Must Be Installed?
  On The...	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 Server1 Net8 Client2 Oracle Objects for OLE 3 ODBC 3 Oracle Provider for OLE DB3 Net8 Assistant2 SQL*Plus	Microsoft Internet Information Server (IIS)4 Microsoft Transaction Server version 2.05 Windows NT 4.0 Service Pack 4 or greater or a special distributed transaction coordinator stand-alone setup program6 Fully-functioning networking protocol software
  Computer where the Oracle8 database is installed	Oracle8 Server (the Oracle8 database)7 Net8 Server SQL*Plus	Fully-functioning networking protocol software

  1 See the Oracle8i Installation Guide for Windows NT or Oracle8i Client Installation Guide for Windows NT for installation instructions. 2 Automatically installed with the Oracle Services for Microsoft Transaction Server. 3 ODBC, Oracle Provider for OLE DB, and Oracle Objects for OLE are only required if you are building or using components with which they are required. If you are building or using components only with OCI, then ODBC, Oracle Provider for OLE DB, and Oracle Objects for OLE are not 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 4 or higher. If you cannot install this, you can download a special DTC stand-alone setup program that enables the Oracle8 database and Microsoft Transaction Server to interact properly. Use a Web browser to access this Web site: ftp.microsoft.com/bussys/distapps/mts/public-fixes/usa/dtc/oracle/readme.htm See the README file at this location for instructions on download and executing the update file. Note that installing Service Pack 4 or higher also corrects several EXPLORER.EXE problems. If you have already installed Service Pack 4 or higher, do not install this special MS DTC update file. 7 If your Oracle8 database is a release prior to 8.0.6, you cannot take advantage of the integration described in this guide. See section "Using Microsoft's Oracle ODBC Driver" for a description of what functionality is available to you.

  Note: Oracle Service for MTS is supported on Windows 2000.

Migrating From a Previous Installation of Oracle Service for MTS

The Oracle Service for MTS migration procedures to follow depend upon whether you are migrating or deleting your release 8.1.3, 8.1.4, or 8.1.5 Oracle8 database. This table references the sections of this guide to follow for both situations:

If You...	Then...
Migrated your release 8.1.3, 8.1.4, or 8.1.5 Oracle8 database to release 8.1.6	You have two choices: Choice 1: Delete and Re-create: Delete the Oracle Service for MTS by carefully following the procedures in "Deleting an Existing Oracle Service for MTS". Create a new Oracle Service for MTS by following the procedures in Chapter 3, "Creating a New Oracle Service for MTS". Choice 2: Rename: If you are using release 8.1.3 or 8.1.4, rename the registry parameters for the existing Oracle Service for MTS. All parameter names that began with OMTS in releases 8.1.3 or 8.1.4 now begin with ORAMTS. See section "Manually Deleting or Modifying the Oracle Service for MTS with the Registry" for information on the registry location of these parameters. You do not need to rename these parameters if your release is 8.1.5.
Deleted your release 8.1.3, 8.1.4, or 8.1.5 Oracle8 database and instead created a new installation of release 8.1.6	No Oracle Service for MTS migration is required. You can: Delete the Oracle Service for MTS. Note that it is not a requirement that you follow the procedures in Appendix B, "Deleting or Modifying an Existing Oracle Service for MTS". Create a new Oracle Service for MTS by following the procedures in Chapter 3, "Creating a New Oracle Service for MTS".