Oracle GoldenGate Veridata is a high speed, heterogeneous, data comparison and repair solution. It is completely independent of any replication technologies.
The new version of Oracle GoldenGate Veridata is 23c which was released with many enhancements like new mordenized User Interface, Enhanced Architecture and functionalities and with many performance improvements.
The old version of Oracle GoldenGate Veridata is 12c and it is going to get desupported in the upcoming years. So, how do we migrate from Veridata 12c to Veridata 23c? Is this a big challenge? No, Not at all.
This blog explains about the process of migrating Oracle GoldenGate Veridata from 12c to 23c which is configured without SSL.
In Oracle GoldenGate Veridata, we have various utilities such as,
1. Vericom Utility – Command Line Interface
2. Export / Import Utilities
3. VGPP Utility (Only available till Veridata 12c)
The Export / Import Utilities are mainly used for migration.
The Export Utility helps to export all the configurations from the Veridata 12c into an XML file. This XML file can be provided as an input to the Import Utility in Veridata 23c so that it imports all the configurations like Connections, Groups and Compare Pairs, Jobs and Profiles to the new Veridata Server.
This eliminates the creation of all these configurations post migration of the Veridata Server.
The Oracle GoldenGate Veridata 12c is configured in the below dierctory,
And we have various configurations already done which are as below,
Before migrating all these configurations to the new Veridata 23c, we need to first install it. Please refer to the below links,
To install Veridata 23c in Interactive mode (GUI),
Oracle GoldenGate Veridata 23c – Interactive Installation (GUI)
To install Veridata 23c in Silent mode,
Oracle GoldenGate Veridata 23c – Silent Installation
The new Oracle GoldenGate Veridata 23c has been installed in a new server.
No configurations are done like Connections, Groups and Compare Pairs, Jobs and Profiles.
One more point here to consider is, you need to install the Veridata agents using the Oracle GoldenGate Veridata 23c. For example, if you have agents installed for 5 source databases and 5 target databases, then you have to install 5 agents for source databases and 5 for target databases from the Veridata 23c home. This is a must.
So, please create new agents accordingly before starting the migration.
In this example, I have installed and configured the new Veridata Agents in the below location,
Now, let us export all the configurations from the old Oracle GoldenGate Veridata 12c server using the Export Utility. Till, Oracle GoldenGate Veridata 12c, the Export/Import utilities are available only in the CLI mode (Vericom).
From Oracle GoldenGate Veridata 23c, these utilities are integrated to the Veridata UI itself and they are available in both CLI and GUI mode.
Below are the steps to export all the configurations from the old Veridata 12c Server.
Navigate to the below location which has all the executables of Veridata Server and you can see the “veridata_export.sh”
Use the below syntax to export all the configurations.
In the above syntax,
-export File Path where to export the configurations. The configurations will be exported to the XML file.
-all Export objects that are not part of any job. Takes precedence over all optional operations. This is the default when no other options are specified.
-wluser Specifies a user commandlineUsername with Veridata configuration privileges and command-line privileges.
-wlport Represents the port for Veridata web server. The default value is 8830.
-exportPassword Export the passwords for connections. By default, passwords for connections are not exported.
Now, let’s execute the command to export the configurations from Oracle GoldenGate Veridata 12c.
It asks for the WebLogic password, and please provide the veridata password.
A notification message will be displayed upon successful completion of the export.
The configurations are export to the below mentioned location.
A sample of the XML file for your reference. (Only few lines are posted below).
Having said that the export is successful, now transfer this XML file to the new Veridata 23c server (if you are going to access UI from VDT23c) or transfer it to your local machine (if you are going to access it from your local machine).
Before starting the import, few changes has to be done to this XML file. Below are the changes.
- If the Veridata Agents are installed remotely, for example in the server where Veridata 12c is installed, then you have to change the hostnames accordingly. “host“ is the parameter in the connection tab.
- For security reasons, if you have exported the configurations without the passwords, then please provide the passwords for the connections with the keyword password=”password” in the connection tab.
- As I already mentioned that this blog is to explain how to migrate to new Veridata 23c without SSL. So, use the parameter use-ssl=”false” in the connection tab.
After making all these changes, save the XML file. I have saved the XML to my local machine.
Let us start importing the file.
As I mentioned, that the utilities like Export and Import available in both CLI and GUI modes from Veridata 23c, click on the Utilities option in the left pane of the Veridata 23c console.
Click on the Import tab from the Utilities window.
Browse for the XML file.
Click on the Import button.
Import is in progress.
Import of the configurations is successful. You can see the message in the window.
Now, let us check the configurations like Connections, Groups and Compare Pairs, Profiles and Jobs. Everything will be created as part of the import.
All the configurations are imported successfully to the new Oracle GoldenGate Veridata 23c. In this blog, we just had only few configurations like couple of connections, 3 to 4 Jobs, Groups and Profiles. We can easily create these in the new Veridata 23c server. But, how about in a real production environment where we will have Jobs and Groups with 1000’s of Compare Pairs. It would be very tideos to create all these configurations post migration of Veridata.
The Export/Import utilities made our job so easy in migrating Veridata from 12c to 23c.