Release 2 (9.2.0.1.0) for UNIX Systems: AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, and Sun Solaris
Part No. A96167-01
 Contents |
 Index |
|
Oracle9i Installation Guide
Release 2 (9.2.0.1.0) for UNIX Systems: AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, and Sun Solaris Part No. A96167-01 |
|
This chapter describes how to install the gateway software from the distribution CD-ROM. This chapter includes the following sections:
|
Note: For installation and configuration information on Enterprise Integration Gateways, refer to the Oracle Transparent Gateway for IBM DRDA Installation and User's Guide Release 9.2.0.1.0 for UNIX Systems, Oracle Procedural Gateway for APPC Installation and Configuration Guide Release 9.2.0.1.0 for UNIX Systems, and Oracle Procedural Gateway and Tools for IBM MQSeries Installation and User's Guide Release 9.2.0.1.0 for UNIX Systems. |
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.
The following sections describe system requirements for gateway configuration, and provide worksheets to use during the installation:
Table B-1 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.
Table B-1 Informix Gateway Requirements
| Hardware/ Software | Platform | Requirements |
|---|---|---|
| Operating System Version | HP | HP-UX version 11.0 |
|
|
Solaris (32-bit only) | Solaris 2.6 and Solaris 7 |
|
|
Solaris (32-bit and 64-bit) | Solaris 8 |
| Disk Space | HP | 200 MB |
|
|
Solaris | 200 MB |
| Oracle Database | HP | Oracle9i 9.0.1 or Oracle9i 9.2.0.1.0
Oracle Database Server can reside on any supported platform. |
|
|
Solaris | Oracle9i 9.0.1 or Oracle9i 9.2.0.1.0
Oracle Database Server can reside on any supported platform. |
| Oracle Networking | HP | On gateway computer:
The following are required on the Oracle database server computer:
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 computer where the Oracle Database Server is installed. Oracle Net Server and the Oracle Adapter must be installed on the computer where the gateway is installed. |
|
|
Solaris | On gateway computer:
The following are required on the Oracle Database Server computer:
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 computer where the Oracle Database Server is installed. Oracle Net Server and the Oracle Adapter must be installed on the computer where the gateway is installed. |
| Informix | HP | INFORMIX-OnLine, version 7.2, 7.3, 7.4, or 9.x 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. |
Table B-2 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.
Table B-2 Ingres Gateway Requirements
|
Hardware/ Software |
Platform | Requirements |
|---|---|---|
| Operating System Version | HP | HP-UX version 11.0 |
|
|
Solaris (32-bit only) | Solaris 2.6 and Solaris 7 |
|
|
Solaris (32-bit and 64-bit) | Solaris 8 |
| Disk Space | HP | 200 MB |
|
|
Solaris | 200 MB |
| Oracle Database | HP | Oracle9i 9.0.1 or Oracle9i 9.2.0.1.0
Oracle Database Server can reside on any supported platform. |
|
|
Solaris | Oracle9i 9.0.1 or Oracle9i 9.2.0.1.0
Oracle Database Server can reside on any supported platform. |
| Oracle Networking | HP | On gateway computer:
The following are required on the Oracle Database Server computer:
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 computer where the Oracle Database Server is installed. Oracle Net Server and the Oracle Adapter must be installed on the computer where the gateway is installed. |
|
|
Solaris | On gateway computer:
The following are required on the Oracle Database Server computer:
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 computer where the Oracle Database Server is installed. Oracle Net Server and the Oracle Adapter must be installed on the computer where the gateway is installed. |
| Ingres | HP | Ingres II version 2.0. |
|
|
Solaris | Ingres II version 2.0. |
Table B-3 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.
Table B-3 Sybase Gateway Requirements
|
Hardware/ Software |
Platform | Requirements |
|---|---|---|
| Operating System Version | AIX | 4.3.3 and 5.1 |
|
|
HP | HP-UX version 11.0 |
|
|
Solaris (32-bit only) | Solaris 2.6 and Solaris 7 |
|
|
Solaris (32-bit and 64-bit) | Solaris 8 |
|
|
Tru64 | Tru64 5.1 and 5.1A |
| Disk Space | AIX | 200 MB |
|
|
HP | 200 MB |
|
|
Solaris | 200 MB |
|
|
Tru64 | 200 MB |
| Oracle Database | AIX | Oracle9i 9.0.1 (AIX 4.3.3 only) or Oracle9i 9.2.0.1.0
Oracle Database Server can reside on any supported platform. |
|
|
HP | Oracle9i 9.0.1 or Oracle9i 9.2.0.1.0
Oracle Database Server can reside on any supported platform. |
|
|
Solaris | Oracle9i 9.0.1 or Oracle9i 9.2.0.1.0
Oracle Database Server can reside on any supported platform. |
|
|
Tru64 | Oracle9i 9.0.1 or Oracle9i 9.2.0.1.0
Oracle Database Server can reside on any supported platform. |
| Oracle Networking | AIX | The following are required on the gateway computer:
Oracle Net Server and the Oracle Adapter must be installed on the computer where the gateway is installed. The following are required on the Oracle Database Server computer:
Oracle Net or Oracle Net Client and the Oracle Adapter must be installed on the computer 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 computer:
Oracle Net Server and the Oracle Adapter must be installed on the computer where the gateway is installed. The following are required on the Oracle Database Server computer:
Oracle Net or Oracle Net Client and the Oracle Adapter must be installed on the computer 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 computer:
Oracle Net Server and the Oracle Adapter must be installed on the computer where the gateway is installed. The following are required on the Oracle Database Server computer:
Oracle Net or Oracle Net Client and the Oracle Adapter must be installed on the computer 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 computer:
Oracle Net Server and the Oracle Adapter must be installed on the computer where the gateway is installed. The following are required on the Oracle Database Server computer:
Oracle Net or Oracle Net Client and the Oracle Adapter must be installed on the computer 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, 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 Library certified for your Sybase Server is required. |
|
|
HP | Sybase Server or Client, version 11.9.2, 12.0, or 12.5. If Sybase Server is not on the same computer 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, 12.0, or 12.5. If Sybase Server is not on the same computer 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, 12.0, or 12.5. If Sybase Server is not on the same computer as the gateway, then the version of Sybase Open Library certified for your Sybase Server is required. |
Table B-4 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.
Table B-4 Teradata Gateway Hardware Requirements
| Hardware | Platform | Requirements |
|---|---|---|
| Operating System Version | HP | HP-UX version 11.0 |
|
|
Solaris (32-bit only) | Solaris 2.6 and Solaris 7 |
|
|
Solaris (32-bit and 64-bit) | Solaris 8 |
| Disk Space | HP | 200 MB |
|
|
Solaris | 200 MB |
| Oracle Database Server | HP | Oracle9i Enterprise Edition Server 9.2.0.1.0.
Oracle database server can reside on any supported platform. |
|
|
Solaris | Oracle9i Enterprise Edition Server 9.2.0.1.0.
Oracle database server can reside on any supported platform. |
| Oracle Networking | HP | The following are required on the gateway computer:
Oracle Net Server and the Oracle Adapter must be installed on the computer where the gateway is installed. The following are required on the Oracle database server computer:
Oracle Net or Oracle Net Client and the Oracle Adapter must be installed on the computer 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 computer:
Oracle Net Server and the Oracle Adapter must be installed on the computer where the gateway is installed. The following are required on the Oracle database server computer:
Oracle Net or Oracle Net Client and the Oracle Adapter must be installed on the computer 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. |
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.
Table B-5 Tested Gateway Configurations
| Database | Gateway and Operating System |
|---|---|
| Informix version 7.2 | tg4ifmx version 9.2.0.1.0 running on HP-UX version 11.0
tg4ifmx version 9.2.0.1.0 running on Sun Solaris version 2.6 (5.6), 7 (5.7) or 8 (5.8). |
| Informix version 7.3 | tg4ifmx version 9.2.0.1.0 running on HP-UX version 11.0
tg4ifmx version 9.2.0.1.0 running on Solaris version 2.6 (5.6), 7 (5.7) or 8 (5.8). |
| Informix version 7.4 | tg4ifmx version 9.2.0.1.0 running on HP-UX version 11.0
tg4ifmx version 9.2.0.1.0 running on Solaris version 2.6 (5.6), 7 (5.7) or 8 (5.8). |
| Informix version 9.x | tg4ifmx version 9.2.0.1.0 running on HP-UX version 11.0
tg4ifmx version 9.2.0.1.0 running on Solaris version 2.6 (5.6), 7 (5.7) or 8 (5.8). |
| Ingres II version 2.0 | tg4ingr version 9.2.0.1.0 running on HP-UX version 11.0
tg4ingr version 9.2.0.1.0 running on Solaris version 2.6 (5.6), 7 (5.7) or 8 (5.8). |
| Sybase version 11.9.2 | tg4sybs version 9.2.0.1.0 running on AIX version 4.3.3 or 5.1
tg4sybs version 9.2.0.1.0 running on HP-UX version 11.0 tg4sybs version 9.2.0.1.0 running on Solaris version 2.6 (5.6), 7 (5.7) or 8 (5.8). tg4sybs version 9.2.0.1.0 running on Tru64 version 5.1 |
| Sybase version 12.0 | tg4sybs version 9.2.0.1.0 running on AIX version 4.3.3 or 5.1
tg4sybs version 9.2.0.1.0 running on HP-UX version 11.0 tg4sybs version 9.2.0.1.0 running on Solaris version 2.6 (5.6), 7 (5.7) or 8 (5.8). tg4sybs version 9.2.0.1.0 running on Tru64 version 5.1 |
| Sybase version 12.5 | tg4sybs version 9.2.0.1.0 running on AIX version 4.3.3 or 5.1
tg4sybs version 9.2.0.1.0 running on HP-UX version 11.0 tg4sybs version 9.2.0.1.0 running on Solaris version 2.6 (5.6), 7 (5.7) or 8 (5.8). tg4sybs version 9.2.0.1.0 running on Tru64 version 5.1 |
| Teradata V2R3.03.00.02 | tg4tera version 9.2.0.1.0 running on HP-UX version 11.0 through NCR's ODBC Driver for Teradata V02.04.00.00
tg4tera version 9.2.0.1.0 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 |
| Teradata V2R04.03.00.15 | tg4tera version 9.2.0.1.0 running on HP-UX version 11.0 through NCR's ODBC Driver for Teradata V02.04.00.00
tg4tera version 9.2.0.1.0 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 |
|
See Also: http://www.oracle.com/gateways
Oracle Corporation continually updates supported gateway configurations. For the latest supported configuration information, either contact Oracle Support Services or visit the following Web site: |
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:
Enter your system values in the following Table B-6 to prepare for an Informix gateway configuration.
Table B-6 Informix Installation Worksheet
| Description | Value |
|---|---|
| Oracle database server computer name |
|
| Oracle database server platform (OS and its version number) |
|
$ORACLE_HOME of Oracle database server (full path name)
|
|
| Gateway computer name |
|
| Gateway computer 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 |
|
Enter your system values in the following Table B-7 to prepare for an Ingres gateway configuration.
Table B-7 Ingres Installation Worksheet
| Description | Value |
|---|---|
| Oracle database server computer name |
|
| Oracle database server platform (OS and its version number) |
|
$ORACLE_HOME of Oracle database server (full path name)
|
|
| Gateway computer name |
|
| Gateway computer 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 |
|
Enter your system values in the following Table B–8 to prepare for a Sybase gateway configuration.
Table B-8 Sybase Installation Worksheet
| Description | Value |
|---|---|
| Oracle database server computer name |
|
| Oracle database server platform (OS and its version number) |
|
$ORACLE_HOME of Oracle database server (full path name)
|
|
| Gateway computer name |
|
| Gateway computer 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 |
|
Enter your system values in the following Table B-9 to prepare for a Teradata gateway configuration.
Table B-9 Teradata Installation Worksheet
| Description | Value |
|---|---|
| Oracle database server computer name |
|
| Oracle database server platform (OS and its version number) |
|
$ORACLE_HOME of Oracle database server (full path name)
|
|
| Gateway computer name |
|
| Gateway computer 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. |
|
Use the following procedures and tables to install Oracle Transparent Gateway.
Install the gateway software from the database CD-ROM as follows:
Start the Oracle Universal Installer.
|
Note: 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, see Oracle9i Database Custom Installation . |
Select the Transparent Gateway option from the Oracle9i database Custom Install type.
From the Transparent Gateway List, select the gateway product to be installed.
Use Table B-10, "Installation Prompts and Responses for Informix" as a guide during your gateway installation. Follow the instructions in the Response column for each entry in the Screen column. When you have completed the responses, follow the instructions in the "Completing Informix Gateway Installation" section.
Table B-10 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. |
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.
Use Table B-11, "Installation Prompts and Responses for Ingres" as a guide during the installation. Follow the instructions in the Response column for each entry in the Screen column. When you have completed the responses, follow the instructions in the "Completing Ingres Gateway Installation" section.
Table B-11 Installation Prompts and Responses for Ingres
| Screen | Response |
|---|---|
| Ingres II installation: ANSI/ISO entry SQL-92 database standard. | Indicate if your Ingres database is compliant with the ANSI/ISO-92 Entry SQL database standard.
Click the Yes radio button if your Ingres database complies with this standard. Click the No radio button if your Ingres database does not comply with this standard. When you have selected the option that describes your Ingres installation, click the Next button |
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.
Use Table B-12, "Installation Prompts and Responses for Sybase" as a guide during the installation. Follow the instructions in the Response column for each entry in the Screen column. When you have completed the responses, follow the instructions in the "Completing Sybase Gateway Installation" section.
Table B-12 Installation Prompts and Responses for Sybase
| Screen | Responses |
|---|---|
| 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. |
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.
Use Table B-13, "Installation Prompts and Responses for Teradata" as a guide during the installation. Follow the instructions in the Response column for each entry in the Screen column. When you have completed the responses, follow the instructions in the "Completing Teradata Gateway Installation" section.
Table B-13 Installation Prompts and Responses for Teradata
| Screen | Response |
|---|---|
| ODBC Data Source name that will be used by the gateway | Enter the Open Database Connectivity (ODBC) data source name (DSN) for the Teradata database to which the gateway will connect.
The DSN is defined in the |
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.
Remove the gateway as follows:
Start the Oracle Universal Installer.
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.
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.
|
 Copyright © 1996, 2002 Oracle Corporation All rights reserved |
|