1 Preparing for the Oracle GoldenGate Veridata Upgrade

Before you upgrade Oracle GoldenGate Veridata, let's make sure you meet the requirements and understand the process.

This chapter includes the following sections:

1.1 Overview of the Oracle GoldenGate Veridata Upgrade Process

The upgrade process described in this document applies to upgrades from Oracle GoldenGate Veridata Release 12c (12.2.1.2.0) to 12.2.1.4.0.

The following table describes the directories and the variables that are used when referring to those directories in this book.

Table 1-1 Directories in an Oracle GoldenGate Veridata Installation

Directory Variable Directory Path

ORACLE_HOME

/install_location This is the home directory for the Oracle Fusion Middleware products.

VERIDATA_PRODUCT_HOME

/ORACLE_HOME/veridata

OLD_AGENT_ORACLE_HOME

/VERIDATA_PRODUCT_HOME/agent for your existing 12.2.1.2.0 Oracle GoldenGate Veridata Agent.

NEW_AGENT_ORACLE_HOME

/VERIDATA_PRODUCT_HOME/agent for your new 12.2.1.4.0 Oracle GoldenGate Veridata Agent.

AGENT_DEPLOY_LOCATION

This is the location where the Oracle GoldenGate Veridata Agent is deployed in the Oracle WebLogic Server domain.

Note: that this location should be outside the ORACLE_HOME.

1.2 Oracle GoldenGate Veridata Server Upgrade Roadmap

Follow the steps below to upgrade Oracle GoldenGate Veridata:

  1. Before you upgrade, back up your existing environment then ensure that all pre-upgrade requirements are met. See "Pre-Upgrade Tasks for Oracle GoldenGate Veridata Upgrade".

  2. Ensure that all upgrade prerequisites are met. See Understanding the Upgrade Prerequisites.

  3. Install Oracle GoldenGate Veridata 12c (12.2.1.4.0). See Installing and Configuring Oracle GoldenGate Veridata.

  4. Install Oracle GoldenGate Veridata Agent 12c (12.2.1.4.0). See Installing the Oracle GoldenGate Veridata Agent Files.

  5. Perform a readiness check then upgrade your existing environment to Oracle GoldenGate Veridata 12c (12.2.1.4.0). See Readiness Check for Veridata.

  6. Perform the necessary post-upgrade tasks. See Performing Post-Upgrade Tasks.

1.3 Readiness Check for Veridata

Oracle recommends that you run a readiness check before starting the upgrade process to identify potential issues with the upgrade. The readiness check may not be able to discover all potential issues with your upgrade. It is possible that an upgrade may still fail, even if readiness check reports success.

This chapter includes the following section:

1.3.1 Readiness Check for 12.2.1.2.0 Expanded Domain and 12.2.1.4.0

Schema and configuration Readiness is supported for 12.2.1.2.0 expanded domain.

To run Readiness Check for 12.2.1.2.0 expanded domain and 12.2.1.4.0:

  1. Run UA present under 12.2.1.4.0 Oracle_Home in readiness mode:
    • On UNIX: ./ua -readiness -logLevel TRACE
    • On Windows: ./ua.bat -readiness -logLevel TRACE

    Note:

    A default logging level is NOTIFICATION. In general -logLevel TRACE is recommended for Oracle GoldeGate Veridata.

    When setting the -logLevel to TRACE, more information is logged and that is used to troubleshoot a failed upgrade. The Oracle Fusion Middleware Upgrade Assistant's log files may become very large if -logLevel TRACE is used.

    The Welcome screen of the Upgrade Assistant is displayed. Click Next.

  2. Select Domain Based option, select both the displayed checkboxes, provide the domain location. Click Next.
    schema upgrade type
  3. Verify the details shown on this screen. Click Next.
    upgrade assistant component list
  4. On the VERIDATA Schema page, enter the connection credentials for the database containing the schema you want to check. Click Next.
    veridata schema from 12.2.1.2.0 and 12.2.1.4.0.
  5. Check the screen and go through the Readiness Summary. Click Next.
    readiness summary
  6. The readiness check is performed and the results are displayed on the below screen. Click Continue.
    readiness check
  7. The Readiness Success screen shows to Readiness Check Succeeded.
    readiness success

To troubleshoot issues that might occur during Readiness Check, review the logs.

1.4 Pre-Upgrade Tasks for Oracle GoldenGate Veridata Upgrade

Before you upgrade, you must do the following:

  1. Ensure that no jobs are running in your existing Veridata instance.

  2. Stop your existing Veridata Server.

  3. Stop all of your existing Veridata Agents.

  4. Back up the Veridata Agent configuration files.

    For more information about back up the Veridata Agent configuration files, see Upgrading the Oracle GoldenGate Veridata Agent

  5. Back up the Veridata repository.

    For more information about back up the Veridata repository, see Creating a Complete Backup

  6. Back up old report files. Do not delete the existing report location if you want to retain old reports.

1.5 Understanding the Upgrade Prerequisites

Following are the prerequisites for upgrading your existing Oracle GoldenGate Veridata Server to 12c (12.2.1.4.0):

  • JDK 8 must be installed on the target machine. For more information about the JDK 8 installation, see the Java Platform, Standard Edition Installation Guide at

    https://docs.oracle.com/javase/8/docs/technotes/guides/install/install_overview.html

  • Oracle WebLogic Server 12c (12.2.1.4.0) with JRF installed on the target machine. For more information, see Configuring Your WebLogic Domain.

    Note:

    Install the Oracle GoldenGate12c (12.2.1.4.0) distributions into a new Oracle home. Do not reuse the existing Oracle home for this upgrade as 12c (12.2.1.4.0) is not a patch release.
  • Before you begin your upgrade, use the Oracle Universal Installer to install the Oracle GoldenGate Veridata 12c (12.2.1.4.0) distribution on the target system.

    Note:

    You must install the Oracle Fusion Middleware Infrastructure distribution first before installing Oracle GoldenGate Veridata 12c (12.2.1.4.0) as Infrastructure is required for the upgrade.

    For more information, see Installing Oracle GoldenGate Veridata

  • If required, upgrade the Veridata repository database. For more details about the supported databases, see the system requirements document at

    https://support.oracle.com/

For more information about the certification, see Verifying Certification and System Requirements