Oracle Multitenant: The Beating Heart of #DBaaS

Start: Dec 09, 2014 01:00 PM America/Eastern
End: Dec 09, 2014 02:00 PM America/Eastern
Registration Link: https://www1.gotomeeting.com/register/911549736

The tripod of Oracle database as a service (DBaaS) rests on the strong legs of Oracle Multitenant as the enabling database architecture; Oracle Enterprise Manager for orchestration; and Oracle’s engineered systems, such as Oracle Exadata and Oracle SuperCluster, as the consolidation platforms. This total solution from a single vendor is unmatched. This session explores in detail various key capabilities of the multitenant architecture that deliver on the promise of DBaaS today.

Please signup for this webinar on DBaaS and join the IOUG Cloud Computing and Virtualization SIG for future webinars and educational series.

Best Wishes,
Charles Kim
President of the Cloud Computing and Virtualization SIG
Oracle ACE Director


First, let’s install the RPM with yum. The RPM that we want to install is called btrfs-progs.

[root@dal66a yum.repos.d]# yum install btrfs*
Loaded plugins: security
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package btrfs-progs.x86_64 0:0.20-1.8.git7854c8b.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================
 Package                    Arch                  Version                                Repository                Size
========================================================================================================================
Installing:
 btrfs-progs                x86_64                0.20-1.8.git7854c8b.el6                viscosity                396 k

Transaction Summary
========================================================================================================================
Install       1 Package(s)

Total download size: 396 k
Installed size: 2.8 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : btrfs-progs-0.20-1.8.git7854c8b.el6.x86_64                                                           1/1 
  Verifying  : btrfs-progs-0.20-1.8.git7854c8b.el6.x86_64                                                           1/1 

Installed:
  btrfs-progs.x86_64 0:0.20-1.8.git7854c8b.el6                                                                          

Complete!
[root@dal66a ~]# mkfs -t btrfs -d raid10 -m raid10 /dev/sdb1 /dev/sdc1 /dev/sdd1 /dev/sde1 -f
failed to open /dev/fd0: No such device or address

WARNING! - Btrfs v0.20-rc1 IS EXPERIMENTAL
WARNING! - see http://btrfs.wiki.kernel.org before using

adding device /dev/sdc1 id 2
adding device /dev/sdd1 id 3
adding device /dev/sde1 id 4
fs created label (null) on /dev/sdb1
	nodesize 4096 leafsize 4096 sectorsize 4096 size 127.99GB
Btrfs v0.20-rc1

The -f option is not needed. The only reason why I had to specify the -f was because I tried to create a btrfs file system earlier with just 2 drives in a mirrored and striped configuration..

Pass the -V option to determine the version of make.btrfs.

[root@dal66a ~]# mkfs.btrfs -V
mkfs.btrfs, part of Btrfs v0.20-rc1

If you take out all the comments and blank lines, we are only dealing with 7 parameters for the GoldenGate response file. You can run the following egrep command with each release of GoldenGate to see if Oracle introduces new parameters to their response files.

The trick to automating a GoldenGate installation and customizing the installation process is to embed place holders into the template GoldenGate file. During the automation time, you simply leverage Unix tools like sed and awk to replace the placeholder values with the custom values.

[oracle@den01 ~]$ egrep -v "^#|^$" oggcore.rsp 
oracle.install.responseFileVersion=/oracle/install/rspfmt_ogginstall_response_schema_v12_1_2
INSTALL_OPTION=ORA12c
SOFTWARE_LOCATION=XXX_GGATE_SOFTWARE_LOCATION
START_MANAGER=false
MANAGER_PORT=
DATABASE_LOCATION=
INVENTORY_LOCATION=XXX_ORAINVENTORY_LOCATION
UNIX_GROUP_NAME=XXX_UNIX_GROUP_NAME

As you can see, we have embedded three place holders:
* for the Software Location (GoldenGate Home)
* OraInventory location
* the unix group name.

The best way to customize and automate a GoldenGate installation is to replace these parameters at runtime and replace them with your values. Also notice that I started all of my variables with an XXX_ so that I can easily detect what the custom parameters are.


In this blog post, let’s look at performing a silent installation of GoldenGate (GG). Since GG 12c, we no longer do a tar extract of the software. Now, we do an OUI installation like all Oracle software. For those, who miss the ease of un-tarring a GG home, we can look at doing silent installs or even cloning the GG Home. Let’s first look at performing a silent installation:

cd $SOFTWARE_LOCATION
./runInstaller -responseFile ${RESPONSE_FILE_LOCATION} -silent -nowelcome

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 28012 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 3964 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-10-28_07-20-45PM. Please wait ...rac01:/home/oracle/soft/fbo_ggs_Linux_x64_shiphome/Disk1
DENPROD1 > You can find the log of this install session at:
 /u01/app/oraInventory/logs/installActions2014-10-28_07-20-45PM.log

rac01:/home/oracle/soft/fbo_ggs_Linux_x64_shiphome/Disk1
DENPROD1 > The installation of Oracle GoldenGate Core was successful.
Please check '/u01/app/oraInventory/logs/silentInstall2014-10-28_07-20-45PM.log' for more details.
Successfully Setup Software.

To confirm that everything was done correctly, you should review the specified log file: /u01/app/oraInventory/logs/installActions2014-10-28_07-20-45PM.log

This is an automated script so the response file location is set in the environment variable in a configuration file. The response file in this example is called oggcore.rsp and looks like this:

DENPROD1 > cat oggcore.rsp 

####################################################################
## Copyright(c) Oracle Corporation 2014. All rights reserved.     ##
##                                                                ##
## Specify values for the variables listed below to customize     ##
## your installation.                                             ##
##                                                                ##
## Each variable is associated with a comment. The comment        ##
## can help to populate the variables with the appropriate        ##
## values.                                                        ##
##                                                                ##
## IMPORTANT NOTE: This file should be secured to have read       ##
## permission only by the oracle user or an administrator who     ##
## own this installation to protect any sensitive input values.   ##
##                                                                ##
####################################################################

#-------------------------------------------------------------------------------
# Do not change the following system generated value. 
#-------------------------------------------------------------------------------
oracle.install.responseFileVersion=/oracle/install/rspfmt_ogginstall_response_schema_v12_1_2


################################################################################
##                                                                            ##
## Oracle GoldenGate installation option and details                          ##
##                                                                            ##
################################################################################

#-------------------------------------------------------------------------------
# Specify the installation option.
# Specify ORA12c for installing Oracle GoldenGate for Oracle Database 12c and
#         ORA11g for installing Oracle GoldenGate for Oracle Database 11g 
#-------------------------------------------------------------------------------
INSTALL_OPTION=ORA12c

#-------------------------------------------------------------------------------
# Specify a location to install Oracle GoldenGate
#-------------------------------------------------------------------------------
SOFTWARE_LOCATION=/u01/app/oracle/product/12.1.2/oggcore_1

#-------------------------------------------------------------------------------
# Specify true to start the manager after installation. 
#-------------------------------------------------------------------------------
START_MANAGER=false

#-------------------------------------------------------------------------------
# Specify a free port within the valid range for the manager process.
# Required only if START_MANAGER is true.
#-------------------------------------------------------------------------------
MANAGER_PORT=

#-------------------------------------------------------------------------------
# Specify the location of the Oracle Database.
# Required only if START_MANAGER is true.
#-------------------------------------------------------------------------------
DATABASE_LOCATION=


################################################################################
##                                                                            ##
## Specify details to Create inventory for Oracle installs                    ##
## Required only for the first Oracle product install on a system.            ##
##                                                                            ##
################################################################################

#-------------------------------------------------------------------------------
# Specify the location which holds the install inventory files.
# This is an optional parameter if installing on
# Windows based Operating System.
#-------------------------------------------------------------------------------
INVENTORY_LOCATION=/u01/app/oraInventory

#-------------------------------------------------------------------------------
# Unix group to be set for the inventory directory.  
# This parameter is not applicable if installing on
# Windows based Operating System.
#-------------------------------------------------------------------------------
UNIX_GROUP_NAME=oinstall

Likewise, I can detach and GoldenGate home like I can detach any Oracle Database or Grid Infrastructure Home:

rac01:/u01/app/oracle/product/12.1.2/oggcore_1/oui/bin
 > cat detachHome.sh 
#!/bin/sh
OHOME=/u01/app/oracle/product/12.1.2/oggcore_1
OHOMENAME=OraHome1
CUR_DIR=`pwd`
cd $OHOME/oui/bin
./runInstaller -detachhome ORACLE_HOME=$OHOME ORACLE_HOME_NAME=$OHOMENAME $* 
cd $CUR_DIR

rac01:/u01/app/oracle/product/12.1.2/oggcore_1/oui/bin
 > ./detachHome.sh 
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 3966 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'DetachHome' was successful.

The detachHome.sh shell script is an Oracle supplied shell script that resides in the GG_HOME/oui/bin directory. Let’s see how we would go about cloning this GG Home. To clone the GG Home, we can leverage the runInstaller.sh script that is also located in the GG Home/oui/bin directory. The invocation of the shell script is no different than the way we used to do any other oracle software. In the GG Home, we do not have a clone.pl script that we use to clone Oracle Grid Infrastructure and Oracle Oracle Database Software. We have to leverage the techniques that we used to back in Oracle Database 10g days with the runInstaller.sh script:

./runInstaller.sh -silent -clone ORACLE_BASE="/u01/app/oracle" \
ORACLE_HOME="/u01/app/oracle/product/12.1.2/oggcore_1" \
ORACLE_HOME_NAME="GG12c"
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 3961 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-10-28_07-36-29PM. Please wait ...rac01:/u01/app/oracle/product/12.1.2/oggcore_1/oui/bin
DENPROD1 > Oracle Universal Installer, Version 11.2.0.3.0 Production
Copyright (C) 1999, 2011, Oracle. All rights reserved.

You can find the log of this install session at:
 /u01/app/oraInventory/logs/cloneActions2014-10-28_07-36-29PM.log
.................................................................................................... 100% Done.



Installation in progress (Tuesday, October 28, 2014 7:36:36 PM CDT)
..........................................................................                                                      72% Done.
Install successful

Linking in progress (Tuesday, October 28, 2014 7:36:38 PM CDT)
Link successful

Setup in progress (Tuesday, October 28, 2014 7:36:38 PM CDT)
...........                                                     100% Done.
Setup successful

End of install phases.(Tuesday, October 28, 2014 7:36:59 PM CDT)
The cloning of GG12c was successful.
Please check '/u01/app/oraInventory/logs/cloneActions2014-10-28_07-36-29PM.log' for more details.

Of course, you should peruse the log file /u01/app/oraInventory/logs/cloneActions2014-10-28_07-36-29PM.log to make sure that cloning process did not spit out any errors.


As of Oracle 12.1.0.2, with the Oracle Grid Infrastructure Typical Installation, the OUI will automatically create the Oracle GI Management Repository (GIMR). The Oracle GI Management Repository will be housed in the same location of where the first ASM disk group is created .. in my case, where the OCR and Vote disks will reside. It even creates the container database for it.

PastedGraphic 1


In this example, we are setting up automatic snapshot maintenance for the backup01 share. We are instructing the ZFS Storage Appliance to perform a daily snapshot of the backup01 share on a nightly basis at 1AM. We are also instructing the ZFS Storage Appliance to keep 21 days of rolling snapshots.

zfs1:> shares
zfs1:shares (zpool1)> select default
zfs1:shares (zpool1) default> select backup01
zfs1:shares (zpool1) default/backup01> snapshots
zfs1:shares (zpool1) default/backup01 snapshots> automatic

zfs1:shares (zpool1) default/backup01 snapshots automatic> create
zfs1:shares (zpool1) default/backup01 snapshots automatic (uncommitted)> show
Properties:
                     frequency = (unset)
                           day = (unset)
                          hour = (unset)
                        minute = (unset)
                          keep = 0

zfs1:shares (zpool1) default/backup01 snapshots automatic (uncommitted)> set frequency=day
                     frequency = day (uncommitted)
zfs1:shares (zpool1) default/backup01 snapshots automatic (uncommitted)> set hour=03
                          hour = 01 (uncommitted)
zfs1:shares (zpool1) default/backup01 snapshots automatic (uncommitted)> set minute=00
                        minute = 00 (uncommitted)
zfs1:shares (zpool1) default/backup01 snapshots automatic (uncommitted)> set keep=21
                          keep = 21 (uncommitted)
zfs1:shares (zpool1) default/backup01 snapshots automatic (uncommitted)> get
                     frequency = day (uncommitted)
                           day = (unset)
                          hour = 01 (uncommitted)
                        minute = 00 (uncommitted)
                          keep = 21 (uncommitted)
zfs1:shares (zpool1) default/backup01 snapshots automatic (uncommitted)> commit
zfs1:shares (zpool1) default/backup01 snapshots automatic> show
Properties:
                       convert = true

Automatics:

NAME                 FREQUENCY            DAY                  HH:MM KEEP
automatic-000        day                  -                    03:00   21

zfs1:shares (zpool1) default/backup01 snapshots automatic> done
zfs1:shares (zpool1) default/backup01 snapshots> show
Snapshots:
                       oct2014
                      sept2014

Children:
                        automatic => Configure automatic snapshots

# yum install oracle-rdbms-server-12cR1-preinstall
Loaded plugins: security
public_ol6_UEKR3_latest                                                                                          | 1.2 kB     00:00
public_ol6_latest                                                                                                | 1.4 kB     00:00
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package oracle-rdbms-server-12cR1-preinstall.x86_64 0:1.0-11.el6 will be installed
--> Processing Dependency: xorg-x11-utils for package: oracle-rdbms-server-12cR1-preinstall-1.0-11.el6.x86_64
--> Processing Dependency: gcc-c++ for package: oracle-rdbms-server-12cR1-preinstall-1.0-11.el6.x86_64
--> Processing Dependency: compat-libcap1 for package: oracle-rdbms-server-12cR1-preinstall-1.0-11.el6.x86_64
--> Processing Dependency: ksh for package: oracle-rdbms-server-12cR1-preinstall-1.0-11.el6.x86_64
--> Processing Dependency: libaio-devel for package: oracle-rdbms-server-12cR1-preinstall-1.0-11.el6.x86_64
--> Processing Dependency: xorg-x11-xauth for package: oracle-rdbms-server-12cR1-preinstall-1.0-11.el6.x86_64
--> Processing Dependency: compat-libstdc++-33 for package: oracle-rdbms-server-12cR1-preinstall-1.0-11.el6.x86_64
--> Processing Dependency: libstdc++-devel for package: oracle-rdbms-server-12cR1-preinstall-1.0-11.el6.x86_64
--> Running transaction check
---> Package compat-libcap1.x86_64 0:1.10-1 will be installed
---> Package compat-libstdc++-33.x86_64 0:3.2.3-69.el6 will be installed
---> Package gcc-c++.x86_64 0:4.4.7-4.el6 will be installed
---> Package ksh.x86_64 0:20120801-10.el6_5.9 will be installed
---> Package libaio-devel.x86_64 0:0.3.107-10.el6 will be installed
---> Package libstdc++-devel.x86_64 0:4.4.7-4.el6 will be installed
---> Package xorg-x11-utils.x86_64 0:7.5-6.el6 will be installed
--> Processing Dependency: libXxf86misc.so.1()(64bit) for package: xorg-x11-utils-7.5-6.el6.x86_64
--> Processing Dependency: libdmx.so.1()(64bit) for package: xorg-x11-utils-7.5-6.el6.x86_64
--> Processing Dependency: libXxf86dga.so.1()(64bit) for package: xorg-x11-utils-7.5-6.el6.x86_64
---> Package xorg-x11-xauth.x86_64 1:1.0.2-7.1.el6 will be installed
--> Processing Dependency: libXmuu.so.1()(64bit) for package: 1:xorg-x11-xauth-1.0.2-7.1.el6.x86_64
--> Running transaction check
---> Package libXmu.x86_64 0:1.1.1-2.el6 will be installed
---> Package libXxf86dga.x86_64 0:1.1.3-2.el6 will be installed
---> Package libXxf86misc.x86_64 0:1.0.3-4.el6 will be installed
---> Package libdmx.x86_64 0:1.1.2-2.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================
 Package                                         Arch              Version                           Repository                    Size
========================================================================================================================================
Installing:
 oracle-rdbms-server-12cR1-preinstall            x86_64            1.0-11.el6                        public_ol6_latest             15 k
Installing for dependencies:
 compat-libcap1                                  x86_64            1.10-1                            public_ol6_latest             17 k
 compat-libstdc++-33                             x86_64            3.2.3-69.el6                      public_ol6_latest            183 k
 gcc-c++                                         x86_64            4.4.7-4.el6                       public_ol6_latest            4.7 M
 ksh                                             x86_64            20120801-10.el6_5.9               public_ol6_latest            757 k
 libXmu                                          x86_64            1.1.1-2.el6                       public_ol6_latest             65 k
 libXxf86dga                                     x86_64            1.1.3-2.el6                       public_ol6_latest             24 k
 libXxf86misc                                    x86_64            1.0.3-4.el6                       public_ol6_latest             17 k
 libaio-devel                                    x86_64            0.3.107-10.el6                    public_ol6_latest             13 k
 libdmx                                          x86_64            1.1.2-2.el6                       public_ol6_latest             20 k
 libstdc++-devel                                 x86_64            4.4.7-4.el6                       public_ol6_latest            1.6 M
 xorg-x11-utils                                  x86_64            7.5-6.el6                         public_ol6_latest             94 k
 xorg-x11-xauth                                  x86_64            1:1.0.2-7.1.el6                   public_ol6_latest             34 k

Transaction Summary
========================================================================================================================================
Install      13 Package(s)

Total download size: 7.5 M
Installed size: 23 M
Is this ok [y/N]: y
Downloading Packages:
(1/13): compat-libcap1-1.10-1.x86_64.rpm                                                                         |  17 kB     00:00
(2/13): compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm                                                              | 183 kB     00:00
(3/13): gcc-c++-4.4.7-4.el6.x86_64.rpm                                                                           | 4.7 MB     00:00
(4/13): ksh-20120801-10.el6_5.9.x86_64.rpm                                                                       | 757 kB     00:00
(5/13): libXmu-1.1.1-2.el6.x86_64.rpm                                                                            |  65 kB     00:00
(6/13): libXxf86dga-1.1.3-2.el6.x86_64.rpm                                                                       |  24 kB     00:00
(7/13): libXxf86misc-1.0.3-4.el6.x86_64.rpm                                                                      |  17 kB     00:00
(8/13): libaio-devel-0.3.107-10.el6.x86_64.rpm                                                                   |  13 kB     00:00
(9/13): libdmx-1.1.2-2.el6.x86_64.rpm                                                                            |  20 kB     00:00
(10/13): libstdc++-devel-4.4.7-4.el6.x86_64.rpm                                                                  | 1.6 MB     00:00
(11/13): oracle-rdbms-server-12cR1-preinstall-1.0-11.el6.x86_64.rpm                                              |  15 kB     00:00
(12/13): xorg-x11-utils-7.5-6.el6.x86_64.rpm                                                                     |  94 kB     00:00
(13/13): xorg-x11-xauth-1.0.2-7.1.el6.x86_64.rpm                                                                 |  34 kB     00:00
----------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                   1.9 MB/s | 7.5 MB     00:03
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : libstdc++-devel-4.4.7-4.el6.x86_64                                                                                  1/13
  Installing : gcc-c++-4.4.7-4.el6.x86_64                                                                                          2/13
  Installing : libXmu-1.1.1-2.el6.x86_64                                                                                           3/13
  Installing : 1:xorg-x11-xauth-1.0.2-7.1.el6.x86_64                                                                               4/13
  Installing : libdmx-1.1.2-2.el6.x86_64                                                                                           5/13
  Installing : ksh-20120801-10.el6_5.9.x86_64                                                                                      6/13
  Installing : libXxf86dga-1.1.3-2.el6.x86_64                                                                                      7/13
  Installing : compat-libstdc++-33-3.2.3-69.el6.x86_64                                                                             8/13
  Installing : libXxf86misc-1.0.3-4.el6.x86_64                                                                                     9/13
  Installing : xorg-x11-utils-7.5-6.el6.x86_64                                                                                    10/13
  Installing : libaio-devel-0.3.107-10.el6.x86_64                                                                                 11/13
  Installing : compat-libcap1-1.10-1.x86_64                                                                                       12/13
  Installing : oracle-rdbms-server-12cR1-preinstall-1.0-11.el6.x86_64                                                             13/13
  Verifying  : compat-libcap1-1.10-1.x86_64                                                                                        1/13
  Verifying  : libstdc++-devel-4.4.7-4.el6.x86_64                                                                                  2/13
  Verifying  : xorg-x11-utils-7.5-6.el6.x86_64                                                                                     3/13
  Verifying  : oracle-rdbms-server-12cR1-preinstall-1.0-11.el6.x86_64                                                              4/13
  Verifying  : libaio-devel-0.3.107-10.el6.x86_64                                                                                  5/13
  Verifying  : libXxf86misc-1.0.3-4.el6.x86_64                                                                                     6/13
  Verifying  : compat-libstdc++-33-3.2.3-69.el6.x86_64                                                                             7/13
  Verifying  : libXxf86dga-1.1.3-2.el6.x86_64                                                                                      8/13
  Verifying  : 1:xorg-x11-xauth-1.0.2-7.1.el6.x86_64                                                                               9/13
  Verifying  : ksh-20120801-10.el6_5.9.x86_64                                                                                     10/13
  Verifying  : libdmx-1.1.2-2.el6.x86_64                                                                                          11/13
  Verifying  : gcc-c++-4.4.7-4.el6.x86_64                                                                                         12/13
  Verifying  : libXmu-1.1.1-2.el6.x86_64                                                                                          13/13

Installed:
  oracle-rdbms-server-12cR1-preinstall.x86_64 0:1.0-11.el6

Dependency Installed:
  compat-libcap1.x86_64 0:1.10-1             compat-libstdc++-33.x86_64 0:3.2.3-69.el6       gcc-c++.x86_64 0:4.4.7-4.el6
  ksh.x86_64 0:20120801-10.el6_5.9           libXmu.x86_64 0:1.1.1-2.el6                     libXxf86dga.x86_64 0:1.1.3-2.el6
  libXxf86misc.x86_64 0:1.0.3-4.el6          libaio-devel.x86_64 0:0.3.107-10.el6            libdmx.x86_64 0:1.1.2-2.el6
  libstdc++-devel.x86_64 0:4.4.7-4.el6       xorg-x11-utils.x86_64 0:7.5-6.el6               xorg-x11-xauth.x86_64 1:1.0.2-7.1.el6

Complete!
#

Oracle PreInstall RPM for Oracle Linux is one the biggest benefits of adopting Oracle Linux. With a single command, you can pre-configure the Oracle Linux environment for OEM 12c Agent, EBS R12, and Oracle Database 11gR2/12c installations. Not only does Oracle configure the Linux environment, but many of the best practices are incorporated in the process.

Oracle provides the PreInstall RPMs for the database on different channels from the EBS R12 or OEM 12c Agent PreInstall RPMs. For EBS and OEM 12c Agent PreInstall RPMs, you can download the PreInstall RPMs from the addons channel from the public-yum repository. Oracle provides a separate RPM for each release of OEM 12c.

http://public-yum.oracle.com/repo/OracleLinux/OL6/addons/x86_64/

2014 10 12 11 41 25

For Oracle Database PreInstall RPMs for Oracle Database 11g Release 2 and Oracle Database 12c Release 1, you can download them from the RPM from the latest channel from the public-yum repository. You will have to scroll down quite a bit; the RPMs that start with capital letters are listed above RPMs that have lower case letters.

http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64/

2014 10 12 11 46 06

The location of the source RPM (.src.rpm) can be especially important for Red Hat customers who want to leverage all the hard work that Oracle has put in. Red Hat customers can download the source RPM and build their own RPM package that will work on Red Hat with the rpmbuild command.


First, download the software from OTN and unzip the contents of the zip file. Change your directory to the Disk1 subdirectory and launch the GUI installer by invoking the runInstaller script:

$ unzip 121210_fbo_ggs_Linux_x64_shiphome.zip
$ cd fbo_ggs_Linux_x64_shiphome/Disk1
$ ./runInstaller

2014 10 07 11 20 11

Choose wether you want to install GoldenGate for Oracle Database 12c or Oracle Database 11g. In our example, we are choosing to install GoldenGate for Oracle Database 12c

2014 10 07 11 22 59

Specify the location for the GoldenGate software to be installed. Make sure the Start Manager checkbox is not checked. Click on the Next button to continue.

2014 10 07 11 23 59

On the summary screen, review the options and installation details. We can create a response file so that we can perform subsequent GoldenGate installations in a silent mode (from the command line interface).

2014 10 07 11 28 14

By default, a response file called oggcore.rsp will be saved in the home directory for Oracle. Once the response file is created, we can proceed with the installation by clicking on the Install button. You can view the progress of the installation. When the installation completes, you will see the Finish screen.

2014 10 07 11 31 09

Congratulations. We have successfully installed GoldenGate 12c. Click on the Close button to clear the screen.

Now that we’ve installed GoldenGate on the primary source database server, it is time to install GoldenGate on the target database server.