Skip Headers
Oracle® Database Gateway Installation and Configuration Guide
11g Release 1 (11.1) for AIX 5L Based Systems (64-Bit), HP-UX PA-RISC (64-Bit), Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64

Part Number B31042-02
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 Micorsoft SQL Server.

To install the gateway, 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" on .

  2. Run the Oracle Universal Installer.

    See "Step Through the Oracle Universal Installer" on for more information about 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-3 for a 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 2–1 shows the minimum hardware requirements for Oracle Database Gateway for SQL Server.

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

Hardware Items Required for AIX-Based System Required for HP 9000 Series HP-UX PA-RISC Required for Solaris Operating System (SPARC) Required for Linux x86 Required for Linux x86 64 bit

Temporary Disk Space

400 MB

400 MB

400 MB

400 MB

400 MB

Disk Space

1.5 GB

1.5 GB

750 MB

750 MB

750 MB

Physical Memory*

512 MB

512 MB

512 MB

512 MB

512 MB

Swap Space

1 GB

1 GB

1 GB

1 GB

1 GB

Processor

IBM RS/6000 AIX-Based System Processor

HP 9000 Series 700 or 800 processor for hp-ux 11.0

Sun Solaris Operating System (SPARC) Processor

x86

x86_64


* The minimum swap space is 1 GB (or twice the size of RAM). On systems with 2 GB or more of RAM, the swap space can be between one and two times the size of RAM. On AIX systems with 1 GB or more of memory, do not increase the swap space more than 2 GB.

8.1.1.1 Checking the Hardware Requirements

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

  1. To determine the physical RAM size, enter one of the following commands:

    Operating System Command
    AIX # /usr/sbin/lsattr -E -l sys0 -a realmem
    HP-UX PA-RISC # /usr/sbin/dmesg | grep "Physical:"
    Solaris (SPARC) # /usr/sbin/prtconf | grep "Memory size"
    Linux x86 # grep MemTotal /proc/meminfo
    Linux x86 64 bit # grep MemTotal /proc/meminfo

    If the size of the physical RAM installed in the system is less than the required size, you must install more memory before continuing.

  2. To determine the size of the configured swap space, enter one of the following commands:

    Operating System Command
    AIX # /usr/sbin/lsps -a
    HP-UX PA-RISC # /usr/sbin/swapinfo -a
    Solaris (SPARC) # /usr/sbin/swap -s
    Linux x86 # grep SwapTotal /proc/meminfo
    Linux x86 64 bit # grep SwapTotal /proc/meminfo

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

  3. To determine the amount of disk space available in the /tmp directory enter the following commands:

    Operating System Command
    AIX # df -k /tmp
    HP-UX PA-RISC # df -k /tmp
    Solaris (SPARC) # df -k /tmp
    Linux x86 # df -k /tmp
    Linux x86 64 bit # df -k /tmp

  4. To determine the amount of disk space available on the system enter the following commands:

    Operating System Command
    AIX # df -k
    HP-UX PA-RISC # df -k
    Solaris (SPARC) # df -k
    Linux x86 # df -k
    Linux x86 64 bit # df -k

8.1.2 Software Requirements

The following section describes the minimum software requirements for Oracle Database Gateway for SQL Server.

8.1.2.1 Operating System

Table 8-2 shows the minimum operating system version required for Oracle Database Gateway for SQL Server. If your operating system is lower than the minimum requirements, upgrade your operating system to meet the specified levels.

Table 8-2 Operating Systems version for Oracle Database Gateway for SQL Server

Operating System Version

AIX

AIX 5L version 5.3, Maintenance level 02 or higher

HP-UX PA-RISC

HP-UX PA-RISC 11i V1 (11.11), 11i V2 (11.23) PA-RISC

Solaris (SPARC)

Solaris 9 Update 6 or higher or Solaris 10, 64-bit

Linux x86 Red Hat

One of the following operating system versions:

  • Red Hat Enterprise Linux AS/ES 3.0 (Update 4 or later)

  • Red Hat Linux 4.0

Linux x86 Suse

SUSE Linux Enterprise Server 9.0 with SP 2 or later

Linux x86 64 bit Red Hat

One of the following operating system versions:

  • Red Hat Enterprise Linux AS/ES 3.0 (Update 4 or later)

  • Red Hat Enterprise Linux AS/ES 4.0 (Update 1 or later)

Linux x86 64 bit Suse

SUSE Linux Enterprise Server 9.0 with SP2 or later


8.1.2.2 Checking the Software Requirements

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

  • To determine which version of AIX is installed, enter the following command:

    # oslevel -r
    
  • To determine which version of HP-UX PA-RISC is installed, enter the following command:

    # uname -a
    
  • To determine which version of Solaris Operating System (SPARC) is installed, enter the following command:

    # uname -r
    
  • To determine which distribution and version of Linux x86 is installed, enter the following command:

    # cat /etc/issue
    
  • To determine which distribution and version of Linux x86 64 bit is installed, enter the following command:

    # cat /proc/version
    

8.1.2.3 Certified Configuration

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

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

8.2 Step Through the Oracle Universal Installer

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

Table 8-3 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 media, the Oracle Universal Installer displays the Available Products screen.

Oracle Universal Installer: Available Product Components

a. Select Oracle Database Gateway for SQL Server 11.1.0.6.0.

b. Click Next.

Oracle Database Gateway for SQL Server

SQL Server Database Server Host Name - Specify the host name of the machine hosting the MS 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.