Oracle Transparent Gateway

 

System Requirements for Oracle Transparent Gateway

Review your system's hardware and software to ensure that it meets requirements, and determine gateway configuration before you install the gateway. Gateway components can be located on one platform or distributed over several platforms.

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.

Use the installation worksheet provided for your configuration to ensure that you have all required information before beginning installation.

 

Informix Gateway Requirements

The following table describes the hardware and software requirements for an Informix gateway. Use it to ensure that your system meets requirements to create a gateway for the Oracle Transparent Gateway for Informix.

 

Informix Gateway Requirements

Hardware/ Software	Platform	Requirements
Processor	HP	An HP workstation running the required version of HP-UX.
	Solaris	A Sun SPARC workstation running the required version of Solaris.
Memory	HP	26 MB of real memory is recommended to support the gateway. The total real memory requirement for the concurrent use of the gateway depends on these factors: The SQL statement issued by the user. The number of cursors currently opened against Informix. The number of columns in the table being accessed.
	Solaris	26 MB of real memory is recommended to support the gateway. The total real memory requirement for the concurrent use of the gateway depends on these factors: The SQL statement issued by the user. The number of cursors currently opened against Informix. The number of columns in the table being accessed.
CD-ROM Drive	HP	An internal or external CD-ROM drive.
	Solaris	An internal or external CD-ROM drive.
Disk Space	HP	200 MB.
	Solaris	200 MB.
Operating System	HP	HP version 11.
	Solaris	Solaris version 2.6 (5.6), 7 (5.7) or 8 (5.8).
Oracle Database Server	HP	Oracle9i Enterprise Edition Server release 1 (9.0.1). Oracle database server can reside on any supported platform.
	Solaris	Oracle9i Enterprise Edition Server release 1 (9.0.1). Oracle database server can reside on any supported platform.
Oracle Networking	HP	On gateway machine: Oracle Net Server release 9.0.1. Oracle Adapter for Named Pipes or TCP/IP. The following are required on the Oracle database server machine: Oracle Net Client release 9.0.1. Oracle Adapter for Named Pipes or TCP/IP. Oracle Net products are included on the distribution CD-ROM. Oracle Net or Oracle Net Client and the Oracle Adapter must be installed on the machine where the Oracle database server is installed. Oracle Net Server and the Oracle Adapter must be installed on the machine where the gateway is installed.
	Solaris	On gateway machine: Oracle Net Server release 9.0.1 Oracle Adapter for Named Pipes or TCP/IP. The following are required on the Oracle database server machine: Oracle Net Client release 9.0.1. Oracle Adapter for Named Pipes or TCP/IP. Oracle Net products are included on the distribution CD-ROM. Oracle Net or Oracle Net Client and the Oracle Adapter must be installed on the machine where the Oracle database server is installed. Oracle Net Server and the Oracle Adapter must be installed on the machine where the gateway is installed.
Informix	HP	INFORMIX-OnLine, version 7.2, 7.3 or 7.4 and INFORMIX-ESQL/C are required. This version of the gateway does not support INFORMIX-SE.
	Solaris	INFORMIX-OnLine, version 7.2, 7.3 or 7.4 and INFORMIX-ESQL/C are required. This version of the gateway does not support INFORMIX-SE.

 

Ingres Gateway Requirements

The following table describes the hardware and software requirements for an Ingres gateway. Use it to ensure that your system meets requirements to create a gateway for the Oracle Transparent Gateway for Ingres.

 

Ingres Gateway Requirements

Hardware/ Software	Platform	Requirements
Processor	HP	A HP workstation running the required version of HP-UX.
	Solaris	A Sun SPARC workstation running the required version of Solaris.
Memory	HP	26 MB of real memory is recommended to support the gateway. The total real memory requirement for the concurrent use of the gateway depends on these factors: The SQL statement issued by the user. The number of cursors currently opened against Ingres. The number of columns in the table being accessed.
	Solaris	26 MB of real memory is recommended to support the gateway. The total real memory requirement for the concurrent use of the gateway depends on these factors: The SQL statement issued by the user. The number of cursors currently opened against Ingres. The number of columns in the table being accessed.
CD-ROM Drive	HP	An internal or external CD-ROM drive.
	Solaris	An internal or external CD-ROM drive.
Disk Space	HP	200 MB.
	Solaris	200 MB.
Operating System	HP	HP version 11
	Solaris	Solaris
Oracle Database Server	HP	Oracle9i Enterprise Edition Server release 1 (9.0.1). Oracle database server can reside on any supported platform.
	Solaris	Oracle9i Enterprise Edition Server release 1 (9.0.1). Oracle database server can reside on any supported platform.
Oracle Networking	HP	On gateway machine: Oracle Net Server release 9.0.1. Oracle Adapter for Named Pipes or TCP/IP. The following are required on the Oracle database server machine: Oracle Net Client release 9.0.1. Oracle Adapter for Named Pipes or TCP/IP. Oracle Net products are included on the distribution CD-ROM. Oracle Net or Oracle Net Client and the Oracle Adapter must be installed on the machine where the Oracle database server is installed. Oracle Net Server and the Oracle Adapter must be installed on the machine where the gateway is installed.
	Solaris	On gateway machine: Oracle Net Server release 9.0.1. Oracle Adapter for Named Pipes or TCP/IP. The following are required on the Oracle database server machine: Oracle Net Client release 9.0.1. Oracle Adapter for Named Pipes or TCP/IP. Oracle Net products are included on the distribution CD-ROM. Oracle Net or Oracle Net Client and the Oracle Adapter must be installed on the machine where the Oracle database server is installed. Oracle Net Server and the Oracle Adapter must be installed on the machine where the gateway is installed.
Ingres	HP	Ingres II version 2.0.
	Solaris	Ingres II version 2.0.

 

Sybase Gateway Requirements

describes the hardware and software requirements for a Sybase gateway. Use it to ensure that your system meets requirements to create a gateway for the Oracle Transparent Gateway for Sybase.

 

Sybase Gateway Requirements

Hardware/ Software	Platform	Requirements
Processor	AIX	An IBM workstation running the required version of AIX.
	HP	An HP workstation running the required version of HP-UX.
	Solaris	A Sun SPARC workstation running the required version of Solaris.
	Tru64	A Compaq Alpha workstation running the required version of Tru64 UNIX.
Memory	AIX	26 MB of real memory is recommended to support the gateway. The total memory requirement for the concurrent use of the gateway 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.
	HP	26 MB of real memory is recommended to support the gateway. The total memory requirement for the concurrent use of the gateway 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.
	Solaris	26 MB of real memory is recommended to support the gateway. The total memory requirement for the concurrent use of the gateway 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.
	Tru64	26 MB of real memory is recommended to support the gateway. The total memory requirement for the concurrent use of the gateway 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-ROM Drive	AIX	An internal or external CD-ROM drive.
	HP	An internal or external CD-ROM drive.
	Solaris	An internal or external CD-ROM drive.
	Tru64	An internal or external CD-ROM drive.
Disk Space	AIX	200 MB.
	HP	200 MB.
	Solaris	200 MB.
	Tru64	200 MB.
Operating System	AIX	AIX version 4.3.3
	HP	HP version 11
	Solaris	Solaris
	Tru64	Tru64 version 5.0a or above.
Oracle database server	AIX	Oracle9i Enterprise Edition Server release 1 (9.0.1). Oracle database server can reside on any supported platform.
	HP	Oracle9i Enterprise Edition Server release 1 (9.0.1). Oracle database server can reside on any supported platform.
	Solaris	Oracle9i Enterprise Edition Server release 1 (9.0.1). Oracle database server can reside on any supported platform.
	Tru64	Oracle9i Enterprise Edition Server release 1 (9.0.1). Oracle database server can reside on any supported platform.
Oracle Networking	AIX	The following are required on the gateway machine: Oracle Net Server release 9.0.1 Oracle Adapter for Named Pipes or TCP/IP. Oracle Net Server and the Oracle Adapter must be installed on the machine where the gateway is installed. The following are required on the Oracle database server machine: Oracle Net Client release 9.0.1. Oracle Adapter for Named Pipes or TCP/IP. Oracle Net or Oracle Net Client and the Oracle Adapter must be installed on the machine where the Oracle database server is installed. The Oracle Net products are included on the Oracle9i distribution CD-ROM.
	HP	The following are required on the gateway machine: Oracle Net Server release 9.0.1 Oracle Adapter for Named Pipes or TCP/IP. Oracle Net Server and the Oracle Adapter must be installed on the machine where the gateway is installed. The following are required on the Oracle database server machine: Oracle Net Client release 9.0.1. Oracle Adapter for Named Pipes or TCP/IP. Oracle Net or Oracle Net Client and the Oracle Adapter must be installed on the machine where the Oracle database server is installed. The Oracle Net products are included on the Oracle9i distribution CD-ROM.
	Solaris	The following are required on the gateway machine: Oracle Net Server release 9.0.1 Oracle Adapter for Named Pipes or TCP/IP. Oracle Net Server and the Oracle Adapter must be installed on the machine where the gateway is installed. The following are required on the Oracle database server machine: Oracle Net Client release 9.0.1. Oracle Adapter for Named Pipes or TCP/IP. Oracle Net or Oracle Net Client and the Oracle Adapter must be installed on the machine where the Oracle database server is installed. The Oracle Net products are included on the Oracle9i distribution CD-ROM.
	Tru64	The following are required on the gateway machine: Oracle Net Server release 9.0.1 Oracle Adapter for Named Pipes or TCP/IP. Oracle Net Server and the Oracle Adapter must be installed on the machine where the gateway is installed. The following are required on the Oracle database server machine: Oracle Net Client release 9.0.1. Oracle Adapter for Named Pipes or TCP/IP. Oracle Net or Oracle Net Client and the Oracle Adapter must be installed on the machine where the Oracle database server is installed. The Oracle Net products are included on the Oracle9i distribution CD-ROM.
	AIX	Sybase Server or Client, version 11.9.2 or 12.0 is required. If Sybase Server is not on the same machine as the gateway, then the version of Sybase Open Library certified for your Sybase Server is required.
	HP	Sybase Server or Client, version 11.9.2 or 12.0. If Sybase Server is not on the same machine as the gateway, then the version of Sybase Open Library certified for your Sybase Server is required.
	Solaris	Sybase Server or Client, version 11.9.2 or 12.0. If Sybase Server is not on the same machine as the gateway, then the version of Sybase Open Library certified for your Sybase Server is required.
	Tru64	Sybase Server or Client, version 11.9.2 or 12.0. If Sybase Server is not on the same machine as the gateway, then the version of Sybase Open Library certified for your Sybase Server is required.

 

Teradata Gateway Requirements

describes the hardware and software requirements for a Teradata gateway. Use it to ensure that your system meets requirements to create a gateway for the Oracle Transparent Gateway for Teradata.

 

Teradata Gateway Hardware Requirements

Hardware	Platform	Requirements
Processor	HP	An HP workstation running the required version of HP-UX.
	Solaris	A Sun SPARC workstation running the required version of Solaris.
Memory	HP	26 MB of real memory is recommended to support the gateway. The total memory requirement for the concurrent use of the gateway 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.
	Solaris	26 MB of real memory is recommended to support the gateway. The total memory requirement for the concurrent use of the gateway 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-ROM Drive	HP	An internal or external CD-ROM drive.
	Solaris	An internal or external CD-ROM drive.
Disk Space	HP	200 MB.
	Solaris	200 MB.
Operating System	HP	HP version 11.
	Solaris	Solaris version 2.6 (5.6), 7 (5.7) or 8 (5.8).
Oracle database server	HP	Oracle9i Enterprise Edition Server release 1 (9.0.1). Oracle database server can reside on any supported platform.
	Solaris	Oracle9i Enterprise Edition Server release 1 (9.0.1). Oracle database server can reside on any supported platform.
Oracle Networking	HP	The following are required on the gateway machine: Oracle Net Server release 9.0.1. Oracle Adapter for Named Pipes or TCP/IP. Oracle Net Server and the Oracle Adapter must be installed on the machine where the gateway is installed. The following are required on the Oracle database server machine: Oracle Net Client release 9.0.1. Oracle Adapter for Named Pipes or TCP/IP. Oracle Net or Oracle Net Client and the Oracle Adapter must be installed on the machine where the Oracle database server is installed. The Oracle Net products are included on the Oracle9i distribution CD-ROM.
	Solaris	The following are required on the gateway machine: Oracle Net Server release 9.0.1. Oracle Adapter for Named Pipes or TCP/IP. Oracle Net Server and the Oracle Adapter must be installed on the machine where the gateway is installed. The following are required on the Oracle database server machine: Oracle Net Client release 9.0.1. Oracle Adapter for Named Pipes or TCP/IP. Oracle Net or Oracle Net Client and the Oracle Adapter must be installed on the machine where the Oracle database server is installed. The Oracle Net products are included on the Oracle9i distribution CD-ROM.
Teradata	HP	Teradata V2R.03.00.02 or V2R.04.00.0115.
	Solaris	Teradata V2R.03.00.02 or V2R.04.00.0115.
NCR's Teradata ODBC Driver	HP	version 02.04.00.00.
	Solaris	version 02.04.00.00.

 

Tested Gateway Configurations

The following tables provide gateway configurations tested by Oracle Corporation 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.

 

Tested Gateway Configurations

Database	Gateway and Operating System
Informix version 7.2	tg4ifmx version 9.0.1 running on Sun SPARC Solaris version 2.6 (5.6), 7 (5.7) or 8 (5.8). tg4ifmx version 9.0.1 running on HP-UX 11.0
Informix version 7.3	tg4ifmx version 9.0.1 running on Solaris version 2.6 (5.6), 7 (5.7) or 8 (5.8). tg4ifmx version 9.0.1 running on HP version 11.0
Informix version 7.4	tg4ifmx version 9.0.1 running on Solaris version 2.6 (5.6), 7 (5.7) or 8 (5.8). tg4ifmx version 9.0.1 running on HP version 11.0
Ingres II version 2.0	tg4ingr version 9.0.1 running on Solaris version 2.6 (5.6), 7 (5.7) or 8 (5.8). tg4ingr version 9.0.1 running on HP version 11.0
Sybase version 11.9.2	tg4sybs version 9.0.1 running on AIX version 4.3.3 tg4sybs version 9.0.1 running on HP version 11.0 tg4sybs version 9.0.1 running on Solaris version 2.6 (5.6), 7 (5.7) or 8 (5.8). tg4sybs version 9.0.1 running on Tru64 version 5.1
Sybase version 12.0	g4sybs version 9.0.1 running on AIX version 4.3.3 tg4sybs version 9.0.1 running on HP version 11.0 tg4sybs version 9.0.1 running on Solaris version 2.6 (5.6), 7 (5.7) or 8 (5.8). tg4sybs version 9.0.1 running on Tru64 version 5.1
Teradata V2R3.03.00.02	tg4tera version 9.0.1 running on Solaris version 2.6 (5.6), 7 (5.7) or 8 (5.8) through NCR's ODBC Driver for Teradata V02.04.00.00 tg4tera version 9.0.1 running on HP version 11.0 through NCR's ODBC Driver for Teradata V02.04.00.00
Teradata V2R04.03.00.15	tg4tera version 9.0.1 running on Solaris version 2.6 (5.6), 7 (5.7) or 8 (5.8) through NCR's ODBC Driver for Teradata V02.04.00.00 tg4tera version 9.0.1 running on HP version 11.0 through NCR's ODBC Driver for Teradata V02.04.00.00

 

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:

 

Informix Worksheet

Enter your system values in the following table to prepare for an Informix gateway configuration.

 

Informix Installation Worksheet

Description	Value
Oracle database server machine name
Oracle database server platform (OS and its version number)
$ORACLE_HOME of Oracle database server (full path name)
Gateway machine name
Gateway machine platform (OS and its version number)
$ORACLE_HOME of the gateway (full path name)
Informix client library location (full path name)
Name of the Informix server to which the gateway will connect
Name of the Informix database to which the gateway will connect

 

Ingres Worksheet

Enter your system values in the following table to prepare for an Ingres gateway configuration.

 

Ingres Installation Worksheet

Description	Value
Oracle database server machine name
Oracle database server platform (OS and its version number)
$ORACLE_HOME of Oracle database server (full path name)
Gateway machine name
Gateway machine platform (OS and its version number)
$ORACLE_HOME of the gateway (full path name)
Ingres net/server installed location (full path name)
Name of the Ingres virtual node that will be used to access a remote, networked Ingres server
Name of the Ingres database to which the gateway will connect

 

Sybase Worksheet

Enter your system values in the following table to prepare for a Sybase gateway configuration. .

 

 Sybase Installation Worksheet

Description	Value
Oracle database server machine name
Oracle database server platform (OS and its version number)
$ORACLE_HOME of Oracle database server (full path name)
Gateway machine name
Gateway machine platform (OS and its version number)
$ORACLE_HOME of the gateway (full path name)
Name of the Sybase Adaptive Server to which the gateway will connect

 

Teradata Worksheet

Enter your system values in the following table to prepare for a Teradata gateway configuration.

 

Teradata Installation Worksheet

Description	Value
Oracle database server machine name
Oracle database server platform (OS and its version number)
$ORACLE_HOME of Oracle database server (full path name)
Gateway machine name
Gateway machine platform (OS and its version number)
$ORACLE_HOME of the gateway (full path name)
Version of the Teradata Server to which the gateway will connect .
ODBC Data Source Name (DSN) to be used by the gateway.
Directory where the NCR ODBC Driver for Teradata is installed.

Installing Oracle Transparent Gateway

Use the following procedures and tables to install Oracle Transparent Gateway.

 

Mounting Transparent Gateway from the CD-ROM

Install the gateway software from the CD-ROM as follows:

1. Start the Oracle Universal Installer.

   Complete instructions for mounting and running the Oracle Universal Installer are not presented here. Review Chapter 3, "Installation" to find complete mounting and starting instructions for your platform. As a gateway is installed using Custom Installation, note in particular "Oracle9i Database Custom Installation. 

 

Installation Prompts for Transparent Gateway

The Oracle Universal Installer screens and the sequence in which they appear depend on your platform. Select the installation prompt section that corresponds to the e gateway will connect.

 

Installation Prompts for Informix Gateway

 

Installation Prompts and Responses for Informix

Screen	Response
Informix Client Library Path: The complete path where the Informix client library is installed.	In the Informix Client Library Path text box, enter the location of your Informix client library files. Specify full paths with directory names not exceeding 32 alphanumeric characters. When you have entered these names, click the Next button.

Completing Ingres Gateway Installation

When the Summary screen appears, click Install.

Verify that the installation was successful after the Oracle Universal Installer confirms that the installation has been completed. Check the contents of the installActions.log file located in the orainventory_location/logs/ directory.

 

Installation Prompts for Sybase Gateway

Follow the instructions in the Response column for each entry in the Screen column.

 

Installation Prompts and Responses for Sybase

Screen	Response
Sybase Path: The complete path where Sybase is installed.	In the Sybase path text box, type the complete directory path where the Sybase software is installed. The gateway will connect to this database. When you have entered this path, click the Next button.
Sybase Server and Database Names: Names of the SYBASE server and the SYBASE database.	In the Sybase Server text box, type the name of the Sybase server. The gateway will connect to this server. In the Sybase Database text box, type the name of the Sybase database. The gateway will connect to this database. When you have entered these names, click the Next button.

Completing Teradata Gateway Installation

When the Summary screen appears, click Install.

Verify that the installation was successful after the Oracle Universal Installer confirms that the installation has been completed. Check the contents of the installActions.log file located in the orainventory_location/logs/ directory.

Removing Oracle Transparent Gateway

Remove the gateway as follows:

1. Start the Oracle Universal Installer.

2. Click the De-install Products button on the Welcome window or the Installed Products ... button available on any Oracle Universal Installer window. The Inventory window appears and displays a list of installed products.

3. Click to select the gateway product in the Inventory window and click Remove.

   Only the files that were copied into the Oracle home directory during the gateway installation are automatically removed. You must manually remove all other related files.