3 Installing Oracle GoldenGate Veridata Java Agent

3.1 Installation Overview

These instructions are for installing a new, clean copy of the Java-based Oracle GoldenGate Veridata Agent software. To upgrade an existing installation, see Chapter 12, "Upgrading Oracle GoldenGate Veridata".

You can install Oracle GoldenGate Veridata Agent to work with any of the following databases:

• DB2 LUW and z/OS

• Oracle

• SQL Server

• Sybase Adaptive Server Enterprise (ASE)

• Teradata

The Java agent can be installed on the database host or on a remote host that has network connectivity to the database host. The agent connects by JDBC (Java Database Connectivity).

3.2 Installing the Java Agent on a UNIX or Linux System

1. Create a directory for the agent.

2. Follow the steps in Appendix A, "Downloading Oracle GoldenGate Veridata" to obtain the software.

3. Extract the mediapack.zip file to the UNIX or Linux system and directory where you want the software to be installed.

4. In the agent directory within the installation directory, make a copy of the agent.properties.sample file, and rename the copy to agent.properties.

5. Open the agent.properties file with a text editor. This file contains comments that help guide your work.

6. Edit the file to provide values for the following parameters:

   Parameter	Value
   server.port	A local port where the agent listens for communication requests from Oracle GoldenGate Veridata Server.
   database.url	The standard JDBC connection URL string for the database. Samples of the correct format to use are listed with comments in the properties file. You must supply the following values that are appropriate for your database: Name of the host that contains the database. To use Oracle OCI bequeath protocol, the Oracle OCI libraries must be available locally. Port number that the database uses. Name of the database or (for Oracle) the instance. This is a sample URL for Oracle. database.url=jdbc:oracle:thin:@localhost:1521:orcl
   server.driversLocation	Specify the location of the JDBC driver. The JDBC drivers are installed by default into the drivers directory. Change this value only if you need to move the location (not recommended).
   server.jdbcDriver	The name of the JDBC driver. The drivers are listed with comments in the properties file. Uncomment the correct one for the database. Example (in this case Oracle): server.jdbcDriver=ojdbc6.jar
   database.transaction.isolation	Controls the transaction isolation level that is used during the initial comparison step.

   
   

7. Save and close the file.

3.3 Installing the Java Agent on a Windows System

1. Start the database for which you are installing this agent.

2. Follow the steps in Appendix A, "Downloading Oracle GoldenGate Veridata" to obtain the software.

3. Unzip the .zip file that you downloaded.

4. Run the GoldenGate_Veridata_Agent_platformrelease.exe executable in either of these ways:

   • As a GUI wizard: Double click the program and then follow these steps. This is the method shown in this documentation.

   • As a shell process: From the command console, issue the following command, and then continue with these steps. The prompts are similar to those shown on the wizard screens.

     Start /wait GoldenGate_Veridata_Agent_platformrelease.exe -c
     

5. Welcome screen: Click Next on the first page to start the installation.

6. 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.

7. Start Menu Folder: To add Oracle GoldenGate Veridata Agent 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, click Create Shortcuts for all users; otherwise, it will only be available to the current user.

   • To exclude Oracle GoldenGate Veridata Agent from the Start menu, click 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.

8. Agent Port: Specify a local port for the agent to use for communication with Oracle GoldenGate Veridata Server.

9. Database Details: Select the database type, and specify the name of the host system, the port number that is used by the database, the name of the database (if applicable), and (if Oracle) the name of the instance to which the agent will connect. Under JDBC URL, the resultant connection string is displayed.

10. Teradata JDBC Drivers: (Teradata only) Supply the location of the Teradata JDBC driver.

11. Database Connection Test: If you did not override the default of Test Database Connection, a test screen prompts for the authentication credentials that you created for the agent to use with this database or for an ODBC driver location, depending on the database type. Click Test Connection. Any connection errors are displayed in the output area.

12. Service Option: It is recommended that you install Oracle GoldenGate Veridata Agent 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. 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 name is unique. To prevent installation as a service, deselect the check box.

13. Start Veridata Agent 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.

14. Information: Review your installation selections. Click Back to make changes or click Next to begin the installation.

15. Click Finish to exit the installer.