Skip Headers
Oracle® Database Gateway Installation and Configuration Guide
11g Release 2 (11.2) for Microsoft Windows

Part Number E12061-05
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

8 Installing Oracle Database Gateway for SQL Server

This chapter provides information about the hardware and software requirements and the installation procedure for Oracle Database Gateway for SQL Server.

To install the Oracle Database Gateway for SQL Server, follow these steps:

  1. Ensure that the system meets all of the hardware and software requirements specified in "System Requirements for Oracle Database Gateway for SQL Server" section .

  2. Run the Oracle Universal Installer.

    See "Step Through the Oracle Universal Installer" section for more information on running the Oracle Universal Installer.

    Oracle Universal Installer is a menu-driven utility that guides you through the installation of the gateway by prompting you with action items. The action items and the sequence in which they appear depend on your platform.

    See Table 8-2 for description of the installation procedure of Oracle Database Gateway for SQL Server.

8.1 System Requirements for Oracle Database Gateway for SQL Server

This section provides information about the hardware and software requirements for the gateway. It contains the following sections:

8.1.1 Hardware Requirements

Table 8-1 lists the minimum hardware requirements for Oracle Database Gateway for SQL Server.

Table 8-1 Hardware Requirements for Oracle Database Gateway for SQL Server

Requirement For Microsoft Windows (32-bit) For Microsoft Windows (64-bit)

Total disk space

4 GB

5 GB

Physical Memory

1 GB of real memory is recommended to support the gateway. The total real memory requirement for the concurrent use of the gateway also depends on these factors:

  • The SQL statement processed by the user

  • The number of cursors currently opened against SQL Server

  • The number of columns in the table being accessed

Minimum of 1 GB

Virtual memory

Double the amount of RAM

Double the amount of RAM

Video adapter

256 colors

256 colors

Processor

550 MHz minimum(On Microsoft Windows Vista, 800 MHz minimum)

AMD64, or Intel Extended memory (EM64T)


8.1.1.1 Checking the Hardware Requirements

To ensure that the system meets the minimum requirements, follow these steps:

  1. Determine the physical RAM size. For a computer using Microsoft Windows 2000, for example, open System in the control panel and select the General tab. If the size of the physical RAM installed in the system is less than the required size, then you must install more memory before continuing.

  2. Determine the size of the configured swap space (also known as paging file size). For a computer using Microsoft Windows 2000, for example, open System in the control panel, select the Advanced tab, and click Performance Options.

    If necessary, then see your operating system documentation for information about how to configure additional swap space.

  3. Determine the amount of free disk space on the system. For a computer using Microsoft Windows 2000, for example, open My Computer, right-click the drive where the Oracle software is to be installed, and select Properties.

  4. Determine the amount of disk space available in the temp directory. This is equivalent to the total amount of free disk space, minus what will be needed for the Oracle software to be installed.

    If there is less than 125 MB of disk space available in the temp directory, then first delete all unnecessary files. If the temp disk space is still less than 125 MB, then set the TEMP or TMP environment variable to point to a different hard drive. For a computer using Microsoft Windows 2000, for example, open the System control panel, select the Advanced tab, and click Environment Variables.

8.1.2 Software Requirements

Oracle Database Gateway for SQL Server is supported on the following Microsoft Windows (32-bit) operating systems:

  • Microsoft Windows 2000 with Service Pack 1 or later. All editions, including Terminal Services and Microsoft Windows 2000 MultiLanguage Edition (MLE), are supported.

  • Microsoft Windows Server 2003 - all editions

  • Microsoft Windows Server 2003 R2 - all editions

  • Microsoft Windows XP Professional

  • Microsoft Windows Vista - Business, Enterprise, and Ultimate editions

  • Microsoft Windows 2008

Microsoft Windows Multilingual User Interface Pack is supported on Microsoft Windows XP Professional and Microsoft Windows Server 2003.

Oracle Database Gateway for SQL Server is supported on the following Microsoft Windows (64-bit) operating systems:

  • Microsoft Windows Server 2003 - all x64 editions

  • Microsoft Windows Server 2003 R2 - all x64 editions

  • Microsoft Windows XP Professional x64 Edition

  • Microsoft Windows Vista x64 - Business, Enterprise, and Ultimate editions

  • Microsoft Windows 2008 x64

8.1.2.1 Certified Configurations

The gateway supports SQL Server. For the latest versions supported refer to the OTN Web site:

http://www.oracle.com/technology/products/gateways/pdf/certmatrix.pdf

8.2 Step Through the Oracle Universal Installer

Step Through the Oracle Universal Installer

Table 8-2 describes the installation procedure for Oracle Database Gateway for SQL Server

Table 8-2 The Oracle Universal Installer: Steps for Installing the Gateway

Screen Response

Oracle Universal Installer: Welcome

Click Next.

Oracle Universal Installer: Specify Home Details

Specify a name for the installation in the Name field. You can also choose not to edit the default setting of the Name field of the Specify Home Details screen.

The Path field in the Specify Home Details screen is where you specify the destination for your installation. You need not edit the path specification in the Path field. The default setting for this field points to ORACLE_HOME. After you set the fields in the Specify Home Details screen as necessary, click Next to continue. After loading the necessary information from the installation, the Oracle Universal Installer displays the Available Products screen.

Oracle Database Gateway for SQL Server

SQL Server Database Server Host Name - Specify the host name of the machine hosting the SQL Server database.

SQL Server Database Server Port number - Specify the port number of the SQL Server database server

SQL Server Database Name - Specify the SQL Server database name

Click Next to continue.

Oracle Universal Installer: Summary

The Installation Summary screen enables you to review a tree list of options and components for this installation. Click Install to start installation.

Oracle Net Configuration Assistant: Welcome

Click Cancel.

Oracle Net Configuration Assistant:

Click Yes.

Oracle Universal Installer: Configuration Tools

Click Exit.

Exit

The final screen of the Oracle Universal Installer is the End of Installation screen. Click Exit to exit the installer.


The gateway is now installed.

When the Oracle Universal Installer confirms that the installation is complete, verify that the installation procedure was successful. To do this, read the contents of the installation log file, which is located in the C:\Program Files\Oracle\Inventory\logs directory.

The default file name is InstallActionsYYYY-MM-DD_HH-mm-SS-AM/PM.log, where:

YYYY is year
MM is month
DD is day
HH is hour
mm is minute
SS is seconds
AM/PM is daytime or evening

Each of these variables in the log file name represents the date and time the product was installed.