2 Installing Oracle GoldenGate

This chapter shows you how to install Oracle GoldenGate for DB2 z/OS databases. The installation procedure described here installs all of the components that are required to run and manage the processing (excluding any components required from other vendors, such as drivers or libraries). It also installs the Oracle GoldenGate utilities.

This chapter contains the following sections:

Note:

These instructions are for installing Oracle GoldenGate for the first time. Additionally, they are for downloading the base release of a new version of Oracle GoldenGate.

To download and install subsequent patches to the base release, go to the Patches and Updates tab of My Oracle Support at:

http://support.oracle.com

To upgrade Oracle GoldenGate from one version to another, follow the upgrade instructions at

http://www.oracle.com/technology/software/products/goldengate/index.html

2.2 Choosing an Installation System for DB2

To install Oracle GoldenGate, you have the following options:

  • To capture DB2 data, Oracle GoldenGate is installed directly on a z/OS source system. On the z/OS platform, Oracle GoldenGate runs natively on UNIX System Services (USS), also known as Open MVS (OMVS). Extract uses ODBC (Open Database Connectivity) to connect to the DB2 subsystem.

  • To apply data to a DB2 target, you can use either of the following configurations:

    • Install Oracle GoldenGate directly on the z/OS target system. Replicat will use ODBC (Open Database Connectivity) to connect to the DB2 subsystem. To use this configuration, go to Section 2.4, "Installing Oracle GoldenGate in USS on z/OS".

    • Install Oracle GoldenGate DB2 Remote on a remote Linux, UNIX, or Windows system for remote delivery to the DB2 target system. In this configuration, Replicat connects to the target DB2 database by using the ODBC API that is supplied in DB2 Connect . This configuration requires DB2 LUW to be installed on the remote system. Use the following instructions.

Note:

All of the Oracle GoldenGate functionality that is supported for DB2 for z/OS is supported by DB2Connect. In addition, ASCII character data is converted to EBCDIC automatically by DB2 Connect.

To use remote delivery to the z/OS system via DB2Connect

  1. For the intermediary system, select any Linux, UNIX, or Windows platform that Oracle GoldenGate supports for the DB2 for LUW database. This will be the system on which Oracle GoldenGate is installed.

  2. Install and run DB2 for LUW on the selected remote system so that the Replicat process can use the supplied DB2 Connect driver.

  3. Catalog the DB2 target node in the DB2 for LUW database on the remote system by using the following DB2 command:

    catalog tcpip node db2_node_name remote DNS_name
    
    server DB2_port-number
    
  4. Add the target DB2 database to the DB2 for LUW catalog on the intermediary system by using the following DB2 command:

    catalog db database_name as database_alias at node db_node_name 
    

    Note:

    Refer to the IBM DB2 LUW documentation for more information about these commands

  5. Follow the instructions in Section 2.3, "Downloading Oracle GoldenGate" to download the appropriate build for the selected remote Windows, Linux, or UNIX platform. Select the build that is labeled for DB2Remote. Then, follow the appropriate instructions to install Oracle GoldenGate on the intermediary system:

  6. Specify the DB2 target database name with the Replicat parameter TARGETDB when you configure the Oracle GoldenGate processes.

2.3 Downloading Oracle GoldenGate

Download the appropriate Oracle GoldenGate build to each system that will be part of the Oracle GoldenGate configuration.

  1. Navigate to http://edelivery.oracle.com.

    The Oracle Software Delivery Cloud page appears.

  2. Click Sign-in/Register.

    Note:

    If you are not already logged in, the Single Sign-on page appears. Enter your Oracle ID and password and click Sign In.

    The Terms & Restrictions page appears

  3. Accept the Oracle Software Delivery Cloud Trial License Agreement and the Export Restrictions and click Continue.

    The Media Pack Search page appears.

  4. On the Media Pack Search page, do the following:

    1. Click the Select Product Pack drop-down control and, from the list, select Oracle Fusion Middleware.

    2. Click the Platform drop-down control and, from the list, select the platform on which you are installing Oracle GoldenGate.

    3. Click Go.

    The Results list expands to show all available media packs that include your search criteria.

  5. In the Results list, select the media pack you want to download and click Continue.

    The media pack's download page appears. Additional download selections may appear, such as separate builds for different databases or versions of a database. Note that this page contains the part number and size of each downloadable file.

    Note:

    To install Oracle GoldenGate to connect to a DB2 target using DB2 Connect from a Windows or UNIX system, select the build that is labeled as DB2Remote; or to download Oracle GoldenGate to run on the DB2 z/OS target system, select the appropriate build for that database and platform. (See Section 2.2, "Choosing an Installation System for DB2".)

  6. To ensure that you download the files successfully, first review the Media Pack Readme for download instructions and product information by clicking Readme. The Readme contains release notes for any new features, new requirements, or bug fixes that affect your current configuration and other known issues.

  7. To begin the download process, click Download next to the name of the Oracle GoldenGate build that you want to download.

    A File Download dialog box appears.

  8. Select either Open with or Save File:

    To... Select...

    Install media pack immediately

    Open, select the desired file extraction utility, and extract the files to a designated location on your file system.

    Save the file for later installation

    Save and point to a designated location on your file system.


Note:

Before installing the software, review the release notes for any new features, new requirements, or bug fixes that affect your current configuration. Review the readme file for known issues.

2.4 Installing Oracle GoldenGate in USS on z/OS

Follow these instructions to install Oracle GoldenGate in UNIX System Services on a z/OS system.

  1. Log on as a superuser or as a user who has z/OS authorization to add the "a" extended attribute. If you cannot log on as this kind of user, then someone with the proper authority will need to set the "a" attribute later. It is required for the Extract process, which uses a privileged API by the name of IFI IFCID 306 to perform certain work, and then it reverts to normal application privileges for other work. The work that requires elevated privileges is:

    • Call the API in Supervisor State with Storage Key 0.

    • Allocate a return area in Extended Common Storage Area (ECSA) memory subpool 241 (not fetch protected, pageable) with Storage Key 7. The size of the return area will be a minimum of the largest DB2 log record that is returned, plus the additional area that is defined in DB2 macro DSNDQW04.

  2. Extract the Oracle GoldenGate installation file to the system and directory where you want Oracle GoldenGate to be installed.

  3. In the UNIX shell, verify that the DLL files have the write mode set.

    ls -l *.dll
    
    -rwxrwx---  a-s-  1 BSTPIER  IPGROUP  6127616 Apr 25 14:56 lib.dll
    
  4. If the write mode is not set, issue the following command.

    chmod +w *.dll
    
  5. In the UNIX shell, check for the "a" authorization for Extract and the DLL files by issuing the following command.

    ls -E extract *.dll
    

    In the output, look for the "a" attribute, indicating the authorization in Authorized Program Facility (APF) as shown in the following example.

    -rwxrwx---  a-s-  1 BSTPIER  IPGROUP  6127616 Apr 25 14:56 extract
    
  6. If the "a" attribute is not set for both Extract and its DLL files (it may be built into one but not the other, depending on the build configuration), issue the following commands to add the authorization for Extract and the DLL files.

    extattr +a extract
    
    extattr +a *.dll
    
  7. Run the command shell and change directories to the new Oracle GoldenGate directory.

  8. Set the LIBPATH environment variable to include the path to the Oracle GoldenGate installation directory.

    export LIBPATH=".:$(LIBPATH)" 
    

    The "." indicates the current directory. This change must be performed before starting any Oracle GoldenGate processes and can be made in one of the following ways:

    • system-wide

    • for a specific user at login time

    • manually each time that Oracle GoldenGate is executed

  9. From the Oracle GoldenGate directory, run the GGSCI program.

    GGSCI
    
  10. In GGSCI, issue the following command to create the Oracle GoldenGate working directories.

    CREATE SUBDIRS
    
  11. Issue the following command to exit GGSCI.

    EXIT
    

2.5 Installing Oracle GoldenGate on Linux and UNIX

Follow these steps to install Oracle GoldenGate for Oracle on a Linux or UNIX system.

  1. Extract the Oracle GoldenGate installation file to the system and directory where you want Oracle GoldenGate to be installed.

  2. Run the command shell.

  3. Change directories to the new Oracle GoldenGate directory.

  4. From the Oracle GoldenGate directory, run the GGSCI program.

    GGSCI
    
  5. In GGSCI, issue the following command to create the Oracle GoldenGate working directories.

    CREATE SUBDIRS
    
  6. Issue the following command to exit GGSCI.

    EXIT
    

2.6 Installing Oracle GoldenGate on Windows

Follow these instructions to:

2.6.1 Installing Oracle GoldenGate into a Windows Cluster

  1. Log into one of the nodes in the cluster.

  2. Choose a drive for the Oracle GoldenGate installation location. This drive must be a resource within the same cluster group that contains the database instance.

  3. Ensure that this cluster group is owned by the cluster node that you are logging into.

  4. Install Oracle GoldenGate according to the following instructions.

2.6.2 Installing the Oracle GoldenGate Files

  1. Unzip the downloaded file(s) by using WinZip or an equivalent compression product.

  2. Move the files in binary mode to a folder on the drive where you want to install Oracle GoldenGate. Do not install Oracle GoldenGate into a folder that contains spaces in its name, even if the path is in quotes. For example:

    C:\"Oracle GoldenGate" is not valid.

    C:\Oracle_GoldenGate is valid.

  3. From the Oracle GoldenGate folder, run the GGSCI program.

  4. In GGSCI, issue the following command to create the Oracle GoldenGate working directories.

    CREATE SUBDIRS
    
  5. Issue the following command to exit GGSCI.

    EXIT
    

2.6.3 Specifying a Custom Manager Name

You must specify a custom name for the Manager process if either of the following is true:

  • You want to use a name for Manager other than the default of GGSMGR .

  • There will be multiple Manager processes running as Windows services on this system. Each Manager on a system must have a unique name. Before proceeding further, note the names of any local Manager services.

To specify a custom Manager name:

  1. From the directory that contains the Manager program, run GGSCI.

  2. Issue the following command.

    EDIT PARAMS ./GLOBALS
    

    Note:

    The ./ portion of this command must be used, because the GLOBALS file must reside at the root of the Oracle GoldenGate installation file.

  3. In the file, add the following line, where name is a one-word name for the Manager service.

    MGRSERVNAME name
    
  4. Save the file. The file is saved automatically with the name GLOBALS, but without a file extension. Do not move this file. It is used during installation of the Windows service and during data processing.

2.6.4 Installing Manager as a Windows Service

By default, Manager is not installed as a service and can be run by a local or domain account. However, when run this way, Manager will stop when the user logs out. When you install Manager as a service, you can operate it independently of user connections, and you can configure it to start manually or at system start-up.

Installing Manager as a service is required on a Windows Cluster, but optional otherwise.

  1. (Recommended) Log on as the system administrator.

  2. Click Start then Run and then enter cmd in the Run dialog box.

  3. From the directory that contains the Manager program that you are installing as a service, run the INSTALL utility with the following syntax:

    install option [...]
    

    Where option is one of the following:

    Table 2-1 INSTALL Options

    Option Description

    ADDEVENTS

    Adds Oracle GoldenGate events to the Windows Event Manager.

    ADDSERVICE

    Adds Manager as a service with the name that is specified with the MGRSERVNAME parameter in the GLOBALS file, if one exists, or by the default of GGSMGR. ADDSERVICE configures the service to run as the Local System account, the standard for most Windows applications because the service can be run independently of user logins and password changes. To run Manager as a specific account, use the USER and PASSWORD options.Foot 1 

    The service is installed to start at system boot time (see AUTOSTART). To start it after installation, either reboot the system or start the service manually from the Services applet of the Control Panel.

    AUTOSTART

    Sets the service that is created with ADDSERVICE to start at system boot time. This is the default unless MANUALSTART is used.

    MANUALSTART

    Sets the service that is created with ADDSERVICE to start manually through GGSCI, a script, or the Services applet of the Control Panel. The default is AUTOSTART.

    USER name

    Specifies a domain user account that executes Manager. For name, include the domain name, a backward slash, and the user name, for example HEADQT\GGSMGR.

    By default, the Manager service is installed to use the Local System account.

    PASSWORD password

    Specifies the password for the user that is specified with USER.


    Footnote 1 A user account can be changed by selecting the Properties action from the Services applet of the Windows Control Panel.

  4. (Windows Server 2008) If Windows User Account Control (UAC) is enabled, you are prompted to allow or deny the program access to the computer. Select Allow to enable the INSTALL utility to run.

    The INSTALL utility installs the Manager service with a local system account running with administrator privileges. No further UAC prompts will be encountered when running Manager if installed as a service.

Note:

If Manager is not installed as a service, Oracle GoldenGate users will receive a UAC prompt to confirm the elevation of privileges for Manager when it is started from the GGSCI command prompt. Running other Oracle GoldenGate programs also triggers a prompt.