6 Installing Using an Oracle Repository

6.1 Preinstallation System Check

This check is only required if you are installing the server component to use the TNSNAMES connection method

1. Run the operating system's command line interface (UNIX/Linux command shell or Windows command console).

2. Execute one of the following commands.

   • Windows: Execute outside the Oracle installation bin directory:

     tnsping Oracle_instance
     

   • UNIX/Linux: Execute as follows:

     $ORACLE_HOME/bin/tnsping instance
     

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

3. After a successful tnsping command, execute one of the following commands as an administrator user.

   • Windows:

     sqlplus admin_user/admin_user_password@instance
     

   • UNIX/Linux:

     sqlplus admin_user/admin_user_password@instance
     

   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.

6.2 Installing the Oracle GoldenGate Veridata Software

1. Start the database that you are using for the Oracle GoldenGate Veridata repository.

2. Close all applications that use this database.

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

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

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

6. Welcome: Click Next to start the installation.

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

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

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

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

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

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

13. Veridata Repository: Select Oracle as the database that will be the Oracle GoldenGate Veridata repository.

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

15. Database Driver Configuration: Specify the SQL*Net connection information to use.

    Note:

    Depending on whether you forced tnsnames or 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.

      Note:

      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.

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

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

18. (New user only) Veridata Oracle Tablespace: Specify default and temporary tablespaces for the Oracle GoldenGate Veridata repository.

19. (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.

20. (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.

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

22. (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.

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

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

25. Click Finish to close the installer.