With the announcement of Oracle Golden Gate 12c, there comes a few new features that everyone is going to explore. One new feature is the new way of installing Oracle Golden Gate. In the past, the installation was simple. Just copy the zip/tar file to the directory you want to install it in and unzip/untar the file. Then from the GGSCI prompt run CREATE SUBDIRS. Sounds simple enough.
With the release of Oracle Golden Gate 12c, Oracle has finally created a Oracle Universal Installer (OUI) for Oracle Golden Gate. The OUI finally brings the installation of Oracle Golden Gate into the same java interface as all the other Oracle products. With this approach, hopefully, there will not be a need to unzip/untar as we have done in the past and an entry will finally get put into the OraInventory file. In this post, lets take a look at how the OUI and what we can expect when installing Oracle Golden Gate 12c.
As with any time we are grabbing Oracle software to install, it can either be grabbed from http://otn.oracle.com or from http://edelievery.oracle.com (providing you have access). In this case, I downloaded the file from OTN. The file that was downloaded is named: 121200_fbo_ggs_Linux_x64_shiphome.zip. This is the 12.1.2 release of Oracle Golden Gate for Linux-x64. My test environment for this install is a OEL linux VM running on VMWare 8 with Oracle Database 12c.
After downloading the software to my download directory, I can unzip the file as normal with Oracle software that is downloaded.
[[email protected] Downloads]$ unzip ./121200_fbo_ggs_Linux_x64_shiphome.zip
What you will notice is that the unzipping will create a new directory called fbo_ggs_Linux_x64_shiphome. Under this directory you will find a directory called Disk1 (finally a directory structure like other software). In the Disk1 directory, you will now find a runInstaller command. From here, the installation of Oracle Golden Gate 12c can begin. Run the following command to start the OUI.
[[email protected] Disk1]$ ./runInstaller &
Once the OUI starts, we will be presented with the first screen in the installation process. Notice (before clicking next), that the OUI is giving the option to install either Oracle Golden Gate 12c or Oracle Golden Gate 11g. This is interesting because Oracle is giving us the option now to install either of the products depending on environment where we need this installed.
Side Note: To install Oracle Golden Gate 12c against an 11g database, select the option for Oracle GoldenGate for Oracle Database 11g. If you select the option for Database 12c, the installation will be valid but will not start against an 11g database due to shared libraries needed (libnnz12.so ). Support version for Integrated Replicat is Oracle 11g (18.104.22.168).
After clicking Next, we are taken to the Installation Details screen. On this screen we can specify the software location. By default Oracle will provide a path, this can be changed. In the example, I changed it to be inline with my environment. Notice that Oracle is calling the home location OGGCORE_1. Does this mean the days of naming the environment GGATE or something similar are gone? No, we can still adjust as needed. Another interesting thing on the Installation Details screen is the check box for Start Manager. Once the installation is done, Oracle will start the manager for you. Oracle has finally provided some guidance on default ports for the Manager process; the port can still be changed though (I prefer a higher port number). Oracle also takes the default Oracle home for the database that is running in the environment. If there are more than one Oracle home, the OUI gives you the option to select the correct Oracle home. Click Next when ready.
Note: When clicking Next, if you are trying to install Oracle Golden Gate 12c against a Database 11g home, the OUI will present the following warning. The warning is pretty much telling me that a 11gR2 (22.214.171.124) database is not supported for the selected install option (GG12c (12.1.2)). This must mean that Oracle is keeping the Golden Gate 12c version specific to database 12c due to the new feature such as Integrated Replicat. Although the installation will complete successfully against a 11g database home, the GGSCI tool will not start. This is due to Golden Gate looking for the libnnz12.so in the shared libraries.
After Installation Details screen, we are taken to the Summary screen. As with most OUI installations, the summary screen details what and where the installation will happen. Make sure everything is where you want it to be, then click the Install button.
The installation will begin and look pretty much like any other installation.
After the installation is complete, we are taken to the Finish screen. At this point, we can click Finish and exit the OUI.
Since the installation completed, the next thing I wanted to do is validate the installation. One thing I wanted to do is check the oraInventory file to validate that the OUI now knows about the installation of Oracle Golden Gate. As you can see, we now have an Oracle Home for Golden Gate (OraHome1).
The next thing I want to check is if GGSCI will start. We start GGSCI the same way as before. Set the Oracle home for the database and start GGSCI from the Golden Gate home. You will also notice, after doing an INFO ALL, the manager process has already been started (as select during installation).
Oracle GoldenGate Command Interpreter for Oracle
Version 126.96.36.199.0 17185003 OGGCORE_188.8.131.52.0_PLATFORMS_130924.1316_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Sep 25 2013 02:33:54
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved.
GGSCI (tester.acme.com) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
GGSCI (tester.acme.com) 2>
Now that Oracle Golden Gate 12c is installed and verified that it is running, there are so many questions that need to be researched and verified. One such question, is what parameters is Oracle specifying as the default parameters for the manager process. In editing the MGR.PRM file, the only parameter that is listed is the PORT parameter.
[[email protected] dirprm]$ vi mgr.prm
Another interesting thing to note, is that there is no need to run CREATE SUBDIRS now. The OUI does all this for you and sets everything up to start the manager.
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.