2.2 Installing Oracle GoldenGate Director Server

These instructions apply to new installations. For upgrades, see Upgrading and Updating Oracle GoldenGate Director.

A new installation of Oracle GoldenGate Director Server involves the following steps:

Assigning Database Storage and Login Credentials

Downloading the Oracle GoldenGate Director Software

Installing the Oracle GoldenGate Director Server Software

2.2.1 Assigning Database Storage and Login Credentials

Before installing Oracle GoldenGate Director Server for the first time, you need to assign a storage location for the repository and assign database login credentials for Oracle GoldenGate Director to use. You can use existing objects or create new ones.

Note:

Generally a higher value is required for OPEN_CURSORS. You can set the value to 2000 using the command alter system set open_cursors=2000. When multiple processes are using cursors, the system administrator can decide on the appropriate value for OPEN_CURSORS.

2.2.1.1 MySQL

  1. Create a user and identically named database. The password must contain at least eight alphanumeric characters, with at least one alphabet character and one number.
  2. Grant the user all DDL and DML privileges in that database when this user connects to the MySQL server from the host where Oracle GoldenGate Director is being installed.

2.2.1.2 Oracle

  1. Create a user (schema) and password. The password must contain at least eight alphanumeric characters, with at least one alphabet character and one number.
  2. Specify QUOTA UNLIMITED on the user's default tablespace

2.2.1.3 SQL Server

  1. Create a database or schema and a login that is a user of the database where you will be installing the repository. The password must contain at least eight alphanumeric characters, with at least one alphabet character and one number.
  2. Grant this login sufficient privileges to perform the following operations.

    • CONNECT to the database

    • CREATE, ALTER, DROP TABLE in the database

    • CREATE and DROP INDEX in the database

    • INSERT, UPDATE, DELETE from tables in the database

    • SELECT from tables in the database

    • ALTER SCHEMA of the login's default schema

2.2.2 Downloading the Oracle GoldenGate Director Software

Follow these steps to download the Oracle GoldenGate Director software to the system where you want to install the server component (Oracle GoldenGate Director Server).

  1. Navigate to http://edelivery.oracle.com.

    The Oracle Software Delivery Cloud page appears.

  2. Click Sign-in/Register.

    Note:

    If you are not already logged in, the Single Sign-on page appears. Enter your Oracle ID and password and click Sign In.

    The Terms & Restrictions page appears

  3. Accept the Oracle Software Delivery Cloud Trial License Agreement and the Export Restrictions and click Continue.

    The Media Pack Search page appears.

  4. On the Media Pack Search page, do the following:

    1. Click the Select Product Pack drop-down control and, from the list, select Oracle Fusion Middleware.

    2. Click the Platform drop-down control and, from the list, select the platform on which you are installing the software.

    3. Click Go.

    The Results list expands to show all available media packs that include your search criteria.

  5. On the Results list, select the media pack you want to download and click Continue.

    The media pack's download page appears. Note that this page contains information about downloading the media pack. Oracle recommends that you read and familiarize yourself with this information.

  6. To ensure that you download the files successfully, first review the Media Pack Readme for download instructions and product information by clicking Readme. The Readme contains release notes for any new features, new requirements, or bug fixes that affect your current configuration and other known issues.

  7. To begin the download process, click Download.

    An Open file dialog box appears.

  8. Select either Open with or Save File:

    To... Select...

    Install media pack immediately

    Open with, select the desired file extraction utility, and extract the files to a designated location on your file system.

    Save the file for later installation

    Save file and point to a designated location on your file system.

2.2.3 Installing the Oracle GoldenGate Director Server Software

Follow these steps to install Oracle GoldenGate Director Server on any supported platform. On UNIX, you can install from the command line.

2.2.3.1 Installing Oracle GoldenGate Director Server from the Command Line

This procedure is for UNIX only and installs the software by means of command prompts.

  1. From the command line of the operating system, run the following command. 
    ./gg-director-serversetup_unix_version.sh -c
  2. Press Enter to continue with the installation process.
  3. Choose Installation Location: Specify the directory where you want to install Oracle GoldenGate Director.
  4. Select your WebLogic Install Location: Specify the directory that is directly above the directory where WebLogic Server is installed. In a default WebLogic Server directory structure, WebLogic is installed in a directory named wlserver_version under the Middleware directory in the Oracle directory; and therefore, you would select the Middleware directory. However, if you are installing Oracle GoldenGate Director into a WebLogic installation that does not have the default directory structure, whether new or renamed, do the following:

    • Update the registry.xml file in the WebLogic home directory to point to the correct WebLogic Server home directory.

    • Update all of the scripts under %WLS_SERVER_HOME%/server/bin and %WLS_SERVER%/common/bin to point to the correct WebLogic Server home directory.

    • Update the .product.properties file under %WLS_SERVER_HOME% to point to the correct WebLogic Server home directory.

  5. HTTP port: Confirm, or change, the HTTP port that Oracle GoldenGate Director Server will use to communicate with Oracle GoldenGate Director Web. In most cases, the default of 7001 should be sufficient.
  6. Select a Database: Select the type of database to use as the Oracle GoldenGate Director Server repository. A database or schema (as applicable) and user account must exist, must be properly configured, and must be running before proceeding with the installation. You can use the repository from a previous version of Oracle GoldenGate Director to preserve existing data source configurations, user accounts, and environments.
  7. Database driver configuration: Specify the following information for Oracle GoldenGate Director Server to connect to the repository database:

    • The name of the database host server.

    • (Select One) The service name or Oracle SID of the database, if using an Oracle database.

    • The port number of the database. The default port number of the selected database is displayed by the installer.

  8. Database User: Specify the name and password of an existing database user or account that can be used to log on to the database. To use an existing Oracle GoldenGate Director Server repository, use the credentials of the owner of that database or schema. These credentials are used to establish authentication within Oracle GoldenGate Director Server. The password is stored in encrypted form. Make certain the password was created with at least eight alphanumeric characters, with at least one alphabet character and one number.
  9. Review the pre-installation summary and then press Enter to begin the installation of the software. You are notified when the installation is complete.

2.2.3.2 Installing Oracle GoldenGate Director Server with the Wizard

This procedure installs Oracle GoldenGate Director by means of a graphical interface.

  1. Close other applications as permissible.

  2. Run the ggdirector-serversetup program.

  3. Welcome screen: Click Next on the first screen.

    Note:

    If you have not yet installed Oracle WebLogic Server, click Cancel to terminate this installation, and then see System Requirements for more information. Oracle GoldenGate Director must be installed as an Oracle WebLogic Server domain.

  4. Choose Installation Location: Enter, or browse to, the location where you want the Oracle GoldenGate Director installation directory to be created. Make certain there is enough free disk space to meet the requirements shown on the screen.

  5. Select your WebLogic Install Location: Select the directory that is directly above the directory where WebLogic Server is installed. In a default WebLogic Server directory structure, WebLogic is installed in a directory named wlserver_version under the Middleware directory in the Oracle directory; and therefore, you would select the Middleware directory. However, if you are installing Oracle GoldenGate Director into a WebLogic installation that does not have the default directory structure, whether new or renamed, do the following:

    • Update the registry.xml file in the WebLogic home directory to point to the correct WebLogic Server home directory.

    • Update all of the scripts under %WLS_SERVER_HOME%/server/bin and %WLS_SERVER%/common/bin to point to the correct WebLogic Server home directory.

    • Update the .product.properties file under %WLS_SERVER_HOME% to point to the correct WebLogic Server home directory.

  6. HTTP port: Confirm, or change, the HTTP port that Oracle GoldenGate Director Server will use to communicate with Oracle GoldenGate Director Web. In most cases, the default of 7001 should be sufficient.

  7. Database: Select the type of database to use as the Oracle GoldenGate Director Server repository. A database or schema (as applicable) and user account must exist, must be properly configured, and must be running before proceeding with the installation. You can use the repository from a previous version of Oracle GoldenGate Director to preserve existing data source configurations, user accounts, and environments.

  8. (Optional, MySQL only) To use MySQL Enterprise Edition, click the link to download a free trial version for use as the Oracle GoldenGate Director repository. Leave the installer running while you install and start MySQL, and then return to it when you are finished.

  9. Database driver configuration: Enter the following information for Oracle GoldenGate Director Server to connect to the repository database:

    • the name of the database host server.

    • the name of the database, or the Oracle SID if using an Oracle database.

    • the port number of the database. The default port number of the selected database is displayed by the installer.

  10. Database User: Enter the name and password of an existing database user or account that can be used to log on to the database. To use an existing Oracle GoldenGate Director Server repository, use the credentials of the owner of that database or schema. These credentials are used to establish authentication within Oracle GoldenGate Director Server. The password is stored in encrypted form. Make certain the password was created with at least eight alphanumeric characters, with at least one alphabet character and one number.

  11. (Windows) Oracle GoldenGate Director Service: Optionally, you can install Oracle GoldenGate Director Server as a Windows service. Select Install as a service (the default), and then supply a name and description for the service. If there are multiple installations of Oracle GoldenGate Director on the system, each service name must be unique.

    Note:

    The installer creates a WebLogic Domain service. If the WebLogic version is earlier than 12c, a prefix of beasvc is prepended to the service name, or if the WebLogic version is at least 12c, a prefix of wlsvc is prepended to the service name. The host name is appended to the service name. For example, if the default service name of oggdirector is used, the service name is beasvc oggdirector_localhost or wlsvc oggdirector_localhost.

  12. Pre-installation summary: Review your installation input, and then click Back to make changes or click Next to start the installation.

  13. Click Finish to close the installer.