1 Preparing to Install Oracle GoldenGate Studio

To prepare for your Oracle GoldenGate Studio installation, verify that your system meets the basic requirements. Then obtain the correct installation software.

Roadmap for Installing Oracle GoldenGate Studio

This roadmap provides the steps required to install Oracle GoldenGate Studio, such as verifying your environment, running the installer, creating the Repository schema, and starting Oracle GoldenGate Studio after installation.

The following table provides the high-level steps required for installing Oracle GoldenGate Studio.

Table 1-1 Standard Installation Roadmap

Task Description Documentation

Verify your system environment.

Before beginning the installation, verify that the minimum system and network requirements are met.

See Roadmap for Verifying Your System Environment.

Check for any mandatory patches that will be required before or after the installation.

Review the Oracle Fusion Middleware Infrastructure release notes to see if there are any mandatory patches required for the software products you are installing.

See Install and Configure in Release Notes for Oracle Fusion Middleware Infrastructure.

Obtain the appropriate distribution.

Obtain the Oracle GoldenGate Studio distribution.

See Obtaining the Product Distribution.

Determine your installation directories.

Verify that the installer can access or create the installer directories that it must access or create. Also, verify that the directories exist on systems that meet the minimum requirements.

Note: Oracle does not recommend installing the Oracle GoldenGate Studio binaries on an NFS-mounted file system.

See What are the Key Oracle Fusion Middleware Directories? in Oracle Fusion Middleware Understanding Oracle Fusion Middleware.

Install the software.

Run the Oracle Universal Installer to install Oracle GoldenGate Studio.

Installing the software transfers the software to your system and creates the Oracle home directory.

See Installing the Oracle GoldenGate Studio Software.

Note:

Oracle GoldenGate Studio is a Standalone Software, you do not have to install the Infrastructure Software as a prerequisite.

Create the Oracle GoldenGate Studio Repository schema.

Run the Repository Creation Utility to create the Oracle GoldenGate Studio Repository schema.

See Creating the Oracle GoldenGate Studio Repository Schema.

Start and use Oracle GoldenGate Studio.

Discover additional tools and resources to use Oracle GoldenGate Studio.

See Next Steps After Installing Oracle GoldenGate Studio.

Roadmap for Verifying Your System Environment

Before you begin the installation process, read and understand the important information in this roadmap. It identifies important tasks and checks to perform to ensure that your environment is properly prepared for installing Oracle GoldenGate Studio.

The following table identifies important tasks and checks to perform to ensure that your environment is prepared for installing Oracle GoldenGate Studio.

Table 1-2 Roadmap for Verifying Your System Environment

Task Description Documentation

Verify certification and system requirements.

Verify that your operating system is certified and properly configured for installation and configuration.

See Verifying Certification, System, and Interoperability Requirements.

Identify a proper installation user.

Verify that the installation user has the required permissions to install the software.

See Selecting an Installation User.

Select the Oracle home directory on your system.

Verify that you can create the necessary Oracle home directory for installation, according to the recommended directory structure.

Oracle GoldenGate Studio is a standalone installation. The Oracle home directory should be a new, empty directory.

See About the Oracle Home Directory.

Install a certified JDK.

The installation program for the distribution requires a certified JDK present on your system.

See About JDK Requirements for an Oracle Fusion Middleware Installation.

Install and configure a database for mid-tier schemas.

You must have access to a certified database that is properly configured for the Repository schema required by Oracle GoldenGate Studio.

See About Database Requirements for an Oracle Fusion Middleware Installation.

Verifying Certification, System, and Interoperability Requirements

Oracle recommends that you use the certification matrix and system requirements documents with each other to verify that your environment meets the requirements for installation.

  1. Verifying that your environment meets certification requirements:

    Make sure that you install your product on a supported hardware and software configuration. See the certification document for your release on the Oracle Fusion Middleware Supported System Configurations page.

    Oracle has tested and verified the performance of your product on all certified systems and environments. Whenever new certifications are released, they are added to the certification document right away. New certifications can be released at any time. Therefore, the certification documents are kept outside the documentation libraries and are available on Oracle Technology Network.

  2. Using the system requirements document to verify certification:

    Oracle recommends that you use the Oracle Fusion Middleware System Requirements and Specifications document to verify that the certification requirements are met. For example, if the certification document indicates that your product is certified for installation on 64-Bit Oracle Linux 6.5, use this document to verify that your system meets the required minimum specifications. These include disk space, available memory, specific platform packages and patches, and other operating system-specific requirements. System requirements can change in the future. Therefore, the system requirement documents are kept outside of the documentation libraries and are available on Oracle Technology Network.

  3. Verifying interoperability among multiple products:

    To learn how to install and run multiple Fusion Middleware products from the same release or mixed releases with each other, see Oracle Fusion Middleware 12c Interoperability and Compatibility in Oracle Fusion Middleware Understanding Interoperability and Compatibility.

Selecting an Installation User

The user who installs and configures your system must have the required permissions and privileges.

About User Permissions

The user who installs a Fusion Middleware product owns the files and has certain permissions on the files.

The user who installs a Fusion Middleware product has the following permissions on them:

  • Read and write permissions on all non-executable files (for example, .jar, .properties, or .xml). All other users in the same group as the file owner have read permissions only.

  • Read, write, and execute permissions on all executable files (for example, .exe, .sh, or .cmd). All other users in the same group as the file owner have read and execute permissions only.

This means that someone other than the person who installs the software can use the installed binaries in the Oracle home to configure a domain or set of Fusion Middleware products.

Below are some additional considerations to make prior to running the installer:

  • On UNIX operating systems, Oracle recommends that you set the umask to 027 on your system prior to installation. This ensures that file permissions are set properly during installation. Use the following command:

    umask 027

    You must enter this command in the same terminal window from which you plan to run the product installer.

  • On UNIX operating systems, do not run the installation program as the root user. The installer startup validation will fail and you will not be able to continue.

  • When managing a product installation (for example, applying patches), you must use the same user ID as was used to perform the initial product installation.

  • On Windows operating systems, the user performing the installation must have Administrator privileges. See Verifying the Installation User has Administrator Privileges on Windows Operating Systems.

About Non-Default User Permissions on UNIX Operating Systems

Changing the default permission setting reduces the security of the installation and your system. Oracle does not recommend that change the default permission settings.

If other users require access to a particular file or executable, use the UNIX sudo command or other similar commands to change the file permissions.

Refer to your UNIX operating system Administrator's Guide or contact your operating system vendor, if you need further assistance.

Verifying that the Installation User has Administrator Privileges on Windows Operating Systems

To update the Windows Registry, you must have administrator privileges.

By default, users with the administrator privilege sign in to the system with regular privileges, but can request elevated permissions to perform administrative tasks.

To perform a task with elevated privileges:

  1. Find the Command Prompt icon, either from the Start menu or the Windows icon in the lower-left corner.
  2. Right-click Command Prompt and select Run as administrator.
    This opens a new command prompt window, and all actions performed in this window are done with administrator privileges.

    Note:

    If you have User Access Control enabled on your system, you may see an additional window asking you to confirm this action. Confirm and continue with this procedure.
  3. Perform the desired task.

    For example, to start the product installer:

    For a jar file, enter:

    java —jar distribution_name.jar

    For an executable (.exe, .bin, or .sh file), enter:

    distribution_name.exe

About the Oracle Home Directory

When you install any Oracle Fusion Middleware product, you must use an Oracle home directory.

This directory is a repository for common files that are used by multiple Fusion Middleware products installed on the same machine. These files ensure that Fusion Middleware operates correctly on your system. They facilitate checking of cross-product dependencies during installation. For this reason, you can consider the Oracle home directory a central support directory for all Oracle Fusion Middleware products installed on your system.

Fusion Middleware documentation refers to the Oracle home directory as ORACLE_HOME.

Oracle Home Considerations

Keep the following in mind when you create the Oracle home directory and install Fusion Middleware products:

  • Do not include spaces in the name of your Oracle home directory; the installer displays an error message if your Oracle home directory path contains spaces.

  • You can install only one instance of each Oracle Fusion Middleware product in a single Oracle home directory. If you need to maintain separate versions of a product on the same machine, each version must be in its own Oracle home directory.

    Although you can have several different products in a single Oracle home, only one version of each product can be in the Oracle home.

Multiple Home Directories

Although in most situations, a single Oracle home directory is sufficient, it is possible to create more than one Oracle home directory. For example, you need to maintain multiple Oracle home directories in the following situations:

  • You prefer to maintain separate development and production environments, with a separate product stack for each. With two directories, you can update your development environment without modifying the production environment until you are ready to do so.

  • You want to maintain two different versions of a Fusion Middleware product at the same time. For example, you want to install a new version of a product while keeping your existing version intact. In this case, you must install each product version in its own Oracle home directory.

  • You need to install multiple products that are not compatible with each other. See Oracle Fusion Middleware 12c (12.2.1.3.0) Interoperability and Compatibility in Oracle Fusion Middleware Understanding Interoperability and Compatibility .

Note:

If you create more than one Oracle home directory, you must provide non-overlapping port ranges during the configuration phase for each product.

About JDK Requirements for an Oracle Fusion Middleware Installation

Most Fusion Middleware products are in .jar file format. These distributions do not include a JDK. To run a .jar distribution installer, you must have a certified JDK installed on your system.

Make sure that the JDK is installed outside of the Oracle home. If you install the JDK under the Oracle home, you may encounter problems when you try to perform tasks in the future. Oracle Universal Installer validates that the Oracle home directory is empty; the install does not progress until you specify an empty directory. Oracle recommends that you locate your JDK installation in the /home/oracle/products/jdk directory.

Platform-specific distributions have a .bin (for UNIX operating systems) or .exe (for Windows operating systems) installer; in these cases, a platform-specific JDK is in the distribution and you do not need to install a JDK separately. However, you may need to upgrade this JDK to a more recent version, depending on the JDK versions that are certified.

Always verify the required JDK version by reviewing the certification information on the Oracle Fusion Middleware Supported System Configurations page. For 12c (12.2.1.3.0), the certified JDK is 1.8.0_131 and later.

To download the required JDK, navigate to the following URL and download the Java SE JDK:

http://www.oracle.com/technetwork/java/javase/downloads/index.html

About Database Requirements for an Oracle Fusion Middleware Installation

Many Oracle Fusion Middleware products require database schemas prior to configuration. If you do not already have a database where you can install these schemas, you must install and configure a certified database.

To find a certified database for your operating system, see the certification document for your release on the Oracle Fusion Middleware Supported System Configurations page on the Oracle Technology Network (OTN).

To make sure that your database is properly configured for schema creation, see Repository Creation Utility Requirements in the Oracle Fusion Middleware System Requirements and Specifications document.

After your database is properly configured, you use the Repository Creation Utility (RCU) to create product schemas in your database. This tool is available in the Oracle home for your Oracle Fusion Middleware product. See About the Repository Creation Utility in Oracle Fusion Middleware Creating Schemas with the Repository Creation Utility.

Obtaining the Product Distribution

You can obtain the Oracle Fusion Middleware Infrastructure and Oracle GoldenGate Studio distribution on the Oracle Technology Network (OTN).

To prepare to install Oracle Fusion Middleware Infrastructure and Oracle GoldenGate Studio:

  1. Enter java -version on the command line to verify that a certified JDK is installed on your system. For 12c (12.2.1.3.0), the certified JDK is 1.8.0_131 and later.

    See About JDK Requirements for an Oracle Fusion Middleware Installation.

  2. Locate and download the Oracle Fusion Middleware Infrastructure and Oracle GoldenGate Studio software.

    See Obtaining Product Distributions in Oracle Fusion Middleware Planning an Installation of Oracle Fusion Middleware.