5 Installing Oracle GoldenGate for Heterogeneous Databases

Learn how to install the Oracle GoldenGate Classic Architecture in Linux, UNIX, and Windows environments for heterogeneous databases.

Consult the chapter for your database to meet any prerequisites and learn about any installation considerations, then use these steps to install.

Topics:

5.1 Installing on all Platforms

  1. Copy the Oracle GoldenGate installation file to the system and directory where you want to install Oracle GoldenGate, and then extract it.

  2. From this directory, run the GGSCI program, ggsci.exe. For Linux and UNIX, open a command shell to run ggsci.sh.

    For Windows, it may be necessary to run ggsci.exe as an Administrator based on the systems User Account Control settings. Right-click the executable file then select Run as administrator.

    Note:

    The path cannot contain any spaces.

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

    CREATE SUBDIRS
    
  4. Exit GGSCI.

    EXIT
    

5.2 Specifying a Custom Manager Name for Windows

If you plan to install the Manager process as a Windows service and if either of the following is true, then you must specify a custom name for the Manager service:

  • You are installing the Manager as a Windows service and want to use a service name other then the default, which is GGSMGR.

  • You want to have multiple Manager processes running as Windows services on this system. Each Manager service on a system must have a unique name.

Specify a custom Manager service name:

  1. From the Oracle GoldenGate installation directory, run ggsci.exe from the Oracle GoldenGate directory.

  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 unique, 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 because it is used during installation of the Windows service and during data processing.

5.3 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 startup.

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

To install Manager as a Windows service:

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

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

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

    install option [...]
    

    Where option is one of the following:

    Table 5-1 INSTALL Utility 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 the GGSMGR default. The 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 in 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 in the Control Panel. The default is AUTOSTART.

    USER name

    Specifies a domain user account that executes Manager. For the 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. 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 returns a prompt.