|Oracle® GoldenGate Veridata Administrator's Guide
11g Release 2 (18.104.22.168.0)
Part Number E29092-01
|PDF · Mobi · ePub|
This chapter explains how to install a new, clean copy of the Oracle GoldenGate Veridata software for use with an Oracle database repository.
To upgrade an existing installation, see Chapter 12, "Upgrading Oracle GoldenGate Veridata."
This chapter includes the following sections:
This check is only required if you are installing the server component to use the
TNSNAMES connection method
Run the operating system's command line interface (UNIX/Linux command shell or Windows command console).
Execute one of the following commands.
Windows: Execute outside the Oracle installation
UNIX/Linux: Execute as follows:
OK on the last line of the output confirms that the Oracle installation files and DLLs are installed correctly. Any other result indicates a problem, which must be fixed before proceeding with these steps.
After a successful
tnsping command, execute one of the following commands as an administrator user.
The result should be a SQL*Plus command prompt. If you do not receive the SQL*Plus command prompt, it means that you cannot connect to the database by using a connect string. This problem must be fixed before running the installer.
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
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.
Start /wait GoldenGate_Veridata_platformrelease.exe -c
UNIX and Linux:
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.
One of the following screens appears:
Oracle Database Home Location: This screen appears if there is only one Oracle instance installed, or if you are installing on a UNIX system where the
ORACLE_HOME environment variable is defined. Verify that this Oracle installation location is the one that belongs to the database that will be the Oracle GoldenGate Veridata repository. If this is not the correct Oracle Home, click Cancel to exit the installer. Consult the database documentation for how to set the Oracle Home. After correctly setting the Oracle Home, run the installer again.
Oracle Database Configuration: If this screen appears, the installer was unable to locate a
tnsnames.ora file. You can bypass the
tnsnames.ora file by selecting
EZCONNECT as the connection method, or you can click Browse to point the installer to the correct
tnsnames.ora file location.
Database Driver Configuration: Specify the SQL*Net connection information to use.
Depending on whether you forced
EZCONNECT on the previous screen (if it appeared in your case), you may be permitted to select only one of these options.
Select Use TNS names to have Oracle GoldenGate Veridata get connection information from the
tnsnames.ora file. The drop-down list displays all Oracle instances that are listed in the
TNSNAMES.ORA file that is associate with the previously selected
ORACLE_HOME. Make certain that the entry for this instance in the file is correct and that this same service name is configured in the
listener.ora file. Make certain that
TNSNAMES is one of the values in the
NAMES.DIRECTORY_PATH parameter in the
sqlnet.ora file on the database system. Many installation and connection problems can be traced to incorrect connection identifiers in these files.
On a UNIX system, if the installer is run from the command line instead of from a GUI, it may not display all of the Oracle instances in
TNSNAMES.ORA, but only the first Oracle instance in the list. Type the correct instance name if it is not displayed.
Select Use EZCONNECT to have Oracle GoldenGate Veridata connect by using
EZCONNECT. Then, supply the name or IP address of the database server (domain-qualified name, if required by the operating system), the database listening port number (default is 1521), and the instance name of the database. If connection errors occur, make certain that
EZCONNECT is specified for the
NAMES.DIRECTORY_PATH parameter in the
sqlnet.ora file on the database system.
Veridata Repository, database option: Oracle GoldenGate Veridata requires a database user ID or schema to own and connect to the repository. Specify whether to create a new user ID for this purpose or to use an existing user ID. Use an existing user ID or schema 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.
Logon Screens: The next screens vary, depending on your previous selection for the repository configuration.
To create a new user:
Veridata Repository Admin: Supply the login credentials of an existing database user that has DBA or system administrator privileges to create the Oracle GoldenGate Veridata user and schema.
Click Next and then supply login credentials for the new Oracle GoldenGate Veridata user. The installer creates the new user with the necessary privileges to operate as Oracle GoldenGate Veridata.
To use an existing user:
Supply the login credentials of the existing user, and then click Next.
If the specified schema already contains Oracle GoldenGate Veridata objects, you are prompted to specify whether to drop and recreate it (removes existing objects) or to use it (preserves existing objects). Click Next after making a selection.
(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.
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.