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:
Section 2.3, "Understanding and Obtaining the Oracle GoldenGate Distribution"
Section 2.5, "Installing Oracle GoldenGate on Linux and UNIX"
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:
To upgrade Oracle GoldenGate from one version to another, follow the upgrade instructions in Upgrading Oracle GoldenGate for Windows and UNIX.
To install Oracle GoldenGate, the following steps are required:
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
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.
Install and run DB2 for LUW on the selected remote system so that the Replicat process can use the supplied DB2 Connect driver.
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
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 commandsFollow the instructions in Section 2.3, "Understanding and Obtaining the Oracle GoldenGate Distribution" 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:
Specify the DB2 target database name with the Replicat parameter TARGETDB
when you configure the Oracle GoldenGate processes.
For complete information about how to obtain Oracle Fusion Middleware software, see "Understanding and Obtaining Product Distributions" in Planning an Installation of Oracle Fusion Middleware.
To download the Oracle WebLogic Server and Coherence software for development or evaluation, see the following location on the Oracle Technology Network (OTN):
For more information about locating and downloading Oracle Fusion Middleware products, see the Oracle Fusion Middleware Download, Installation, and Configuration Readme Files on OTN.
To obtain Oracle GoldenGate follow these steps:
Go to Oracle Technology Network.
Find the Oracle GoldenGate 12c (12.2.0.1) release and download the ZIP file onto your system.
Follow these instructions to install Oracle GoldenGate in UNIX System Services on a z/OS system.
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
.
Extract the Oracle GoldenGate installation file to the system and directory where you want Oracle GoldenGate to be installed.
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
If the write mode is not set, issue the following command.
chmod +w *.dll
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
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
Run the command shell and change directories to the new Oracle GoldenGate directory.
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
From the Oracle GoldenGate directory, run the GGSCI program.
GGSCI
In GGSCI, issue the following command to create the Oracle GoldenGate working directories.
CREATE SUBDIRS
Issue the following command to exit GGSCI.
EXIT
Follow these steps to install Oracle GoldenGate for Oracle on a Linux or UNIX system.
Extract the Oracle GoldenGate installation file to the system and directory where you want Oracle GoldenGate to be installed.
Run the command shell.
Change directories to the new Oracle GoldenGate directory.
From the Oracle GoldenGate directory, run the GGSCI program.
GGSCI
In GGSCI, issue the following command to create the Oracle GoldenGate working directories.
CREATE SUBDIRS
Issue the following command to exit GGSCI.
EXIT
Follow these instructions to:
Install Oracle GoldenGate for Oracle on a Windows system.
Install Oracle GoldenGate DB2Remote on a Windows system to support remote delivery to a DB2 for z/OS target system. To install directly on a z/OS system, see Section 2.4, "Installing Oracle GoldenGate in USS on z/OS."
Log into one of the nodes in the cluster.
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.
Ensure that this cluster group is owned by the cluster node that you are logging into.
Install Oracle GoldenGate according to the following instructions.
Unzip the downloaded file(s) by using WinZip or an equivalent compression product.
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.
From the Oracle GoldenGate folder, run the GGSCI program.
In GGSCI, issue the following command to create the Oracle GoldenGate working directories.
CREATE SUBDIRS
Issue the following command to exit GGSCI.
EXIT
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:
From the directory that contains the Manager program, run GGSCI.
Issue the following command.
EDIT PARAMS ./GLOBALS
Note:
The ./ portion of this command must be used, because theGLOBALS
file must reside at the root of the Oracle GoldenGate installation file.In the file, add the following line, where name
is a one-word name for the Manager service.
MGRSERVNAME name
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.
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.
(Recommended) Log on as the system administrator.
Click Start then Run and then enter cmd
in the Run dialog box.
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:
Option | Description |
---|---|
|
Adds Oracle GoldenGate events to the Windows Event Manager. |
|
Adds Manager as a service with the name that is specified with the The service is installed to start at system boot time (see |
|
Sets the service that is created with |
|
Sets the service that is created with |
|
Specifies a domain user account that executes Manager. For By default, the Manager service is installed to use the Local System account. |
|
Specifies the password for the user that is specified with |
Footnote 1 A user account can be changed by selecting the Properties action from the Services applet of the Windows Control Panel.
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.