3
Installing the Gateway

This chapter explains how to install the gateway software from the distribution CD-ROM. This chapter includes the following sections:

Before You Begin

Confirm that you have met all of the hardware and software requirements described in Chapter 1. You should also determine the configuration of the gateway components on the system, identify the machines on which the Oracle database server, the gateway, and the Sybase database reside, and verify the administration roles. Refer to the following sections:

Determine the Configuration of the Gateway Components

Figure 3-1, "Gateway Component Configuration", is a system diagram that gives an example of one possible system configuration. To sketch your own system, first draw a box. This represents a single system. Next, for each component you wish to install on the system, draw a box inside the box representing your system. Label these boxes with their respective component names. Follow the same procedure to represent a second system.

Draw a line with an arrow on both ends between the two systems to represent communication between them. Draw a box or boxes to represent client applications, and draw a line between them and the Oracle database server to represent communications between the client applications and the Oracle database server. Label the machines on which the Oracle database server, the gateway, and the non-Oracle database reside.

Identify the machines on which Sybase and the Oracle database server reside and where the gateway will be installed. Write this information on the Installation Worksheet. After you determine the configuration and identify the machines, verify that the machines and the software meet the hardware and software requirements described in Chapter 1. The supported versions of Windows NT, Sybase database and communication software, and the Oracle database server must all be installed.

Important:
Verify that you have Oracle database administration access and privileges on the machines on which the gateway and the Oracle database server are to be installed.

Figure 3-1 Gateway Component Configuration

Figure 3-1, "Gateway Component Configuration", is a system diagram that gives an example of one possible system configuration. In this diagram, the Oracle8i database server, which includes Heterogeneous Services and the database files, resides on a single machine. Client applications access the server over Net8. The gateway and its respective non-Oracle system and database reside on a second machine. The two systems communicate over Net8 so that the Oracle database server accesses the non-Oracle system through the gateway.

Installation Worksheet

Fill in the values on the following Installation Worksheet, so you can refer to it during the configuration process.

Table 3-1 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
ORACLE_HOME of the gateway (full path name)
Sybase client library location (full path name)
Sybase Open Client libraries location or Sybase Adaptive Server location on the gateway machine
Name of the Sybase Adaptive Server to which the gateway will connect
Name of the Sybase database to which the gateway will connect

Installing the Gateway from the CD-ROM

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

Log on to Windows NT as the Oracle Database Administrator (DBA) user.

If you are not currently a DBA user, contact the system administrator to create a database administrator login user ID.

See Also:
The Preinstallation chapter of the Oracle8i Installation Guide Release 2 (Oracle v8.1.6) for Windows NT.
Create the ORACLE_HOME directory.

Create the ORACLE_HOME directory where the gateway will be installed and write the value on the Installation Worksheet. The gateway installation should be under a new ORACLE_HOME. Do not install under an existing ORACLE_HOME that already has either the Oracle database server or one or more other Oracle products installed.

When you create the directory, use the version number as part of the path name to allow different versions of the gateway to be installed under one Oracle directory tree. For example:
```
c:\> mkdir oracle
c:\> mkdir oracle\gateway
c:\> mkdir oracle\gateway\8.1.6
```
Set up and start the Oracle Universal Installer.

Insert the CD-ROM into the CD-ROM drive, change directories to this drive, and start the Oracle Universal Installer. Enter the following commands:
```
c:\> d:
c:\> setup.exe
```
See Also:
Oracle 8i Installation Guide Release 2 (8.1.6) for Windows NT for general information about installing Oracle products and using the Oracle Universal Installer.

Run the Oracle Universal Installer and install the gateway.

The Oracle Universal Installer screens and the sequence in which they appear depend on the platform. Default values are selected for you and should be used unless you have reason to change them. Refer to Table 3-2, " Installation Prompts and Responses", as a guide to the installation. Follow the instructions in the Response column for each entry in the Screen column.

Table 3-2 Installation Prompts and Responses

Screen	Response
Full path of the products.jar file which contains the product or products you want to install.	The Oracle Universal Installer extracts and displays this value from its configuration file. Do not change the text in the Source field.
ORACLE_HOME name and its full path	Enter the full directory path to the ORACLE_HOME. You can choose from existing ORACLE_HOME names or create a new ORACLE_HOME name.
Installation Types	Custom - If you selected this installation type, then you can optionally install the Oracle Universal Installer on your machine in addition to the Sybase gateway. Also, you can select the languages in which the Sybase gateway runs. Typical - If you selected this installation type, both the Sybase gateway and the Oracle Universal Installer are installed on your machine. The default language selected during install is English.
Full path to where Sybase is installed.	Enter the full path where Sybase is installed.
The name of the Sybase Server to which the gateway will connect.	Enter the name of the Sybase Server to which the gateway will connect.
The name of the Sybase database to which the gateway will connect.	Enter the name of the database to which the gateway will connect.
Net8 Configuration Assistant	Check the box "Perform typical configuration."

Verify whether the software was successfully installed.

You can verify that the installation was successful after the Oracle Universal Installer confirms that the installation has been completed. Check the contents of the installation log file located in the following file, where orainventory_location is the directory in which OraInventory is located:

orainventory_location\logs\installActions.log

De-installing the Gateway

De-install the gateway as follows:

Start the Oracle Universal Installer: see Step 4, "Set up and start the Oracle Universal Installer."
Click the [De-install Products] button on the Welcome dialog box or the [Installed Products ...] button available on any Oracle Universal Installer window. The Inventory dialog box appears and displays a list of installed products.
Click to select the gateway product in the Inventory dialog box, and click the Remove button.

Only the files that were copied into the ORACLE_HOME directory during the gateway installation are removed when the gateway is de-installed. You must manually remove all other related files.

3 Installing the Gateway