Skip Headers

Oracle9i Database Installation Guide
Release 2 (9.2.0.1.0) for Windows
Part Number A95493-01
Go To Table Of Contents
Contents		 Go To Index
Index

Go to previous page Go to next page

C
Oracle Transparent Gateways

This appendix explains how to install the Oracle Transparent Gateway software from the component CD.

This appendix contains these topics:

System Requirements for Oracle Transparent Gateways

Review the following sections before installing Oracle Transparent Gateways:

Gateway components can be located on one platform or distributed over several platforms. Use the installation worksheet provided for your configuration to ensure that you have all the information required before beginning installation.

As Oracle continues to support new releases and changes of the Oracle database server and Microsoft SQL Server, the supported configuration information is updated. For current, supported configuration information, visit: 

http://www.oracle.com/gateways/

Gateway System Requirements

The following tables summarize system requirements for Oracle Transparent Gateways. Oracle Corporation supports the software configurations described in this section as long as the underlying system software products are supported by their respective vendors. Verify the latest support status with your system software vendors. Refer to the table that contains information about the database type for which you need access:

Microsoft SQL Server Gateway System Requirements

Review Table C-1 to ensure that your system meets requirements to create a gateway for the Oracle Transparent Gateway for Microsoft SQL Server.

Table C-1 Microsoft SQL Server Gateway System Requirements  
Hardware and Software Requirements

Processor

An Intel or 100% compatible personal computer (PC), based on a Pentium processor

Memory

26 MB 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 issued by the user

  • The number of cursors currently opened against Microsoft SQL

  • The number of columns in the table being accessed

CD Drive

An internal or external CD drive

Disk Space

200 MB of free disk space

Operating System

Microsoft Windows NT Workstation Version 4.0, Microsoft Windows NT Server Version 4.0, or Microsoft Windows 2000

Oracle Database Server

Oracle9i release 2 (9.2)

The Oracle database server can reside on any supported platform.

Oracle Networking

On the gateway computer:

  • Oracle Net Services

  • Oracle Protocol Support for Named Pipes or TCP/IP

On the Oracle database server computer:

  • Oracle Net Services

  • Oracle Protocol Support for Named Pipes or TCP/IP

The Oracle Net Services components are included on the Oracle9i component CD.

Microsoft
  • Network transport protocol software, TCP/IP or Named Pipes, included with Microsoft Windows NT

  • Microsoft SQL Server Version 7.0 or SQL Server 2000, installed on a computer with Microsoft Windows NT Server

Sybase Gateway System Requirements

Review Table C-2 to ensure that your system meets requirements to create a gateway for the Oracle Transparent Gateway for Sybase.

Table C-2 Sybase Gateway System Requirements  
Hardware and Software Requirements

Processor

An Intel or 100% compatible personal computer (PC), based on a Pentium processor

Memory

26 MB 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 issued by the user

  • The number of cursors currently opened against Sybase

  • The number of columns in the table being accessed

CD Drive

An internal or external CD drive

Disk Space

200 MB of free disk space

Operating System

Microsoft Windows NT Workstation Version 4.0, Microsoft Windows NT Server Version 4.0, or Microsoft Windows 2000

Oracle Database Server

Oracle9i release 2 (9.2)

The Oracle database server can reside on any supported platform.

Oracle Networking

On the gateway computer:

  • Oracle Net Services

  • Oracle Protocol Support for Named Pipes or TCP/IP

On the Oracle database server computer:

  • Oracle Net Services

  • Oracle Protocol Support for Named Pipes or TCP/IP

The Oracle Net Services components are included on the Oracle9i component CD.

Sybase

Sybase Server, version 11.9.2, 12.0, or 12.5 is required. If Sybase Server is not on the same computer as the gateway, then the version of Sybase Open client library certified for your Sybase Server is required.

Teradata Gateway System Requirements

Review Table C-3 to ensure that your system meets requirements to create a gateway for the Oracle Transparent Gateway for Teradata.

Table C-3 Teradata Gateway System Requirements  
Hardware and Software Requirements

Processor

An Intel or 100% compatible personal computer (PC), based on a Pentium processor

Memory

26 MB 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 issued by the user

  • The number of cursors currently opened against Teradata

  • The number of columns in the table being accessed

CD Drive

An internal or external CD drive

Disk Space

200 MB of free disk space

Operating System

Windows NT Workstation Version 4.0, Microsoft Windows NT Server Version 4.0, or Microsoft Windows 2000

Oracle Database Server

Oracle9i release 2 (9.2)

The Oracle database server can reside on any supported platform.

Oracle Networking

On the gateway computer:

  • Oracle Net Services

  • Oracle Protocol Support for Named Pipes or TCP/IP

On the Oracle database server computer:

  • Oracle Net Services

  • Oracle Protocol Support for Named Pipes or TCP/IP

The Oracle Net Services components are included on the Oracle9i component CD.

Teradata

Teradata V2R.03.00.02 or V2R.04.00.0115

NCR's Teradata ODBC Driver

Version 02.08.00.00

See Also:

For installation and configuration information about Enterprise Integration Gateways, refer to the following documentation located on the Oracle Enterprise Integration Gateways documentation CD:

  • Oracle Transparent Gateway for IBM DRDA Installation and User's Guide for Windows

  • Oracle Procedural Gateway for APPC Installation and Configuration Guide for Windows

  • Oracle Procedural Gateway and Tools for IBM MQSeries Installation and User's Guide for Windows

Tested Gateway Configurations

The following tables provide gateway configurations tested by Oracle at the time of this document release. Oracle continues to provide support for the most recent releases of Oracle and non-Oracle systems in a timely manner.

See Also:

Oracle Corporation continually updates supported gateway configurations. For the latest supported configuration information, either contact Oracle Support Services or visit the following Web site:

http://www.oracle.com/gateways/

Microsoft SQL Server Gateway Configurations

See Table C-4 for configurations for creating a gateway for the Oracle Transparent Gateway for Microsoft SQL Server.

Table C-4 Microsoft SQL Server Gateway Configurations
Database Gateway and Operating System

Microsoft SQL Server Version 7.0

tg4msql release 9.2 running on Windows NT 4.0, Service Pack 5 or higher

tg4msql release 9.2 running on Windows 2000, Service Pack 1 or higher

Microsoft SQL Server 2000

tg4msql release 9.2 running on Windows NT 4.0, Service Pack 5 or higher

tg4msql release 9.2 running on Windows 2000, Service Pack 1 or higher

Sybase Gateway Configurations

See Table C-5 for configurations for creating a gateway for the Oracle Transparent Gateway for Sybase.

Table C-5 Sybase Gateway Configurations  
Database Gateway and Operating System

Sybase Version 11.9.2

tg4sybs release 9.2 running on Windows NT 4.0, Service Pack 5 or higher

tg4sybs release 9.2 running on Windows 2000, Service Pack 1 or higher

Sybase Version 12.0

tg4sybs release 9.2 running on Windows NT 4.0, Service Pack 5 or higher

tg4sybs release 9.2 running on Windows 2000, Service Pack 1 or higher

Sybase Version 12.5

tg4sybs release 9.2 running on Windows NT 4.0, Service Pack 5 or higher

tg4sybs release 9.2 running on Windows 2000, Service Pack 1 or higher

Teradata Gateway Configurations

See Table C-6 for configurations for creating a gateway for the Oracle Transparent Gateway for Teradata.

Table C-6 Teradata Gateway Configurations
Database Gateway and Operating System

Teradata V2R.03.00.02 through NCR's Teradata ODBC Driver Version 02.08.00.00

tg4tera release 9.2 running on Windows NT 4.0, Service Pack 5 or higher

tg4tera release 9.2 running on Windows 2000, Service Pack 1 or higher

Teradata V2R.04.00.0115 through NCR's Teradata ODBC Driver Version 02.08.00.00

tg4tera release 9.2 running on Windows NT 4.0, Service Pack 5 or higher

tg4tera release 9.2 running on Windows 2000, Service Pack 1 or higher

Gateway Installation Worksheets

Select the worksheet appropriate for your system in one of the following tables, and use the values you enter as a reference during the configuration process:

Microsoft SQL Server Worksheet

Enter your system values in Table C-7 to prepare for a Microsoft SQL Server gateway configuration.

.
Table C-7 Microsoft SQL Server Installation Worksheet  
Description Value

Oracle database server computer name

Oracle database server platform (operating system and its version number)

ORACLE_HOME of Oracle database server (full path name)

Gateway computer name

Gateway computer platform (operating system and its version number)

ORACLE_HOME of the gateway (full path name)

Name of the Microsoft SQL Server to which the gateway will connect

Name of the Microsoft SQL Server database to which the gateway will connect

Sybase Worksheet

Enter your system values in Table C-8 to prepare for a Sybase gateway configuration.

.
Table C-8 Sybase Installation Worksheet  
Description Value

Oracle database server computer name

Oracle database server platform (operating system and its version number)

ORACLE_HOME of Oracle database server (full path name)

Gateway computer name

Gateway computer platform (operating system and its version number)

ORACLE_HOME of the gateway (full path name)

Name of the Sybase Server to which the gateway will connect

Name of the Sybase database to which the gateway will connect

Teradata Worksheet

Enter your system values in Table C-9 to prepare for a Teradata gateway configuration.

Table C-9 Teradata Installation Worksheet
Description Value

Oracle database server computer name

Oracle database server platform (operating system and its version number)

ORACLE_HOME of Oracle database server (full path name)

Gateway computer name

ORACLE_HOME of the gateway (full path name)

ODBC Data Source Name (DSN) to be used by the gateway

Installing Oracle Transparent Gateways

Complete instructions for starting Oracle Universal Installer and installing the Gateway software are discussed in Chapter 4.

See Also:

Deinstalling Oracle Transparent Gateways

Complete instructions for deinstalling Oracle components are discussed in Chapter 4.

See Also:

"Deinstalling Components with Oracle Universal Installer"

Go to previous page Go to next page
Oracle
Copyright © 2001, 2002 Oracle Corporation.
All Rights Reserved.
Go To Table Of Contents
Contents		 Go To Index
Index