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.


Oracle Database 12c Release 1 Patchset 1 is the terminal release for Oracle 12.1. As of Oracle OpenWorld 2014, the announcement was made that 12.1.0.2 will be the terminal release for Oracle Database 12c Release 1. Oracle also notified customers that the 12c Release 2 (12.2) will not be available until the first quarter of 2016. With that in mind, customers are encouraged to jump on the terminal release of Oracle Database 12 release 1.

In this blog post, I will focus on installing and configuring Oracle Database 12c Release 1 Patchset 1.

2014 10 04 14 44 26

Select the option that you want to install and click on Next. In my example, I am selecting to install and configure Oracle Grid Infrastructure for a standalone server.

2014 10 04 14 49 16

Select the languages that you want to install and click on the Next button

2014 10 04 14 51 29

In the Create ASM Disk Group screen, we will create a disk group called DATA. We will also:
* Click on the External Redundancy option
* Change the Allocation Unit size from 1MB to 4MB
* Select all the disks that make up the DATA Disk Group. ORCL:DATA1 to ORCL:DATA4

When we customized all the options, we will click on the Next button

2014 10 04 16 20 49

Enter the password for the SYS and ASMSNMP accounts. In our example, we will choose to enter the same password for both of the accounts. Click on the Next button to continue.

2014 10 04 16 22 09
The password that was entered did not conform to the Oracle recommended standards. We will choose to continue by clicking on the Yes button.

2014 10 04 16 23 53

We do not have an OEM 12c Cloud Control environment setup yet so we will continue by clicking on the Next button.
2014 10 04 16 27 29

Choose the OS Groups for the ASM administrator, ASM DBA, and ASM Operator. In our example, we chose to stick with one standard group since we do not have a separation of roles and responsibilities between the DBA and Cluster administrator.

2014 10 04 16 29 50
Click on Yes to continue

2014 10 04 16 33 04

If this is a fresh install, you will want to create the directories for $ORACLE_BASE on the /u01 file system and change the permissions to oracle:dba:

[root@vna01 u01]# mkdir -p /u01/app/oracle
[root@vna01 u01]# chown -R oracle:dba /u01/app

Click on Next to continue

2014 10 04 16 35 44

Set the path for the oraInventory location. The default location is good for most customers. Click on Next to continue.

2014 10 04 16 38 45

The default location for sudo is in /usr/bin directory. For this screen, you will want to change the location of sudo to be /usr/bin/sudo instead of /usr/local/bin/sudo.

If you are new to the world of sudo, you can make a simple change in the /etc/sudoers file and add the following line:

oracle	ALL=(ALL) 	ALL

This example is not encouraged. Most companies with strict sudoers control will list just the commands that the oracle user can execute on behalf of root.
Click on the next button to continue.

2014 10 04 16 42 34

We seem to have an issue with a kernel parameter called panic_on_oops. This parameter is not set in the /etc/sysctl.conf parameter file. For now, we will choose to ignore this warning and continue with the installation. Let’s continue by clicking on the Ignore All checkbox on the top right corner of the window; then click on the Next button to continue.

2014 10 04 16 45 23

We will see an warning message indicating that we’ve chosen to ignore one or more of the prerequisites. Click on the Yes button to continue.

2014 10 04 16 46 20

Finally, we arrive at the Summary screen. Before we click on the Installation button, we will choose the option to save the response file by clicking on the Save Response File button. Carefully review the options that you have chosen and click on the Install button.

2014 10 04 16 49 03

We can watch the installation progress. You can click on the Details button if you want to see some of the detailed logs of what is happening.

2014 10 04 16 54 20

Once the installation is complete, you will be prompted to auto execute the configuration script. Click on Yes to continue to execute orainstRoot.sh and root.sh as the root user or as the sudo privileged user.

2014 10 04 17 04 09

Congrats! We have successfully installed Oracle 12c Release 1 Patchset 1 Grid Infrastructure. Next, we will proceed with installing and configuring the Oracle 12c Release 1 Patchset 1 Database software.

Install Oracle Database Software

[oracle@vna01 database]$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 500 MB.   Actual 29712 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 31992 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-10-05_03-07-31AM. Please wait ...[oracle@vna01 database]$ 

2014 10 05 03 10 11

Uncheck the option for receiving security updates via Oracle Support
Click on the Next button to continue

2014 10 05 03 12 56
Click on the Yes button and confirm that you have chosen to remain uninformed of critical security updates

2014 10 05 03 14 56
Click on the Install database software only option and click on the Next button to continue. We will create a database later with the Database Configuration Assistant (dbca).

2014 10 05 03 16 27
Click on the Single instance database installation option and click on Next button to continue

2014 10 05 03 17 43
Select the languages that you want to install and click on the Next button to continue

2014 10 05 03 20 46
At the initial release of Oracle Database 12c Release 1 Patchset 1, only the Enterprise Edition was available. Standard Edition or Standard Edition One is not available as an option yet.

2014 10 05 03 24 09
Accept the default location for $ORACLE_BASE and $ORACLE_HOME since we have already installed the Grid Infrastructure and click on the Next button to continue.

2014 10 05 03 26 47
Select the OS groups for OSDBA, OSOPER, OSBACKUPDBA, OSDGDBA and OSKMDBA and click on the Next button to continue.

2014 10 05 03 31 39
We are at the Summary screen. Before we click on the Install button, we will choose the option to save the response file by clicking on the Save Response File button. Carefully review the options that you have chosen and click on the Install button.

2014 10 05 03 34 06

We can watch the installation progress. You can click on the Details button if you want to see some of the detailed logs of what is happening.

2014 10 05 03 36 50
As the root account, execute root.sh from the Database Oracle Home.

[oracle@vna01 dbhome_1]$ sudo ./root.sh
[sudo] password for oracle: 
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/12.1.0/dbhome_1

Enter the full pathname of the local bin directory: [/usr/local/bin]: 
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.

After root.sh is successfully executed, go back to the Execute Configuration Script window and click on the OK button.

2014 10 05 03 43 37
Click on the Close button to complete the database software installation

Create the Fast Recovery Area (FRA)

Launch the ASM Configuration Assistant (asmca). Before we launch asmca, we need to source the oraenv file and setup the Linux environment for ASM.

[oracle@vna01 Desktop]$ . oraenv
ORACLE_SID = [oracle] ? +ASM
The Oracle base has been set to /u01/app/oracle
[oracle@vna01 Desktop]$ asmca

2014 10 05 03 53 42
Click on the Create button to create the FRA disk group.

2014 10 05 03 56 01

From the Create Disk Group screen, enter FRA for the Disk Group Name and select the option for the External redundancy. Click on the Show Advanced Options and change the Allocation Unit Size (MB) from 1MB to 4MB.

2014 10 05 04 01 08
If we know for a fact that only 12.1 databases will ever go on this ASM instance, we can advance the Database Compatibility and ADVM Compatibility to 12.1.0.0.0 also. We will click on the OK button to complete the FRA disk group creation.

2014 10 05 04 02 36
While the disk group is being created, you will see the above progress window.

2014 10 05 04 03 02
We successfully created the FRA disk group. Click on the Close button to exit the screen and click on the Exit button to cleanly exit asmca.

Create a Database with dbca (using an existing Oracle seeded database template)

We need to launch the Database Configuration Assistant (dbca). Before we launch dbca, we need to source the oraenv file and setup the Oracle environment.

[oracle@vna01 dbhome_1]$ pwd
/u01/app/oracle/product/12.1.0/dbhome_1
[oracle@vna01 dbhome_1]$ . oraenv
ORACLE_SID = [oracle] ? db
ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/12.1.0/dbhome_1
The Oracle base has been set to /u01/app/oracle
[oracle@vna01 dbhome_1]$ 
[oracle@vna01 dbhome_1]$ dbca

2014 10 05 03 47 39

Select the Create Database option and click on the Next button to continue

2014 10 05 04 13 42
Enter the database name and select the disk group location for the database files and fast recovery area. Choose the database character set for the database and enter the administrator password. You can choose the create the database as a Container Database (default). You can enter the name for the pluggable database name. Click on the Next button to continue.

2014 10 05 04 15 12
We receive a warning message because the administrative password does not conform to the recommended Oracle standards. Click on the Yes button to continue.

2014 10 05 04 17 57
From the Summary screen, review the options that were chosen and click on the Finish button.

2014 10 05 04 19 28
We can review the database creation progress. In the meanwhile, we can also view the Activity Log or the Alert Log.

Create a Customized Database with dbca Advanced Mode

Coming soon