2 Installing Oracle GoldenGate for HP NonStop

2.1.1 Downloading Oracle GoldenGate for HP NonStop

First go to the Oracle support site to look for the latest download of the release you want.

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

2. Log in with your Oracle ID and password.

3. Select the Patches and Upgrades tab.

4. On the Search tab, click Product or Family.

5. In the Product Field, type Oracle GoldenGate.

6. From the Release drop-down list, select the release version that you want o download.

7. Make sure Platform is displayed as the default in the next field, and then select the platform from the drop-down list.

8. Leave the last field blank.

9. Click Search.

10. In the Advanced Patch Search Results list, select the available builds that satisfy the criteria that you supplied.

11. In the file Download dialog box, click the zip file to begin the download.

If patches are not available on the support site, go to the Oracle delivery site for the release download.

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

2. Sign in with your Oracle ID and password.

3. On the Terms and Restrictions page:

   • Accept the Trial License Agreement (even if you have a permanent license).

   • Accept the Export Restrictions.

   • Click Continue.

4. On the Media Pack Search page:

   • Select the Oracle Fusion Middleware Product Pack.

   • Select the platform on which you will be installing the software.

   • Click Go.

5. In the Results List:

   • Select the Oracle GoldenGate Media Pack that you want.

   • Click Continue.

6. On the Download page:

   • View the Readme file.

   • Click Download for each component that you want. Follow the automatic download process to transfer the mediapack.zip file to your system.

2.1.2 Installing Oracle GoldenGate for HP NonStop

Follow these steps use the downloaded file to install Oracle GoldenGate for HP NonStop.

1. Save the downloaded file to a directory on your workstation and unzip it to a temporary folder.

2. Upload the GGSUNPAK and GGSOS_versionPK files in binary mode to the volume and subvolume on your HP NonStop Server where you want to install and run Oracle GoldenGate. We recommend that you preface the subvolume name with GGS and include the release of Oracle GoldenGate. For example, if you are installing Oracle GoldenGate release 12.1.2, then we recommend you install on $PROD.GGS1212.

   Note:

   If you are using Oracle GoldenGate against a TMF-enabled (or audited) database, then Oracle GoldenGate must be installed on a volume that is TMF-protected because the internal Oracle GoldenGate file must be audited.

3. Alter GGSUNPAK to be an Edit file.

   TACL> FUP ALTER GGSUNPAK, CODE 101 
   

4. Run GGSUNPAK and confirm the installation location. If the correct location is not displayed, you are prompted for it, as shown here.

   TACL 2> run ggsunpak
   Installing Oracle GoldenGate at $DATA4.CPSTEMP 
   Is this correct?(Y/N) N
   Enter the volume and subvolume to install Oracle GoldenGate: $VOL.GGS1111
   Installing Oracle GoldenGate at $VOL.GGS1111
   Is this correct?(Y/N) Y
   

   Text similar to the following will display:

   UNPAK - File decompression program - T1255G06 . . .
   Archive version: 1
   File Mode RESTORE Program - T9074G07 . . .
   (C)2000 Compaq (C)2005 Hewlett Packard Development Company, L.P.
   Drives: (\GGS2.$X6JZ)
   System: \PROD Operating System: G06  Tape Version: 3
   Backup options:  NO AUDITED, BLOCKSIZE 8, NO IGNORE, NO OPEN, PARTONLY OFF, INDEXES IMPLICIT
   Restore time: 20Apr2010 13:36  Backup time: 20Apr2010 13:33 Page: 1
   Tape: 1       Code             EOF      Last modify   Owner RWEP   Type   Rec Bl
   Summary Information
   Disk related warnings = 2  Disk related errors = 0
   Files restored = 91  Files not restored = 0
   * Extractor-TDM and Replicator-TDM Installation *
   *************************************************
   *   The Installation routine has changed,        *
   *   please pay attention to the prompting        *
   *************************************************
   

5. (The prompts in this step appear only on a G06.16 operating system and are omitted on D30 or D40 systems.) For G06, you are asked if you need TNS versions of Extract and Replicat. Oracle GoldenGate recommends using the Native versions of these components, but if you have TNS mode user exits, enter Y at the prompts to install the TNS versions.

   Since you are installing G06.16, we are installing Native mode objects.
   Do you use TNS mode User Exits in Extract (Y/N)? N
   Do you use TNS mode User Exits in Replicat (Y/N)? N
   $DATA11.GGS1111.TEMP1 purged.
   

   Note:

   For the purposes of this documentation, it is assumed that Native mode objects will be installed.

6. You are asked whether to build Oracle GoldenGate intercept libraries. Oracle GoldenGate recommends building a GGSLIB object, but it can be omitted if you do not need to capture non-audited Enscribe files or FUP-related activities. (You can build a GGSLIB object later.)

   *************************************************
   *   If you need the TNS mode GGS Intercept      *
   *   Library GGSLIB then answer Yes,             *
   *   Otherwise you can skip this step.           *
   *************************************************
   Build of new GGSLIB recommended. Build now (y/n)? Y
   

7. The BUILDMAC utility runs and searches for run-time libraries to bind with GGSLIB, and you may be prompted that one or more libraries is missing. Enter Y to continue.

   *** Running BUILDMAC to build GGSLIB ***
   *******************************************************
   Looking for runtime libraries to BIND with GGSLIB
   *******************************************************
   Adding $SYSTEM.ZCOBOLRT.CLIBOBJ (COBOL74)
   Adding $SYSTEM.ZCOB85RT.C8LIB (COBOL85)
   $SYSTEM.ZCRERTL.CFELIB skipped (CRE)
   Adding $SYSTEM.SYSTEM.CRELIB (CRE)
   Adding $SYSTEM.SYSTEM.COBOLLIB (COBOL85)
   One or more libraries was missing. Continue anyway? (Y/N) Y
   

8. You are asked if you want to include a user library. Respond either Y or N.

   Do you want to include your own User Library (y/n)? N
   

9. You are asked if you want to change the location of the AUDCFG.

   Do you want to change the location for the AUDCFG segment (Y/N): N
   

   If you respond with yes, it prompts you for the new default location ($vol.subvol) of the AUDCFG segment.

   Assuming you opted to build the intercept libraries, you will see the BIND steps being performed. You may see the following Binder messages that can be safely ignored. They are:

   WARNING 60: Parameter mode mismatch on PXS_FILE_WRITE_parameter2. Parameter mismatch between two external procedure declarations. The parameters are declared as STRING and OTHER.
   WARNING 61: Parameter type mismatch on PXFS_FILE_WRITE_parameter2. Parameter mismatch between two external procedure declarations. The parameters are declared as INT32 and OTHER.
   WARNING 61 Parameter type mismatch on PXFS_FILE_WRITE_parameter3.
   

   Other warnings may also be displayed and can be ignored.

10. You are asked if you want to build the native mode Oracle GoldenGate intercept libraries GGSLIBR and GGSSRL/GGSDLL. To install native code, enter Y and continue to the next step; otherwise, enter N to use TNS code and then skip to step 17.

    *************************************************
    *   If you need the Native mode GGS Intercept   *
    *   Library GGSSRL/GGSLIBR then answer Yes,     *
    *   Otherwise you can skip this step.           *
    *************************************************
    STOPPED: 2,33
    CPU time: 0:00:00.945
    1: Process terminated with warning diagnostics
    STOPPED: 2,223
    CPU time: 0:01:18.782
    1: Process terminated with warning diagnostics
    Build Native mode GGSLIBR & GGSSRL (Y/N?) Y
    

11. The NLDLIB macro runs, and you are asked if you want to include a user library. Reply either Y or N.

    *** Running NLDLIB to build GGSLIBR & GGSSRL ***
    ----------------------------------------------------------------
    NLDLIB builds the native relinkable libraries GGSLIBR and GGSSRL
    A Native mode GGSLIB needs the re-linkable versions of some
    Tandem SRLs. ZCREREL and ZCOBREL. If Native cobol support is not
    required then ZCOBREL may be omitted.
    If Native Cobol support is required then you have to compile the
    Cobol program and search in GGSLIBR
    A Native mode GGSSRL will be built for a User Library for Dynamic
    linking
    Enter X at any prompt to EXIT
    ----------------------------------------------------------------
    Do you want to include your own User Library (Y/N) : N
    

12. You are asked if you want to change the location of the AUDCFG.

    Do you want to change the location for the AUDCFG segment(Y/N) : N
    

    If you respond with yes, it prompts you for the new default location ($vol.subvol) of the AUDCFG segment.

13. You are asked if you want to include ZCREREL. It is recommended to enter Y to include it unless you know your applications do not use these libraries.

    Do you want to include ZCREREL (Y/N) : Y
    

    NLDLIB searches for ZCREREL locations and displays them.

    Looking for ZCREREL ..
    $SYSTEM.SYS02.ZCREREL $SYSTEM.SYS03.ZCREREL $SYSTEM.SYS04.ZCREREL
    $DATA09.R1269G09.ZCREREL $DATA09.R8431G09.ZCREREL
    

14. You are asked to enter the location of the ZCREREL to use.

    Enter location of ZCREREL : $SYSTEM.SYS03.ZCREREL
    

15. You are asked if you want to include ZCOBREL. It is recommended to enter 3 to include it unless you know your applications do not use these libraries.

    Do you want to include ZCOBREL (Y/N) : Y
    

    NLDLIB searches for ZCOBREL locations and displays them.

    Looking for ZCOBREL ..
    $SYSTEM.SYS02.ZCOBREL $SYSTEM.SYS03.ZCOBREL $SYSTEM.SYS04.ZCOBREL
    $DATA09.R8107G09.ZCOBREL $DATA09.R8108D46.ZCOBREL
    

16. You are asked to enter the location of the ZCOBREL to use. If you plan to use COBOL, enter a location; otherwise, you can press Enter to bypass this prompt.

    Enter location of ZCOBREL : $SYSTEM.SYS03.ZCOBREL
    

    Note:

    If you omit a ZCOBREL location, you are prompted to confirm your choice:

    Omit ZCOBREL (y/n):Y
    

    NLDLIB builds the GGSLIBR and GGSSRL libraries, displaying a series of informational messages and the names of the files that were created.

    Note:

    On systems running Guardian G06.23 or earlier, the GGSUNPAK utility installs and accelerates Audserv and Logdump. If you are running G06.24 or later, you will not see any acceleration messages.

17. You are asked if Oracle GoldenGate should use an existing SQL catalog or create a new catalog. Either enter X to specify no catalog or enter the name of a catalog to use. If you enter a catalog name and it does not exist, you are asked whether to create it.

    SQL Catalog for Compilation (X for no catalog)? GGSCAT
    Catalog $TRNG04.CPSCAT does not exist. Create it (Y/N)? Y
    

    The SQL compilation completes, and then libraries and programs are linked. This happens automatically and does not require action from you.

18. You are asked if you want to migrate information from another Oracle GoldenGate environment. If you are installing Oracle GoldenGate for the first time, enter N. If you are upgrading from a previous version, see "Upgrading Oracle GoldenGate". A migration requires shutting down existing Oracle GoldenGate processes and, if Logger is being used, the user application. (The following assumes a new installation.)

    Would you like to Migrate information
    from another GGS Environment (Y/N)? N
    

19. You are advised to license your programs as shown in the following prompt, and then the installation utility finishes.

    Make sure to secure files appropriately. If EXTRACT is to be executed
    outside of the SUPER group, you must PROGID and LICENSE the AUDSERV
    program for SUPER.SUPER authority. PRIVLIB must also be licensed
    if executing Replicat outside SUPER group.
    Audserv/LOGDUMP licensing only applies to TMF installations.
    TMFARUL2 must be licensed
    The Native Audserv must be licensed (A TMFARUL2 restriction)
    The Native Logdump must be licensed if you are going to use it
    to read TMF trails (A TMFARUL2 restriction)
    TACL> LOGON SUPER.SUPER
    TACL> FUP
    -GIVE Audserv, SUPER.SUPER
    -SECURE Audserv, "NUNU", PROGID
    -LICENSE Audserv
    -LICENSE PRIV*
    -LICENSE LOGDUMP
    -LICENSE TMFARUL2
    Installation Complete.
    

    Licensing must be run by SUPER.SUPER because the following privileged access is required:

    • Audserv and TMFARUL2 access the TMF trails through audit read routines.

    • PRIVLIB contains privileged Replicat code that runs certain privileged FUP DUP or FUP LOAD operations.

    • Logdump provides a version that can read the audit read routines. If you do not want Logdump to be able to read the audit trails, do not license it.

      Note:

      If the version of your SQL catalog does not allow FUP to alter the program, you can PROGID and license the programs by using the following commands to license the components shown.

    TACL> LOGON SUPER.SUPER
    TACL> SQLCI
     >> ALTER PROGRAM AUDSERV OWNER 255,255;
     >> ALTER PROGRAM AUDSERV SECURE "NUNU" PROGID;
     >> EXIT
    TACL> FUP
     - LICENSE (AUDSERV, PRIV*, LOGDUMP, TMFARUL2)
     - EXIT
    

20. Once your product is installed, log on as the owner of your Oracle GoldenGate environment.

21. (Optional) You can purge the *PK files, if desired.

2.2.1 Migrating from a Previous Release of Oracle GoldenGate:

Following are the steps to migrate from a previous release of Oracle GoldenGate:

1. Bring down your current Oracle GoldenGate instance:

   TACL> RUN GGSCI
   GGSCI> STOP SYNCFILE *
   GGSCI> STOP REPLICAT *
   GGSCI> STOP EXTRACT *
   GGSCI> STOP LOGGER
   GGSCI> STOP MANAGER
   GGSCI> EXIT
   

2. After you install Oracle GoldenGate, GGSUNPAK prompts you:

   Would you like to Migrate information from another GGS environment (Y/N): Y
   

3. Enter your previous Oracle GoldenGate volume and subvolume:

   Enter old GGS vol.subvol: $PROD.GGS1000
   Copying GGS data from $PROD.GGS1000...
   File Utility Program - T6553G07 - System  \GGS2
   (C)1981 Tandem (C)2005 Hewlett Packard Development Company, L.P.
   ALLOW ABENDS OFF
   ALTER CONTEXT, NO AUDIT
   LOAD $DATA11.GGS1000.CONTEXT, CONTEXT, SORTED
   RECORDS LOADED: 8
   ALTER CONTEXT, AUDIT
   ALTER GROUP, NO AUDIT
   COPY $DATA11.GGS1000.GROUP, GROUP
   3 RECORDS TRANSFERRED
   ALTER GROUP, AUDIT
   ALTER EXTCTXT, NO AUDIT
   COPY $DATA11.GGS1000.EXTCTXT, EXTCTXT
   1 RECORDS TRANSFERRED
   ALTER EXTCTXT, AUDIT
   ALTER REPGRP, NO AUDIT
   COPY $DATA11.GGS1000.REPGRP, REPGRP
   1 RECORDS TRANSFERRED
   ALTER REPGRP, NO AUDIT
   COPY $DATA11.GGS1000.REPGRP, REPGRP
   1 RECORDS TRANSFERRED
   ALTER REPGRP, AUDIT
   ALTER REPCTXT, NO AUDIT
   COPY $DATA11.GGS1000.REPCTXT, REPCTXT
   2 RECORDS TRANSFERRED
   ALTER REPCTXT, AUDIT
   ALTER REMCTXT, NO AUDIT
   ALTER REMCTXT, AUDIT
   ALTER RMTCTXT, NO AUDIT
   COPY $DATA11.GGS1000.RMTCTXT, RMTCTXT
   1 RECORDS TRANSFERRED
   ALTER RMTCTXT, AUDIT
   LOAD $DATA11.GGS1000.LOGGGS, LOGGGS, SORTED
   RECORDS LOADED: 188
   ALTER LOGCONF, NO AUDIT
   ALTER LOGCONF, AUDIT
   ALTER MRKRGGS, NO AUDIT
   ALTER MRKRGGS, AUDIT
   

4. If you have a running Logger process, you are asked if you want to HOTSWAP the Logger object.

   Logger was running during migrate
   Do you want to HOWSWAP logger to the new ENV  (Y?N)
   

   If you answer yes, the program will change to the Logger object running in the migration process installation location.

   Note:

   You can HOTSWAP only when migrating from a release 10.0 or later environment. Caution: You must coordinate HOTSWAP with any manual steps to upgrade BASELIB as part of the upgrade process.

5. DUP any Obey files you use in your current Oracle GoldenGate environment. This step is particularly critical if your Obey files contain table define names or startup/shutdown commands.

6. Recompile your user exits, then rebind them into Oracle GoldenGate. You must perform this step to ensure your user exits work with your newly-installed release of Oracle GoldenGate.

   Note:

   When you install the new release of Oracle GoldenGate, all program locations are updated to the new default. If Extract or Replicat are expected to run from a specific place, you must manually point to the correct location using the ALTER command.

   TACL> ALTER EXTRACT group_name PROGRAM program_location
   

7. Point your applications to the new release of GGSLIB.

   TACL> BIND PROGRAMS, CHANGELIB
   

   Enter the list of applications you want to bind.

   Enter your new GGSLIB when prompted.

   Enter GO to bind your new library to your applications.

8. Restart your Oracle GoldenGate components in your new environment.

2.3.1 Sizing

Before you begin running Oracle GoldenGate in your production environment, you should consider several factors regarding the size of your replication environment, including the following statistics.

• Counts of inserts, updates and deletes generated on a per-file basis. A common reference point is the application's transaction rate, from which these numbers can often be estimated.

• The byte generation rate caused by inserts, updates and deletes. Use this statistic to estimate disk space requirements and communications bandwidth. Byte generation totals during peak periods and over an extended time frame are also important.

• For update-intensive applications, the number of bytes in a record that change during an update. This is probably the most difficult statistic to extract (especially for Enscribe files) but can have a dramatic impact on bandwidth requirements. The number of bytes that change in a record during an update determines the compression rate for the record.

• The cache hit rate and file busy percentages of the most heavily updated files. This has a direct bearing on the throughput possible by individual Replicat processes on the target system.

• Which programs are causing the heaviest amount of update activity. It is often possible to avoid replicating certain types of activity (such as FUP LOAD) by excluding those programs from replication. Measuring individual programs is a concern primarily for non-TMF data processing.

Oracle GoldenGate provides two programs, MEASFLS and MEASRPT, to assist in determining sizing and configuration parameters for TMF and non-TMF based processing. MEASFLS gathers statistics using MEASURE. MEASRPT interprets MEASURE statistics and produces a report that assists in the sizing process.The MEASFLS and MEASRPT programs collect these statistics easily without requiring knowledge of the Measure utility.

2.3.2 CPU Requirements

CPU requirements for Oracle GoldenGate components vary primarily according to transactions rates, record sizes, and the I/O mix (numbers of updates versus inserts and deletes).

As a percentage of overall application processing, Oracle GoldenGate as a general rule requires more CPU resources when:

• I/O is a larger percentage of overall application processing.

• Files are buffered.

• TMF auditing is off.

• Cache hits are high.

• When TMF is on, audit compression is used.

• All files are replicated.

More power is required because the application can produce relatively more I/O under these conditions.

2.3.3 Disk Space Requirements

Disk space requirements can vary depending on whether you are processing data from TMF-enabled applications or from non-TMF-enabled applications.

2.3.4 Data Communications Requirements

Each record Oracle GoldenGate sends to the target system includes a header portion and a data portion. To compute total byte generation and transfer requirements in a given period, sum the byte counts of the headers and data for each record inserted, updated or deleted during the period.

The overall amount of activity can be calculated using the following statement. (Headers vary in size, however, the average is approximately 50 bytes. For this reason, the following example uses an 80-byte header.)

(number of inserts * (size of average insert + 80)) +
(number of deletes * (size of average record + 80)) +
(number of updates * (size of averaged compressed update + 80))

For Enscribe files, the size of insert and delete records can vary and may not be the same as the record size for the file (which represents the maximum size of each record). For inserts and deletes, all bytes in the record are transferred, along with a header.

For SQL tables, all bytes are transferred for insert and delete records as well.

With Oracle GoldenGate, the following data is not transferred to the target system:

• Images of updates before the update occurs (Only after-images are sent for hot site backup.)

• Alternate key data

• SQL indexes

• Data generated by FUP RELOAD

• Assorted other TMF records

When sizing data communications bandwidth, peak byte generation is important. Bandwidth that can accommodate peak volumes helps guarantee low latency between the source and target databases at all times.

When moving data, Extract accumulates and sends records in 28K blocks across the network whenever database activity is high. Therefore the amount of data moved through Extract over a communication channel can be approximately 75-80% of channel capacity. For example, on a 10-megabit Ethernet network with approximately 4-megabits per second of true throughput, Extract can move approximately 3.5M bits per second (430KB/sec).

When sizing communications requirements, note that Oracle GoldenGate can send data over multiple TCP/IP channels simultaneously. You can achieve total bandwidth requirements over multiple lines or networks as an alternative to a single path.

2.4.1 Downloading Source Data Definitions

You can optionally download source data definitions from the source database into a definitions file on the target system. In most cases, you will want to download source data definitions to the target.

When the target resides on another NonStop system, run the DEFGEN utility to download data definitions. When the target resides on Windows/UNIX systems, run the DDLGEN utility to download data definitions.

2.4.2 Synchronizing Source and Target

Before running online synchronization for the first time, run an initial-load process to synchronize the source and target. This applies a copy of the source to the target. If Extract or Replicat stops running for any reason, you may need to re-synchronize the source and target and restart the Extract and Replicat groups to reset the checkpoints. For further assistance with your initial load, see "Configuring Initial Data Synchronization".