2
Installing and Migrating Oracle Products

This chapter describes installation and migration requirements for your Microsoft Transaction Server and Oracle8i 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 Oracle8i 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 your CD-ROM insert. Key guidelines to follow are:

• You need at least 128 MB of RAM if the Oracle8i 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 (it does not need to be on the same computer as the Oracle8i 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 section "Component Integration In a Transaction" for additional information on the role of MS DTC.

 

Note:  Microsoft Transaction Server integration with an Oracle8i 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  Net8 Assistant2  SQL*Plus	Microsoft Internet Information Server (IIS)4  Microsoft Transaction Server version 2.05  Special downloadable MS DTC update file (DTCSETUP.EXE) or Windows NT 4.0 Service Pack 46  Fully-functioning networking protocol software
Computer where the Oracle8i database is installed	Oracle8i Server (the Oracle8i database)7  Net8 Server  SQL*Plus	Fully-functioning networking protocol software

 

1 Must be manually installed through either the Oracle8i Enterprise Edition Custom installation type or Oracle8i Client Custom installation type on your Oracle8i Enterprise Edition for Windows NT CD-ROM. This product is also available through the Oracle8i Client Custom installation type on the Oracle8i Client CD-ROM and through the Oracle8i Custom installation type or Oracle8i Client Custom installation type on your Oracle8i for Windows NT CD-ROM.  2 Automatically installed with the Oracle Services for Microsoft Transaction Server.   3 ODBC 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 and Oracle Objects for OLE are not required.  4 An applications server such as 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. The online help provided with the Oracle Manager for MTS Services snap-in in the Microsoft Management Console requires Microsoft HTML Help version 1.2. Upgrade to this version.  6 After installing Microsoft Transaction Server 2.0, Oracle Corporation recommends that you install Windows NT 4.0 Service Pack 4. If you cannot install this, you can download a special MS DTC update file DTCSETUP.EXE that enables the Oracle8i 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  See the README file at this location for instructions on download and executing the update file. Note that installing Service Pack 4 also corrects several EXPLORER.EXE problems. If you have already installed Service Pack 4, do not install this special MS DTC update file.  7 If your Oracle8i database is a release prior to 8.1, 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.

 

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 or 8.1.4 Oracle8i database. This table references the sections of this guide to follow for both situations:

If You...	Then...
Migrated your release 8.1.3 or 8.1.4 Oracle8i database to release 8.1.5	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:   Rename the registry parameters for the existing Oracle Service for MTS. All parameter names that previously began with OMTS 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.
Deleted your release 8.1.3 or 8.1.4 Oracle8i database and instead created a new installation of release 8.1.5	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".

 

---