5 Installing Using a MySQL Repository

This chapter explains how to install a new, clean copy of the Oracle GoldenGate Veridata software for use with a MySQL database repository.

To upgrade an existing installation, see Chapter 12, "Upgrading Oracle GoldenGate Veridata."

This chapter includes the following sections:

Section 5.1, "Installation Prerequisites"
Section 5.2, "Installing the Oracle GoldenGate Veridata Software"

5.1 Installation Prerequisites

Before you run the installer you need to ensure that the MySQL database is installed and can store the internationalized object names that will be used.

5.1.1 Verify the Installed MySQL Database

Perform the following steps to verify that your MySQL database is installed.

Run the operating system's command shell.
From the command shell, issue the following command to verify the MySQL installation. If the MySQL software is not installed on the Oracle GoldenGate Veridata host, the command can be executed on the host where MySQL is running, so long as you supply the network name or IP address of that host.
```
mysqladmin -u admin_user -h hostname -P port 
-p admin_user_password ping
```
Where:
- There is no space between the -p and the password.
- -h hostname is always required on UNIX and only required on Windows if the MySQL server is not running on the local machine. If the MySQL server is running on the local machine, use the loopback address of 127.0.0.1, because localhost has special meaning for MySQL and might not work with Oracle GoldenGate Veridata Server.
- -P port is only required when the MySQL server is using a port other than the default of 3306.
The following message indicates a correct installation. Any other message indicates a problem that must be resolved before running the installer.
```
mysqld is alive.
```

5.1.2 Verify the Database Character Encoding

You must also ensure that the database can handle internationalized object names. For this, the repository database must:

Be in the character set that is used for the table, column, and other object names that will be stored in it.
Have been created in the correct character set prior to running the Oracle GoldenGate Veridata installer.

5.2 Installing the Oracle GoldenGate Veridata Software

Start the database that you are using for the Oracle GoldenGate Veridata repository.
Close all applications that use this database.
Follow the steps in Appendix A, "Downloading Oracle GoldenGate Veridata" to obtain the software.
Unzip the downloaded .zip file using WinZip or a similar compression program. If installing on a UNIX or Linux system, unzip the file on a Windows system and then FTP the file to the UNIX or Linux system in binary mode.
Run the installer.
- As a wizard: Double click the GoldenGate_Veridata_platformrelease program (Windows) or use a GUI such as X Window (UNIX and Linux) and then follow the installation steps. The Windows wizard is shown in this documentation and contains additional steps not included in the UNIX or Linux versions.
- As a shell process: From the command console of the operating system, issue the following command, and then follow the installation steps. The text prompts are similar to those shown on the wizard screens. To accept the default when using the command console, click Enter.
  
  Windows:
```
Start /wait GoldenGate_Veridata_platformrelease.exe -c
```
  UNIX and Linux:
```
GoldenGate_Veridata_platformrelease.sh –c
```
Welcome: Click Next to start the installation.
Destination Directory: Select an installation directory. You can accept the default (to be created during installation), type a path name, or click Browse to go to a different directory. If installing more than one instance of this software, select a different directory or sub-directory each time that you run the installer.
Data Location: Select a location for the user data. The data directory is where Oracle GoldenGate Veridata stores reports and other files that contain information about out-of-sync rows. You can accept the default (to be created during installation), type a path name, or click Browse to go to a different directory. This directory will contain data from the tables that are compared, so it should reside on a secure system.
Web Server Configuration: Accept the default shutdown and HTTP ports or specify different ones. The shutdown port is used by Oracle GoldenGate Veridata to shut down the server processes. The HTTP port is used by the embedded Tomcat web server application to connect to the Oracle GoldenGate Veridata Web component.
Create Veridata Users: Specify which of the following methods you want to use to create Oracle GoldenGate Veridata users:
- Use the Tomcat Web Service administrative tool to manually create users after the installation.
- Have the installation program import users from an existing Oracle GoldenGate Veridata installation. You will need to know the Oracle GoldenGate Veridata administrator user for that installation.
Whichever option you select, you can add users as needed after the installation using the Tomcat Web Service administrative tool.
Import Veridata Web: This screen is displayed if you elect to import users from an existing Oracle GoldenGate Veridata installation. Enter the installation directory and the administrator's login user name and password.
Web Server Admin User: Specify an initial Oracle GoldenGate Veridata administrator user. The administrator is the most privileged role in Oracle GoldenGate Veridata and can perform all configuration, execution, and monitoring functions. Keep a record of this login. It is required to create other users after installation.
Veridata Repository: Select MySQL as the database that will be the Oracle GoldenGate Veridata repository.
Optional Software: To download and install a free trial version of MySQL for use as the Oracle GoldenGate Veridata repository, click the link to the MySQL website. Install MySQL and start it. You can leave the installer running while you do this.
Database Driver Configuration: Specify the name or IP address of the system where you are installing the Oracle GoldenGate Veridata server and web components. Specify the database port number, if it is not the MySQL default port number. If you use localhost as the host name, the installer will convert it to the IP address and alert you with a message.
Login Screens: The next screens vary, depending on your previous selection for the repository configuration.
- Veridata Repository Admin:
  
  To create a new user ID or database (or both), you are prompted for the credentials of an existing database user ID that can be used to create the object(s). The user ID will be used only for this purpose and must have administrator or DBA privileges.
- Veridata Repository:
  
  To create a new user ID, you are prompted to give it a name and password.
  
  To create a new database, you are prompted to give it a name.
  
  To use an existing user ID login, you are prompted for the login name and password.
  
  To use an existing database, you are prompted for its name. If the specified database already contains Oracle GoldenGate Veridata objects, you are prompted to specify whether to drop and recreate them (removes existing objects) or to use them (preserves existing objects).
Veridata Repository, database option: Use any combination of these options to specify how the Oracle GoldenGate Veridata repository will be configured.
- User ID: Oracle GoldenGate Veridata requires a user ID to connect to the repository. Specify whether to create a new user ID for this purpose or to use an existing user ID login. Use an existing user ID if you already created one for Oracle GoldenGate Veridata, or if you are reinstalling Oracle GoldenGate Veridata to a different location from a previous one and want to retain the old repository. An existing user ID must have DML and DDL privileges for the Oracle GoldenGate Veridata repository.
- Database: Specify whether to create a new database for the repository or use an existing one.
(Windows only) Windows Services: It is recommended that you install Oracle GoldenGate Veridata as a Windows service. When installed as a service, software can operate independently of user connections, which can accidentally be terminated, and you can configure it to start manually or at system start-up.
- Before you elect to install as a service, you must identify the user that will start the service. This logon will be granted full access to Oracle GoldenGate Veridata files. You can install the service to log on as the LocalSystem user, or you can specify a different user. If you specify a different user, that user must be granted LogonAsService privilege or the service will not start.
- When that is done, either accept the default service name or change it as required. If there are, or will be, other instances of this software on the local system, make certain that each service name is unique.
To prevent installation as a service, deselect the check box.
(Windows only) Windows Services User: If you elected to install Oracle GoldenGate Veridata as a service, this screen is displayed. Select Logon as Local System for Oracle GoldenGate Veridata to log on as LocalSystem when the service is started. If you select Logon as a specific user instead, enter the logon information of the user you wish to start the service.

Note:

The user that starts the Windows service must have LogonAsService rights. If you specify a user that does not have these rights, the service will not start.
Start after install: Specify whether or not to start the software after the installation is finished. By default, it is installed to start manually. If you are installing it as a service, a system administrator can change the properties so that it starts automatically when the system starts.
(Windows only) Start Menu Folder: To add Oracle GoldenGate Veridata to the Programs list of the Start menu, you can accept the default shortcut name (to be created during installation), type a different one, or select one from the list. To make the shortcut available to everyone who uses this system, select Create Shortcuts for all users; otherwise, it will only be available to the current user.

To exclude Oracle GoldenGate Veridata from the Start menu, select Don't create a Start Menu folder. If you are installing this software as a service, it can be started from the installation folder or the Services control panel.
Information: Review your installation selections. Click Back to make changes or click Next to begin the installation.
Completing the Oracle GoldenGate Veridata Setup Wizard: To view the Oracle GoldenGate Veridata help system after the installation is done, accept the default. To prevent the help system from launching, clear the check box. The Oracle GoldenGate Veridata help system contains an introduction to the software, information about specific functions and tasks, and a detailed tour of the web interface. This tour can help both new and experienced users get started more quickly with a better understanding of the work flow and tools.
Click Finish to close the installer.