Oracle GoldenGate 12c Installation

..............................I wanted to write few sample papers for my friends who just wonder to get started with Oracle Golden Gate so I thought to start writing it now for those who are looking for it.

Here I would explain the steps to install Oracle Golden Gate software for Oracle Database 11g which would be applicable to both source and target replication servers.


Golden Gate:
Oracle GoldenGate is a comprehensive software package for real-time data integration and replication in heterogeneous IT environments. The product set enables high availability solutions, real-time data integration, transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems.

In addition to the Oracle GoldenGate core platform for real-time data movement, Oracle provides the Management Pack for Oracle GoldenGate—a visual management and monitoring solution for Oracle GoldenGate deployments—as well as Oracle GoldenGate Veridata, which allows high-speed, high-volume comparison between two in-use databases.


 - Instructions for installing Oracle Golden Gate, click here

 - Download relevant version of Oracle Golden Gate from OTN Click Here or edelivery

 - I downloaded Oracle Golden Gate 12c software and staged inside /u01 mount point on source database server as below.

 cd /u01  
 -bash-4.1$ ls -ltr  
 -rwxrwxr-x. 1 oracle oinstall 475611228 Jun 3 2016 fbo_ggs_Linux_x64_shiphome.zip 

Next step is to unzip the downloaded Oracle Golden Gate software and navigate to the Oracle Golden Gate extracted folder as below.

cd /u01/fbo_ggs_Linux_x64_shiphome/Disk1

-bash-4.1$ ls -ltr
total 16
drwxr-xr-x.  4 oracle oinstall 4096 Dec 12  2015 install
drwxr-xr-x. 11 oracle oinstall 4096 Dec 12  2015 stage
-rwxr-xr-x.  1 oracle oinstall  918 Dec 12  2015 runInstaller
drwxrwxr-x.  2 oracle oinstall 4096 Dec 12  2015 response
-bash-4.1$ 

Now, here actual installation of Oracle Golden Gate will begin as follows. Run ./runInstaller to start with Oracle Golden Gate Installation.

-bash-4.1$ ./runInstaller 
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 3221 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 4095 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-07-29_04-11-58PM. Please wait ...-bash-4.1$ 

Once you start the runInstaller to install Golden Gate, following Oracle Golden Gate installation wizard will appear. Choose the appropriate Golden Gate option for database version you want to install. Here in this demo, I'm installing Oracle Golden Gate for Oracle Database 11g. Click Next.

At below screen of Golden Gate Installation wizard, choose the right Software Location which would be your Oracle Golden Gate Home, by default, Start Manager check box would be selected that means Golden Gate Manager will be started on completion of Oracle Golden Gate software installation.

In Database Location box, provide your source/target Oracle Database Home location that you want to capture or replicate to. For Manager Port option, you can choose appropriate port for your Golden Gate manager, 7809 is the default port for Oracle Golden Manager and I used that one for this demo. Click Next.

Below is the screen of Oracle Golden Gate Install wizard shows all details you provided above for it's installation. Click on Install.

Installation progresses as below.

As below screen depicts, Oracle Golden Gate Installation completed successfully.

As of now, we have installed Oracle Golden Gate software for Oracle Database 11g, now we would validate the installation of Oracle Golden Gate software as follows.

Go to Oracle Golden Gate Home and run ./ggsci to start Golden Gate Command Line Interface.

 -bash-4.1$ pwd  
 /u01/app/oracle/product/11.2.0/dbhome_1 

 
 -bash-4.1$ ./ggsci  
 Oracle GoldenGate Command Interpreter for Oracle  
 Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO  
 Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38  
 Operating system character set identified as UTF-8.  
 Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.  
 GGSCI (prodsrv) 1>   

Run info all Golden Gate command to check the status of Golden Gate Manager and extract processes.

 GGSCI (prodsrv) 1> info all  
 Program   Status   Group    Lag at Chkpt Time Since Chkpt  
 MANAGER   RUNNING                        
 GGSCI (prodsrv) 2>  

As we can see above that our Oracle Golden Gate software installed and Manager process is running so in order to configure it to get ready for database change capture, follow the below steps to create all Golden Gate sub-directories/files which are needed for it to work ahead.



Installing the Oracle GoldenGate files

1. Run the command shell/terminal.
2. Change directories to the Oracle Golden Gate Home directory.
3. From the Oracle GoldenGate directory, run the GGSCI program.
./ggsci

4. In GGSCI prompt, issue the following command to create the Oracle Golden Gate working directories.

GGSCI (prodsrv) 2> CREATE SUBDIRS  
 Creating subdirectories under current directory /u01/app/oracle/product/11.2.0/dbhome_1  
 Parameter files        /u01/app/oracle/product/11.2.0/dbhome_1/dirprm: already exists  
 Report files          /u01/app/oracle/product/11.2.0/dbhome_1/dirrpt: already exists  
 Checkpoint files        /u01/app/oracle/product/11.2.0/dbhome_1/dirchk: already exists  
 Process status files      /u01/app/oracle/product/11.2.0/dbhome_1/dirpcs: already exists  
 SQL script files        /u01/app/oracle/product/11.2.0/dbhome_1/dirsql: already exists  
 Database definitions files   /u01/app/oracle/product/11.2.0/dbhome_1/dirdef: already exists  
 Extract data files       /u01/app/oracle/product/11.2.0/dbhome_1/dirdat: already exists  
 Temporary files        /u01/app/oracle/product/11.2.0/dbhome_1/dirtmp: already exists  
 Credential store files     /u01/app/oracle/product/11.2.0/dbhome_1/dircrd: already exists  
 Masterkey wallet files     /u01/app/oracle/product/11.2.0/dbhome_1/dirwlt: already exists  
 Dump files           /u01/app/oracle/product/11.2.0/dbhome_1/dirdmp: already exists  
 GGSCI (prodsrv) 3>   

Note : I had already one setup of Oracle Golden Gate running on my system previously hence it displays that 

all directories are already exist so just ignore it here for now.

So far, we have installed Oracle Golden Gate software for Oracle Database 11g and created all required SUBDIRS for further configuration.

Note : Follow the same process to install Oracle Golden Gate software on target database server when you need to replicate change captured from source database.

In next article, I will be publishing how to configure Oracle Golden Gate for Uni-directional replication between two Oracle databases.