Installing and Configuring Oracle GoldenGate Studio 12c

Overview
Don't want to design or build Oracle GoldenGate architecture from Command line? Oracle GoldenGate Studio is the answer for you.
In 2015, Oracle has released a new tool which provides a Graphical User Interface (GUI) for designing and building Oracle GoldenGate Architecture called "Oracle GoldenGate Studio".

Installing Oracle GoldenGate Studio consists of following steps:

1. Ensure Java JDK 1.8 is installed
2. Install Oracle GoldenGate Studio
3. Configure Oracle GoldenGate Studio repository
4. Start and Connect to Oracle GoldenGate Studio 

In this artcile I will demonstrate how to Install and Configure Oracle GoldenGate Studio 12c in detail.

Environment

• Oracle Enterprise Linux 6.8
• Oracle RDBMS 11.2.0.4

Assumption
It is assumed that you have a database created which will be used as respository for OGG Studio

Downloading and Installing latest JDK

• Get the current Java version installed.

[root@dm01db01 software]# java -version
java version "1.7.0_91"
Java(TM) SE Runtime Environment (build 1.7.0_91-b32)
Java HotSpot(TM) 64-Bit Server VM (build 24.91-b03, mixed mode)

Java JDK 1.7 and earlier versions doesn't work with the JAR files for Studio.
Java JDK 1.8 is required for GoldenGate Studio Installation.

• 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

• Copy the downloaded rpm the server using WinScp and apply it.

[root@dm01db01 ]# cd /u01/app/oracle/software
[root@dm01db01 software]# ls -ltr
-rw-r--r-- 1 root   root     166040563 Jan  3 03:11 jdk-8u111-linux-x64.rpm

[root@dm01db01 software]# rpm -i jdk-8u111-linux-x64.rpm
Unpacking JAR files...
        tools.jar...
        plugin.jar...
        javaws.jar...
        deploy.jar...
        rt.jar...
        jsse.jar...
        charsets.jar...
        localedata.jar...

• Verify the Java version 

[root@dm01db01 software]# java -version
java version "1.8.0_111"
Java(TM) SE Runtime Environment (build 1.8.0_111-b14)
Java HotSpot(TM) 64-Bit Server VM (build 25.111-b14, mixed mode)

Downloading Oracle GoldenGate Studio Software

• Open a web browser and enter www.oracle.com in the address bar

• This will bring you to the Oracle website home page

• On this page hover on the download tab and click on "middleware"

• Click GoldenGate

• Accept the agreement and select the desired Oracle GoldenGate version for your platform.

Here I am downloading "fmw_12.2.1.2.6_oggstudio_Disk1_1of1.zip"

• Sing in if prompted. The download will begin

• Copy the zip file from your desktop to the server using WinScp

• Drag and Drop the file from left to right in to a directory

Here I am copying the file to /u01/app/oracle/software location

• File copy is in progress

• Once the file transfer is completed, you will see the file on server as below

dm01db01-orcldb1 {/u01/app/oracle/software}:ls -ltr

-rw-r--r-- 1 oracle oinstall 2042373304 Jan  3 04:42 fmw_12.2.1.2.6_oggstudio_Disk1_1of1.zip

Steps to Install Oracle GoldenGate Studion

• Make sure Java is set in your path properly.

dm01db01-orcldb1 {/home/oracle}:whereis java

java: /usr/bin/java

• Here I am using Oracle user to install GoldenGate Studio software

[oracle@dm01db01 software]# java -version

java version "1.8.0_111"

Java(TM) SE Runtime Environment (build 1.8.0_111-b14)

Java HotSpot(TM) 64-Bit Server VM (build 25.111-b14, mixed mode)

• Unzip the Oracle GoldenGate Studio software

dm01db01-orcldb1 {/u01/app/oracle/software}:unzip fmw_12.2.1.2.6_oggstudio_Disk1_1of1.zip

Archive:  fmw_12.2.1.2.6_oggstudio_Disk1_1of1.zip

  inflating: fmw_12.2.1.2.6_oggstudio.jar

  inflating: fmw_122126_readme.htm

dm01db01-orcldb1 {/u01/app/oracle/software}:ls -ltr

-rw-r--r-- 1 oracle oinstall       9032 Dec  5 16:49 fmw_122126_readme.htm

-r-xr-xr-x 1 oracle oinstall 2042431392 Dec  5 16:55 fmw_12.2.1.2.6_oggstudio.jar

-rw-r--r-- 1 oracle oinstall 2042373304 Jan  3 04:42 fmw_12.2.1.2.6_oggstudio_Disk1_1of1.zip

• Start the x-window and set the DISPLAY variable to launch the installation window

dm01db01-orcldb1 {/u01/app/oracle/software}:export DISPLAY=10.10.193.2:0.0

• Start the Oracle GoldenGate Studio software installation as follows:

dm01db01-orcldb1 {/u01/app/oracle/software}:java -jar fmw_12.2.1.2.6_oggstudio.jar

Launcher log file is /tmp/OraInstall2017-01-03_05-02-43AM/launcher2017-01-03_05-02-43AM.log.

Extracting the installer . . . . . . . . . . . . . . . . . . . . Done

Checking if CPU speed is above 300 MHz.   Actual 2527.001 MHz    Passed

Checking monitor: must be configured to display at least 256 colors.  Actual .   Passed

Checking swap space: must be greater than 512 MB.   Actual 16378 MB    Passed

Checking if this platform requires a 64-bit JVM.   Actual 64    Passed (64-bit not required)

Checking temp space: must be greater than 300 MB.   Actual 8262 MB    Passed

Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2017-01-03_05-02-43AM

Log: /tmp/OraInstall2017-01-03_05-02-43AM/install2017-01-03_05-02-43AM.log

Logs successfully copied to /u01/app/oraInventory/logs.

• The Installer wizard will be started

• This is the first step out of 8 steps. Click Next

• Select "Skip Auto Updates" and Click Next

• Enter the Oracle GoldenGate Studio home for software installation

• Select installation type as "Complete Install (Default)". Click Next

• Prerequisite checks are performed. Click Next

• The installation Summary is displayed

• Now the Software Installation progress

• Click Finish

Configure Oracle GoldenGate Studio repository

The Oracle GoldenGate Studio store entire replication design and deployment details in a database repository. You must install the repository schema on a certified database before using Oracle GoldenGate Studio. The repository is created using the Oracle Repository Creation Utility (RCU).

Make sure you created a database for storing the Oracle GoldenGate Studio objects before proceeding. Here I already have a database created by the name "orcldb" which I will be using as a repository.

• Make sure the DISPLAY is set properly and Launch the Repository Creation Utility as follows:

dm01db01-orcldb1 {/u01/app/oracle/software}:cd /u01/app/oracle/product/oggstudio12c/oracle_common/bin/

dm01db01-orcldb1 {/u01/app/oracle/product/oggstudio12c/oracle_common/bin}:./rcu

        RCU Logfile: /tmp/RCU2017-01-03_07-10_453443440/logs/rcu.log

• On the home page. Click next

• Select "Create Repository" and "System Load and Product Load". Click Next

• Enter the Oracle Database server details and Click next

• Prerequisites checks are performed. Click ok

•  Enter the "Create New Prefix". Click next

• Prerequisite checks are performed. Click Ok

•  Enter the password for all Schemas. Here I am select "Use same password for all schemas"

•  Enter the Password for "Supervisor" user. Click Next

• Click Next

• Click ok

• Click ok

• On this page, tablespace mapping is displayed. Click next

• System load in progress

• Click Close to complete the RCU process

Start and Connect to Oracle GoldenGate Studio 

Now let's start the oggstudio and connect to the repository

Make sure the DISPLAY variable is set properly so the installer can be launced.

Execute the oggstudio utitilty to start the Oracle GoldenGate Studio 

dm01db01-orcldb1 {/u01/app/oracle/product/oggstudio12c/oggstudio/bin}:./oggstudio

Oracle GoldenGate Studio
Copyright (c) 1997, 2016, Oracle and/or its affiliates. All rights reserved.

Type the full pathname of a JDK installation (or Ctrl-C to quit), the path will be stored in /home/oracle/.oggstudio/12.2.1.2.0/product.conf
/usr/java/jdk1.8.0_111

Note: When you start the oggstudio for the first time, it will ask you for the jdk location and stores in it product.conf file. The furture start will not ask you for the jdk location again.

The Oracle GoldenGate Studio page appears as below

 For the first time it will ask you, if you would like to import preferences from previous installation. Click No.

• The load will continue as follows

• Click on the Plug symbol to connect to the repository database

• Enter the Supervisor and it's password

• Finally the oggstudio is started and you are connected the repository

Conclusion

In this article we have learned how to install and configure Oracle GoldenGate Studio 12c. The OGG Studio is very useful for the folks who can to design and build Oracle GoldenGate architecture using GUI interface.