Upgrading Oracle GoldenGate Veridata

2 Upgrading Oracle GoldenGate Veridata

Follow step by step procedures to upgrade your system and also upgrade your utilities such as schemas and Oracle GoldenGate Veridata agent.

This chapter includes the following sections:

2.1 Choosing an Upgrade Path and Upgrading

To upgrade your existing Oracle GoldenGate Veridata release to the Veridata 12c (12.2.1.4.0) release, choose the appropriate upgrade path for your environment and follow the steps in the section to proceed with your upgrade:

Upgrading GoldenGate Veridata 12.2.1.2.0 Domain to 12.2.1.4.0

2.1.1 Upgrading GoldenGate Veridata 12.2.1.2.0 Domain to 12.2.1.4.0

To upgrade from a GoldenGate Veridata 12.2.1.2.0 domain to Veridata 12.2.1.4.0:

Run the Upgrade Assistant to upgrade your Veridata and OPSS schema to 12.2.1.4.0 with Upgrading Veridata Schemas which is the recommended way to upgrade as mentioned in All Schemas Used by Domain.
Run the Oracle WebLogic Server Reconfiguration Wizard to reconfigure your existing 12.2.1.2.0 domain to a 12.2.1.4.0 domain with this command.
```
ORACLE_HOME/oracle_common/common/bin/reconfig.sh -log=logFileName.log -log_priority=FINE
```
Start your Veridata WebLogic Server and domain. See Starting the Servers in the Installing and Configuring Oracle GoldenGate Veridata Guide.
Run the agent_config utility to upgrade your Veridata Agent with Upgrading the Oracle GoldenGate Veridata Agent.
Go to Performing Post-Upgrade Tasks.

Note:

After the Oracle GoldenGate Veridata gets upgraded successfully to 12.2.1.4.0, before launching the user interface (UI), ensure to clear the browser cache. Once cache is cleared, you can launch the Oracle GoldenGate Veridata UI.

2.2 Upgrade Utilities

This section contains explanations of how to use each of the upgrade utilities for the various upgrade paths that are identified in Choosing an Upgrade Path and Upgrading. You are directed to use these utilities with the steps in your chosen upgrade path:

For more information about the Upgrade Utilities, see About Using the Upgrade Assistant.

2.2.1 Upgrading Veridata Schemas

The Oracle Fusion Middleware Upgrade Assistant upgrades your Oracle GoldenGate Veridata schema to 12c (12.2.1.4.0). For more information about the features of Upgrade Assistant, see About Using the Upgrade Assistant.

This topic contains the following:

Upgrading Oracle GoldenGate Veridata Schemas from 12.2.1.2.0 Domain to 12.2.1.4.0

2.2.1.1 Upgrading Oracle GoldenGate Veridata Schemas from 12.2.1.2.0 Domain to 12.2.1.4.0

The Oracle Fusion Middleware Upgrade Assistant upgrades your Oracle GoldenGate Veridata schema to 12c (12.2.1.4.0).

To upgrade the Veridata repository schema from 12.2.1.2.0 Domain to 12.2.1.4.0:

To start Upgrade Assistant, go to the ORACLE_HOME/oracle_common/upgrade/bin directory, and enter the following command:

On UNIX: ./ua

Note:
A default logging level is NOTIFICATION. In general -logLevel TRACE is recommended for 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.

On Windows: ua.bat

Note:
A default logging level is NOTIFICATION. In general -logLevel TRACE is recommended for 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 appears. Click Next.
Select All Schemas Used By a Domain as the upgrade type. Click Next.

After selecting Next, the screen displays the auto-selected schemas as shown in the following figure:
You must select all the checkboxes to continue. The Upgrade Assistant will not verify that the prerequisites have been met.
On the VERIDATA Schema page, enter the connection credentials for the database containing the schema you want to upgrade.
On the Examine screen, the Upgrade Assistant performs a series of validations before upgrading the selected components. Ensure that all validations have succeeded. Click Next.
Click Upgrade on the Upgrade Summary screen to begin the upgrade. The Upgrade Progress screens shows information about the progress of the upgrade, and the Upgrade Success screen summarizes the upgrade.

To verify the schema upgrade, follow the procedure as described in Verifying the Schema Upgrade.

To troubleshoot issues that might occur during schema upgrade, review the logs as described in Troubleshooting your Upgrade.

2.2.2 Upgrading the Oracle GoldenGate Veridata Agent

Upgrade your existing Oracle GoldenGate Veridata Agent to 12c (12.2.1.4.0) agent by running the following command:

Deploy the Veridata Agent to the same location used in 12c (12.2.1.2.0) setup.

ORACLE_HOME/veridata/agent/agent_config.sh OLD_AGENT_ORACLE_HOME. This command replaces the following files with the new 12.2.1.4.0 files:

On Unix:

agent.properties.sample
config/agent-jps-config.xml
config/certs/serverIdentity.jks
config/certs/serverTrust.jks
config/odl.xml;
agent.sh
configure_agent_ssl.sh

On Windows:

agent.bat
agent.properties.sample
config/agent-jps-config.xml
config/certs/serverIdentity.jks
config/certs/serverTrust.jks
config/odl.xml
configure_agent_ssl.bat
service/Install_Veridata_Agent.bat
service/README.txtservice/Start_Veridata_Agent.bat
service/Stop_Veridata_Agent.bat
service/Uninstall_Veridata_Agent.bat
service/agent_service.properties

(Optional) If you have changed any of the files listed in step 1 in the previous release, then use your backup files to replace these changed files. If your Veridata Agent is installed as a service in Windows machine, then update the service/agent_service.properties property with the same service name that you used in the previous release.
(Optional) To configure SSL communication between the Veridata Agent and the Server, set the SSL properties for the agent and follow the procedure as described in "Configuring Oracle GoldenGate Veridata Security" chapter in the Administering Oracle GoldenGate Veridata Guide.
Start your Oracle GoldenGate Veridata Agent.