Before You Begin
This tutorial describes how to install and configure the Oracle GoldenGate Veridata.
Background
For proof-of-concept, you can install the following on one host: Oracle WebLogic Server, Fusion Middleware Infrastructure, and Oracle GoldenGate Veridata.
What Do You Need?
- Linux
- Oracle Database 19c (19.3.0.0) (for the repository)
- Java 1.8 or higher
- Oracle GoldenGate Software
Installing
and Configuring the Back End
In a nutshell, the installation process includes the following four major tasks. After completing these steps, you can configure the Oracle GoldenGate Veridata Agents.
- WebLogic Server and Infrastructure file needed for Oracle
GoldenGate Veridata. Install the WebLogic Server
infrastructure (formerly known as JRF) files on top of an
existing 12.2.1.4.0 WebLogic Server install. Invoke this by using the
command:
java -jar fmw_12.2.1.4.0_infrastructure_generic.jar
. - Oracle GoldenGate Veridata Server + Oracle GoldenGate
Veridata Agent. It is a jar file, and works on all supported
platforms except NonStop. Choose a required combination. For
this tutorial, the choice was "complete" to get everything
installed in one pass. Invoke this by using the command:
java -jar fmw_12.2.1.4.0_ogg.jar
. - Run the Repository Creation Utility (RCU). It gets installed
as a part of the WLS+JRF install in Step 1. You can run it
once for all the products (WLS and Veridata.) The RCU location
in this demo (and the sample VM) is:
/u01/app/oracle/product/wls/oracle_common/bin/rcu
. - Configure the Oracle WebLogic Server and Oracle GoldenGate
Veridata domains. You can run this once for all products. To
configure the WebLogic Server, use the command:
/u01/app/oracle/product/wls/oracle_common/common/bin/config.sh
.
Installing
the Fusion Middleware Infrastructure
- Open a terminal session. Run the following command:
java -jar fmw_12.2.1.4.0_infrastructure_generic.jar
- Click Next to continue to the Auto Updates section. Leave the default option Skip Auto Updates selected and click Next.
- Enter a location for Oracle Home to store the binary files.
- Click Next to continue.
- Select either installation type (Fusion Middleware infrastructure With Examples or Fusion Middleware Infrastructure). Towards the end of this step, the Oracle WebLogic Server gets installed.
- Enter a location for Oracle Home to store the binary files.
- Wait for the progress bar to reach 100%. The Java version required is 1.7 or higher. Click Next to continue to the Prerequisistes Checks screen.
- Click Next to continue to the Installation
Summary screen.
Description of this image - On the Installation Summary screen, click Next to display the Installation Progress panel.
- Click Install to continue and wait for the progress bar to reach 100%. You can optionally view the logs.
- Click Next to view the Installation Complete panel.
- Click Finish.
![FMW Step 1 of 7](img/FMW_Welcome_screen1.png)
![FMW Step 1 of 7](img/FMWScreen2_AutoUpdatesPNG.png)
![FMW Step 1 of 7](img/FMWScreen3_InstallationLocation.png)
![FMW Step 1 of 7](img/FMWScreen4_InstallationType.png)
![FMW Step 1 of 7](img/FMWScreen5_PrerequisitesChecks.png)
![FMW Step 1 of 7](img/FMWScreen7_InstallationProgress.png)
![FMW Step 1 of 7](img/FMWScreen8_InstallationComplete.png)
Installing
Oracle GoldenGate Veridata
To install and configure Oracle GoldenGate Veridata:
- Open the terminal session and run the installer with the
following command:
java -jar fmw_12.2.1.4.0_ogg.jar
. You now see the splash screen. - After you have read the instructions on the Welcome screen, click Next to continue to the Auto Updates screen.
- Click Next to continue to the Auto Updates section. Leave the default option Skip Auto Updates selected and click Next.
- Enter the same Oracle Home directory that you entered in the previous section.
- Click Next to continue and display the Installation Type screen.
- Select the Oracle GoldenGate Veridata options that you want to install, or select Complete Install to get them all.
- Click Next to continue to the Prerequisites Check screen.
- After the progress bar has reached 100%, click Next to display the Installation Summary screen. Note that the next steps that are required to run the Repository Creation Utility (RCU) and then run the Configuration Wizard, are mentioned in the Installation Summary screen.
- Click Install to continue and display the Installation Progress screen and wait for the progress bar to reach 100%. You can also view the logs.
- Click Next to continue to the Installation Complete screen.
![FMW Step 1 of 7](img/VeridataInstall_Welcome1.png)
![FMW Step 1 of 7](img/VeridataInstall_Welcome2.png)
![FMW Step 1 of 7](img/VeridataInstall_AutoUpdates_Screen3.png)
![FMW Step 1 of 7](img/VeridataInstall_InstallLocation_Screen4.png)
![FMW Step 1 of 7](img/VeridataInstall_InstallType_Screen5.png)
![FMW Step 1 of 7](img/VeridataInstall_PrereqChecks_Screen6.png)
![FMW Step 1 of 7](img/VeridataInstall_InstallationSummary_Screen7.png)
![FMW Step 1 of 7](img/VeridataInstall_InstallProgress_Screen8.png)
![FMW Step 1 of 7](img/VeridataInstall_InstallComplete_Screen9.png)
Configuring
RCU
The Repository Creation Utility (RCU) presumes that you have already installed a compatible database to house the repository. This example assumes that it is an Oracle 12c Database.
To configure the RCU:
- Open a terminal session. Start the RCU with this command:
/u01/app/oracle/product/wls/oracle_common/bin/rcu
. - Click Next in the Welcome screen to display the Create Repository screen.
- In the Create Repository screen, the default is Create Repository with System Load and Product Load. Click Next to continue.
- Enter the appropriate information to log in to your database with full privileges in the Database Connection Details screen.
- Click OK to dismiss Checking Prerequisites. Click Next to continue.
- If this is the first time you have run RCU, then the only option is to create a new prefix. If you have run RCU in the past, then it will increment the previous prefix by one, to form a new prefix. For example, DEV2 or DEV3. You can override the suggestion. Select Oracle GoldenGate, Veridata Repository.
- Click OK to dismiss the Checking Prerequisites.
- Click Next to continue.
- Enter the same password twice. Many of the sample VM
databases use
oracle
as the default password for all schemas. - Click Next to continue to the Map Tablespaces screen.
- Accept the default tablespace allocations.
- Click OK in the Repository Creation Utility - Confirmation dialog box.
- Click Next to display Summary
screen.
Description of this image - Click Create to display the Complete
Summary.
Description of this image - Click Close to continue.
![FMW Step 1 of 7](img/RCU_CreateRepository_Screen2.png)
![FMW Step 1 of 7](img/RCU_DatabaseConnectionDetails_Screen3.png)
![FMW Step 1 of 7](img/RCU_SelectComponents_Screen4.png)
![FMW Step 1 of 7](img/RCU_SchemaPasswords_Screen5.png)
![FMW Step 1 of 7](img/RCU_MapTablespace_Screen6.png)
Creating
the Domain
The Configuration Wizard can either create a new domain or extend an existing domain. This example shows how to create a new domain.
- Open a terminal session. Invoke the Configuration wizard by
entering
/u01/app/oracle/product/wls/oracle_common/common/bin/config.sh
. - Click Browse to select the Domain Location.
- Click Next to display the Templates screen.
- Select Veridata Standard Server Domain. This causes the Oracle JRF to be selected automatically. If the Oracle JRF is not selected, then you have not installed the Infrastructure correctly.
- Click Next to continue.
- Enter the same password twice. Complexity rules require a
number or special character in the password. The sample VM
uses
weblogic1
. Note the difference between the lowercase L in the middle and the numeral one at the end. - Click Next to continue.
- If you plan to use localhost/127.0.0.1 as the host name/address, then you must select Development. In Production, use the real host name and address instead of using localhost.
- Click Next to continue.
- Enter the Host Name, Port, Schema Owner, and Schema Password in the Database Configuration Type screen.
- Click Get RCU Configuration to continue.
- Verify the Connection Result Log and then click OK.
- Click Next to continue to the JDBC Component Schema Test screen.
- Click Next to continue to the JDBC Test screen. The Test Select Connection happens automatically. Look at the Connection Result Log
- Ensure that all the Status check boxes are selected, indicating a successful result log.
- Click Next to display the Keystore screen.
- Enter a Password for the Alias.
- Click Next to display the Advanced
Configuration screen, but do not select any of the
Advanced Options.
Description of this image Note: Here you can choose to configure clusters of servers, if you need high availability using multiple hosts.
- Click Next to display the Configuration Summary screen. In this screen, you can identify where the Veridata server application is deployed. If you used clusters, you need to deploy the application to the cluster, not to any one server.
- Click Create to display the Configuration Progress screen. When the progress bar reaches 100%, it should say "Domain Created Successfully!"
- Click Finish to continue. Note the URLs to use from a web browser to reach the WebLogic Administration Console: an http URL which is insecure, and an https URL which uses SSL for increased security.
Note: The Create a new domain option is selected by default.
![FMW Step 1 of 7](img/CreatingDomain_CreateDomain_Screen1.png)
![FMW Step 1 of 7](img/CreatingDomains_Templates_Screen2.png)
![FMW Step 1 of 7](img/CreatingDomains_AdministratorAccount_Screen3.png)
![FMW Step 1 of 7](img/CreatingDomain_DomainModeandJDK_Screen4.png)
![FMW Step 1 of 7](img/CreatingDomain_DatabaseConfigurationType_Screen5.png)
![FMW Step 1 of 7](img/CreatingDomain_JDBCOmponentSchema_Screen6.png)
![FMW Step 1 of 7](img/CreatingDomain_JDBCTest_Screen7.png)
![FMW Step 1 of 7](img/CreatingDomain_Keystore_Screen8.png)
![FMW Step 1 of 7](img/CreatingDomain_ConfigurationSummary_screen10.png)
![FMW Step 1 of 7](img/CreatingDomain_Completion_Screen12.png)
Deploying
the Agents
Assumptions:
- You have already installed and configured the database.
- The software distribution files have been downloaded and unzipped.
- This is the script used to Install the Fusion Middleware
software:
########################################################### ###########################################################
Install WebLogic Server + Infrastructure files needed for OGG:
java -jar fmw_12.2.1.4.0_infrastructure_generic.jar
# OGG Veridata + agent.
java -jar fmw_12.2.1.4.0_ogg.jar
Repository Creation Utility; can run once for all products.
/u01/app/oracle/product/wls/oracle_common/bin/rcu
- This is the script used to configure the Fusion Middleware
software:
###########################################################
Configure WLS and Veridata; can run once for all products.
/u01/app/oracle/product/wls/oracle_common/common/bin/config.sh
###########
Veridata agents. Can run from anywhere, give destination as argument.
/u01/app/oracle/product/wls/veridata/agent/agent_config.sh /u01/ogg/agents/veridata/agent1
# Should return, "Successfully deployed the agent."
- These are the changes made to the
agent.properties
file:cd /u01/ogg/agents/veridata/agent1
Note: The database-specific files are under the
sample_properties
directory and you need to select the respective file and copy that asagent.properties
.Example for Oracle DB:
cp sample_properties/agent.properties.oracle agent.properties
gedit agent.properties
server.port=7850
database.url=jdbc:oracle:thin:@//localhost:1521:orcl
server.driversLocation=/u01/app/oracle/product/12.1.0/dbhome_1/jdbc/lib
server.jdbcDriver=odbc7.jar
- All scripts are created in the Desktop/ directory purely
for convenience:
# Start WLS /u01/app/oracle/product/wls/ogg_domain/startWebLogic.sh
# Start Veridata Server + Agent
# Server only
/u01/app/oracle/product/wls/ogg_domain/veridata/bin/veridataServer.sh start
# Agent only
/u01/ogg/agents/veridata/agent1/agent.sh start
To deploy the agents: