C Oracle Transparent Gateway

This appendix describes how to install the gateway software from the distribution installation mediaIt contains the following topics:

Section C.1, "System Requirements for Oracle Transparent Gateway"
Section C.2, "Installing Oracle Transparent Gateway"
Section C.3, "Removing Oracle Transparent Gateway"

C.1 System Requirements for Oracle Transparent Gateway

Oracle supports the software configurations that are described in this section if, and only if, the underlying system software products are supported by their respective vendors. Verify the latest support status with your system software vendors.

Review the system hardware and software to ensure that it meets requirements, and then determine gateway configuration before you install the gateway. Gateway components can be located on one platform or distributed over several platforms. These gateways are shipped on the server installation media and are built with Oracle libraries. The operating system requirements for the gateways are therefore the same as that for Oracle Database.

Refer to Chapter 1, "Installation Overview" and Chapter 2, "Preinstallation Tasks" for the database requirements.

The requirements for Oracle Net Services working on the gateway computer are Oracle Net Services Server Release 10.1.0.3.0. The requirements for Oracle Net Services working on Oracle Database server computer are Oracle Net Services Client Release 10.1.0.3.0.

Use the installation worksheet that is provided for your configuration to ensure that you have all required information before beginning installation. The following sections describe system requirements for gateway configuration and provide worksheets to use during the installation:

Section C.1.1, "Rdb Gateway Requirements"
Section C.1.2, "RMS Gateway Requirements"
Section C.1.3, "Tested Gateway Configurations"
Section C.1.4, "Gateway Installation Worksheets"

C.1.1 Rdb Gateway Requirements

Table C-1 describes the hardware and software requirements for an Rdb gateway. Use it to ensure that the system meets requirements to create a gateway for Rdb.

Table C-1 Rdb Gateway Requirements

Hardware/ Software	Requirements
Processor	A Hewlett-Packard Alpha workstation running the required version of HP OpenVMS.
Memory	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 the following factors: The SQL statement issued by the user. The number of cursors currently opened against Rdb. The number of columns in the table being accessed.
DVD drive	An internal or external DVD drive.
Disk space	200 MB
Operating system	For HP OpenVMS Alpha: HP OpenVMS 8.2 For HP OpenVMS Itanium: HP OpenVMS 8.2-1
Operating system patch	Use the latest patch kit from Hewlett-Packard. Hewlett-Packard provides patch information at `http://www.hp.com/support`
Oracle Net Services Requirements	Oracle Net Services on HP OpenVMS is developed and certified using Hewlett-Packard TCP/IP Services for HP OpenVMS (UCX). If you want to use the TCP/IP protocol adapter for Oracle Net Services, you should have version 5.5 ECO 1 or higher of TCP/IP Services for HP OpenVMS installed. TCP/IP protocol stacks from other vendors may work with Oracle, but customers use these products at their own risk. Any TCP/IP problems that cannot be reproduced using TCP/IP Services for HP OpenVMS will be referred to the TCP/IP vendor. Vendor-provided protocol services are usually upward-compatible, so that existing applications will continue to work without modification. Therefore, later releases of TCP/IP are upward-compatible with Oracle Net Services, if the vendor-specified application programming interface (API) does not change with new releases.
Oracle Database Server	Oracle Database Enterprise Edition server Release 1 (10.1.0.3.0) Oracle Database server can reside on any supported platform.
Oracle Net Services	On gateway computer: Oracle Net Services Server Release 10.1.0.3.0 Oracle Adapter for Named Pipes or TCP/IP The following are required on Oracle Database server computer: Oracle Net Services Client Release 10.1.0.3.0 Oracle Adapter for Named Pipes or TCP/IP Oracle Net Services products are included on the distribution DVD . Oracle Net Services or Oracle Net Services Client and the Oracle Adapter must be installed on the computer where Oracle Database server is installed. Oracle Net Services Server and the Oracle Adapter must be installed on the computer where the gateway is installed.
Rdb	Rdb Release 7.1 This is the latest release of Rdb.

C.1.2 RMS Gateway Requirements

Table C-2 describes the hardware and software requirements for an RMS gateway. Use it to ensure that the system meets requirements to create a gateway for the Oracle Transparent Gateway for RMS.

Table C-2 RMS Gateway Requirements

Hardware/Software	Requirements
Processor	A Hewlett-Packard Alpha workstation running the required version of HP OpenVMS
Memory	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 the following factors: The SQL statement issued by the user The number of cursors currently opened against RMS The number of columns in the table that is being accessed
DVD Drive	An internal or external DVD drive
Disk Space	200 MB
Operating System	For HP OpenVMS Alpha: HP OpenVMS 8.2 For HP OpenVMS Itanium: HP OpenVMS 8.2-1
Operating System Patch	Use the latest patch kit from Hewlett-Packard. Hewlett-Packard provides patch information at the following URL: `http://www.hp.com/support`
Oracle Net Services Requirements	Oracle Net Services on HP OpenVMS is developed and certified using Hewlett-Packard TCP/IP Services for HP OpenVMS (UCX). If you want to use the TCP/IP protocol adapter for Oracle Net Services, then you should have version 5.5 ECO 1 or higher of TCP/IP Services for HP OpenVMS installed. TCP/IP protocol stacks from other vendors may work with Oracle software, but customers use these products at their own risk. Any TCP/IP problems that cannot be reproduced using TCP/IP Services for HP OpenVMS will be referred to the TCP/IP vendor. Vendor-provided protocol services are usually upward-compatible, so that existing applications will continue to work without modification. Therefore, later releases of TCP/IP are upward-compatible with Oracle Net Services, if the vendor-specified application programming interface (API) does not change with new releases.
Oracle Database Server	Oracle Database Enterprise Edition server Release 1 (10.1.0.3.0) Oracle Database server can reside on any supported platform.
Oracle Net Services	On gateway computer: Oracle Net Services Server Release 10.1.0.3.0 Oracle Adapter for Named Pipes or TCP/IP The following are required on Oracle Database server computer: Oracle Net Services Client Release 10.1.0.3.0 Oracle Adapter for Named Pipes or TCP/IP Oracle Net Services products are included on the distribution DVD . Oracle Net Services or Oracle Net Services Client and the Oracle Adapter must be installed on the computer where Oracle Database server is installed. Oracle Net Services Server and the Oracle Adapter must be installed on the computer where the gateway is installed.

C.1.3 Tested Gateway Configurations

The following gateway configurations have been 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.

Format	Database
Rdb	tg4rdb Release 7.1
RMS	tg4rms Release 7.3-2

C.1.4 Gateway Installation Worksheets

Select the worksheet in one of the following tables that is appropriate for the system. Use the values that you enter as a reference during the configuration process:

Section C.1.4.1, "Rdb Gateway Worksheet"
Section C.1.4.2, "RMS Gateway Worksheet"

C.1.4.1 Rdb Gateway Worksheet

Use Table C-3 to collate system information for an Rdb gateway configuration.

Table C-3 Rdb Gateway Installation Worksheet

Description	Value
Oracle Database server computer name
Oracle Database server platform (operating system and its version number)
Oracle home of Oracle Database (full path name)
Gateway computer name
Gateway computer platform (operating system and its version number)
Oracle home of the gateway (full path name)
Location of Rdb database to which the gateway will connect

C.1.4.2 RMS Gateway Worksheet

Use Table C-4 to record the system values for an RMS gateway configuration.

Table C-4 RMS Gateway Installation Worksheet

Description	Value
Oracle Database server computer name
Oracle Database server platform (operating system and its version number)
Oracle home of Oracle Database (full path name)
Gateway computer name
Gateway computer platform (operating system and its version number)
Oracle home of the gateway (full path name)

C.2 Installing Oracle Transparent Gateway

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

Section C.2.2.1, "Installation Prompts for Rdb Gateway"
Section C.2.2.2, "Completing Rdb Gateway Installation"

C.2.1 Mounting Oracle Transparent Gateway from the DVD Drive

Install the gateway software from the installation media as follows:

Start Oracle Universal Installer.

See Also:
Chapter 3, "Installation Tasks" for information about starting Oracle Universal Installer
Install the gateway by responding to installation prompts as described in the following section.

C.2.2 Installation Prompts for Oracle Transparent Gateway

Select the installation prompt section that corresponds to the gateway that you want to install.

Section C.2.2.1, "Installation Prompts for Rdb Gateway"
Section C.2.2.2, "Completing Rdb Gateway Installation"

C.2.2.1 Installation Prompts for Rdb Gateway

In the Response screen, enter the complete path for Rdb database in the Location of Rdb database.

Follow the instructions in the Response column for each entry in the Screen column. When you have completed the responses, follow the instructions in Section C.2.2.2, "Completing Rdb Gateway Installation".

C.2.2.2 Completing Rdb Gateway Installation

When the Summary screen is displayed, click Install.

Verify that the installation was successful after 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.

Note:

There are no installation prompts for the RMS gateway.

C.3 Removing Oracle Transparent Gateway

Remove the gateway as follows:

Start Oracle Universal Installer.
Click Deinstall Products on the Welcome screen or Installed Products... that is available on any Oracle Universal Installer screen. The Inventory screen is displayed and displays a list of installed products.
Select the gateway product in the Inventory screen and click Remove.

Files copied into the ORACLE_HOME directory during the gateway installation are automatically removed. You must manually remove all other related files.