3 Installing Oracle Database Gateway for VSAM

This chapter guides you through the installation procedure of Oracle Database Gateway for VSAM.

To install the gateway, follow these steps:

  1. Ensure that the system meets all of the hardware and software requirements specified in "System Requirements for Oracle Database Gateway for VSAM".

  2. Run the Oracle Universal Installer.

    See "Running the Oracle Universal Installer" for more information about running the Oracle Universal Installer.

    Oracle Universal Installer is a menu-driven utility that guides you through the installation of the gateway by prompting you with action items. The action items and the sequence in which they appear depend on your platform.

  3. Configure the gateway.

    Chapter 4, "Configuring Oracle Database Gateway for VSAM" provides information on how to configure the gateway.

Overview of Oracle Database Gateway for VSAM

Oracle Database Gateway for VSAM consists of the following components:

  • Oracle Studio for IMS, VSAM, and Adabas Gateways, a GUI-based tool that lets you configure the Oracle Connect for IMS, VSAM, and Adabas Gateways servers in your system. Oracle Studio for IMS, VSAM, and Adabas Gateways runs on Windows and Linux platforms.

  • Oracle Connect for IMS, VSAM, and Adabas Gateways, which is natively located on the data server to provide standard, service-oriented integration to VSAM data. Oracle Connect for IMS, VSAM, and Adabas Gateways runs on z/OS platforms.

  • Oracle Database Gateway, which provides the capabilities, SQL mappings, data type conversions, and interface to the remote non-Oracle system. The gateway interacts with Heterogeneous Services to provide the transparent connectivity between Oracle and non-Oracle systems.

    The gateway must be installed on a Windows or UNIX-based computer. This can be the same system as the Oracle database server or a second, standalone system.

System Requirements for Oracle Database Gateway for VSAM

This section provides information about the hardware and software requirements for the gateway. It contains the following sections:

Hardware Requirements for Oracle Database Gateway for VSAM

Table 3-1 lists the hardware requirements for Oracle Database Gateway for VSAM on Windows.

Table 3-1 Hardware Requirements for Oracle Database Gateway for VSAM

Requirement Value

Disk space for ORACLE_HOME

300 MB

Disk space for system drive (SYSTEM_DRIVE:\)

3.1 MB

Temporary disk space

125 MB

Physical memory

512 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 processed by the user

  • The number of cursors currently opened

  • The number of columns in the table being accessed

Oracle networking

Oracle Net and Oracle Protocol Support for Named Pipes or TCP/IP must be installed on the Oracle database computer and the gateway computer. The Oracle Net components are included on the gateway installation media.

Processor

550 MHz

Checking the Hardware Requirements

To ensure that the system meets these requirements:

  1. Determine the physical RAM size. For a computer using Windows 2000, for example, open System in the control panel and select the General tab. If the size of the physical RAM installed in the system is less than the required size, then you must install more memory before continuing.

  2. Determine the size of the configured swap space (also known as paging file size). For a computer using Windows 2000, for example, open System in the control panel, select the Advanced tab, and click Performance Options.

    If necessary, then see your operating system documentation for information about how to configure additional swap space.

  3. Determine the amount of free disk space on the system. For a computer using Windows 2000, for example, open My Computer, right-click the drive where the Oracle software is to be installed, and select Properties.

  4. Determine the amount of disk space available in the temp directory. This is equivalent to the total amount of free disk space, minus what will be needed for the Oracle software to be installed.

    If there is less than 125 MB of disk space available in the temp directory, then first delete all unnecessary files. If the temp disk space is still less than 125 MB, then set the TEMP or TMP environment variable to point to a different hard drive. For a computer using Windows 2000, for example, open the System control panel, select the Advanced tab, and click Environment Variables.

Software Requirements for Oracle Database Gateway for VSAM

Oracle Database Gateway for VSAM is supported on the following Microsoft Windows operating systems:

  • Windows 2000 with service pack 1 or higher. All editions, including Terminal Services and Windows 2000 MultiLanguage Edition (MLE), are supported.

  • Windows Server 2003 32-bit

  • Windows Server 2003 64bit (X64)

  • Windows XP Professional 32-bit

  • Windows XP Professional 64bit (X64)

  • Windows Vista 32-bit

  • Windows Vista 64-bit (X64)

  • Windows Server 2008 32-bit

  • Windows Server 2008 64-bit (X64)

Windows Multilingual User Interface Pack is supported on Windows XP Professional and Windows Server 2003.

Gateway Installation Configurations

You can install the gateway in either of the following configurations:

  • On the same computer as an existing Oracle database but in a different ORACLE_HOME directory.

  • On a system with no Oracle database.

  • On the same computer as the Oracle database and in the same ORACLE_HOME directory. Note that in this case, the Oracle database and the gateway must be at the same release level.

Gateway Installation Methods

You can choose different installation methods to install the gateway, as follows:

Interactive Installation Method

When you use the interactive method to install the gateway, Oracle Universal Installer displays a series of screens that enable you to specify all of the required information to install the gateway software.

Automated Installation Method Using Response Files

By creating a response file and specifying this file when you start Oracle Universal Installer, you can automate some or all of the gateway installation steps. These automated installation methods are useful if you need to perform multiple installations on similarly configured systems or if the system where you want to install the software does not have X Window system software installed.

When you use a response file, you can run Oracle Universal Installer in the following modes, depending on whether you specify all of the required information or not:

  • Silent Mode: Oracle Universal Installer runs in silent mode if you use a response file that specifies all required information. None of the Oracle Universal Installer screens are displayed.

  • Suppressed Mode: Oracle Universal Installer runs in suppressed mode if you do not specify all required information in the response file. Oracle Universal Installer displays only the screens that prompt for the information that you did not specify.

See Appendix B, "Using Response Files for Non-Interactive Installation" for more information about this method and about how to complete an installation using response files.

Gateway Installation Considerations

This section contains information that you should consider before installing this product. It contains the following sections:

Release Notes

Read the release notes for the product before installing it. The release notes are available on the Oracle Database 11g Release 2 (11.2) installation media. The latest version of the release notes is also available on the Oracle Technology Network (OTN) Web site:

http://www.oracle.com/technetwork/indexes/documentation/index.html

Hardware and Software Certification

The platform-specific hardware and software requirements included in this installation guide were current at the time this guide was published. However, because new platforms and operating system software versions might be certified after this guide is published, review the certification matrix on the My Oracle Support Web site for the most up-to-date list of certified hardware platforms and operating system versions. The My Oracle Support Web site is available at the following Web site:

https://support.oracle.com

Multiple ORACLE_HOME Directories

This product supports multiple ORACLE_HOME directories. This means that you can install this release or previous releases of the software more than once on the same system, in different ORACLE_HOME directories.

Installing the Software on a System with an Existing Oracle Installation

You must install this product in a new ORACLE_HOME directory. You cannot install products from one release of the gateway into an ORACLE_HOME directory of a different release.

For example, you cannot install release 10.1 software into an existing Oracle9i ORACLE_HOME directory. If you attempt to install this release in an ORACLE_HOME directory that contains software from an earlier Oracle release, then the installation will fail.

You can install this release more than once on the same system if each installation is installed in a separate ORACLE_HOME directory.

Upgrades

Upgrades are not supported for Oracle Database Gateways.

Accessing the Installation Software

You can access and install the gateway by using the following methods:

Downloading Oracle Software from the Oracle Technology Network Web Site

You can download the installation files from the Oracle Technology Network (OTN) and extract them to your hard disk.

To download the installation files:

  1. Use any browser to access the OTN software download page:

    http://www.oracle.com/technetwork/index.html

  2. Navigate to each of the download pages for the product that you want to install.

  3. On each download page, identify the required disk space by adding the file sizes for each required file.

    The file sizes are listed next to the file names.

  4. Select a file system with enough free space to store and expand the files.

    In most cases, the available disk space must be at least twice the size of each compressed file.

  5. On the file system that you just selected, create a parent directory for each product that you plan to install, for example dg_1, to hold the installation directories.

  6. Download all the installation files to the directories that you just created.

  7. Verify that the files that you downloaded are the same size as the corresponding files on OTN.

  8. Extract the files in each directory that you just created.

  9. After you have extracted the required installation files, go to Running the Oracle Universal Installer section.

Copying the Gateway Software to a Hard Disk

Before installing the gateway, you might want to copy the software to the hard disk. This enables the installation process to run faster. Before copying the installation media content to the hard disk, you must mount the installation media.

To copy the contents of the installation media to a hard disk:

  1. Create a directory on your hard drive. For example:

    d:\install\Disk1

  2. Copy the contents of the installation media to the directory that you just created.

  3. After you have copied all the required installation files, go to Running the Oracle Universal Installer.

Running the Oracle Universal Installer

In most cases, you use the graphical user interface (GUI) provided by Oracle Universal Installer to install the gateway. However, you can also use Oracle Universal Installer to complete noninteractive installations, without using the GUI.

See Also:

Appendix B, "Using Response Files for Non-Interactive Installation" for information about noninteractive installations and other advanced installation topics.

Start the Installer and install the software, as follows:

  1. If you are installing the software from disc, then mount the disc if it is not already mounted.

    If you are installing from a hard disk, then double-click setup.exe located in the directory you created for the downloaded or copied installation files.

  2. When installing from the installation media, the Autorun screen automatically appears. If the Autorun screen does not appear, then:

    From the Start menu, select Run.

    Enter the following: DRIVE_LETTER:\autorun\autorun.exe

    In the Autorun screen, select Install/Deinstall Products.

  3. Follow the instruction displayed in the Installer window.

    Table 3-2 describes the installation procedure for Oracle Database Gateway for VSAM.

    Table 3-2 The Oracle Universal Installer: Steps for Installing the Gateway

    Screen Response

    Oracle Universal Installer: Welcome

    Click Next.

    Oracle Universal Installer: Specify Home Details

    The Path field in the Specify Home Details screen is where you specify the destination for your installation. You need not edit the path specification in the Path field. The default setting for this field points to ORACLE_HOME. After you set the fields in the Specify Home Details screen as necessary, click Next to continue. After loading the necessary information from the installation, the Oracle Universal Installer displays the Available Products screen.

    Oracle Universal Installer: Available Product Components

    Select Oracle Database Gateway for VSAM 12.1.

    Click Next.

    Oracle Database Gateway for VSAM

    Oracle Connect for IMS, VSAM, and Adabas Gateways Host Name: Specify the host name of the system running Oracle Connect for IMS, VSAM, and Adabas Gateways on z/OS.

    Oracle Connect for IMS, VSAM, and Adabas Gateways Port number: Specify the port number Oracle Connect for IMS, VSAM, and Adabas Gateways listens on.Click Next to continue.

    Oracle Universal Installer: Summary

    The Installation Summary screen enables you to review a tree list of options and components for this installation.

    Click Install to display the Installation Status screen.

    Oracle Net Configuration Assistant: Welcome

    Click Cancel.

    Oracle Net Configuration Assistant:

    Click Yes.

    Oracle Universal Installer: Configuration Tools

    When Oracle Universal Installer confirms that the installation is complete, verify that the installation procedure was successful. To do this, read the contents of the installation log file, which is located in the following directory:

    [designated_inventory_location]\OraInventory\logs

    The default file name is InstallActionsYYYY-MM-DD_HH-mm-SS-AM/PM.log, where:

    YYYY is year

    MM is month

    DD is day

    HH is hour

    mm is minute

    SS is seconds

    AM/PM is daytime or evening

    Each of these variables in the log file name represents the date and time the product was installed.

    When you finish configuring, click Exit.

    Exit

    Click Exit.

    If you need additional information, click Help.

    If you encounter errors while installing or linking the software, then see Appendix C, "Oracle Database Gateway Troubleshooting" for information about troubleshooting.