Requirements for Installing Oracle Database 12.1 on RHEL6

Required OS Components (per Release Notes, and Install Guide)

Some of the Install Guide requirements will already be present from the "default-RPMs" foundation of Linux that you started with:

1. binutils-2.20.51.0.2-5.11.el6 (x86_64)
2. glibc-2.12-1.7.el6 (x86_64)
3. libgcc-4.4.4-13.el6 (x86_64)
4. libstdc++-4.4.4-13.el6 (x86_64)
5. libaio-0.3.107-10.el6 (x86_64)
6. libXext-1.1 (x86_64)
7. libXtst-1.0.99.2 (x86_64)
8. libX11-1.3 (x86_64)
9. libXau-1.0.5 (x86_64)
10. libxcb-1.5 (x86_64)
11. libXi-1.3 (x86_64)
12. make-3.81-19.el6
13. sysstat-9.0.4-11.el6 (x86_64)

c.) The remaining Install Guide requirements will have to be installed:

1. compat-libcap1-1.10-1 (x86_64)
2. compat-libstdc++-33-3.2.3-69.el6 (x86_64)
3. gcc-4.4.4-13.el6 (x86_64)
4. gcc-c++-4.4.4-13.el6 (x86_64)
5. glibc-devel-2.12-1.7.el6 (x86_64)
6. ksh <== any version of ksh is acceptable
7. libstdc++-devel-4.4.4-13.el6 (x86_64)
8. libaio-devel-0.3.107-10.el6(x86_64)

 Below command to view the exiting RPM's in Linux machine:


rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | 7.libstdc
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | libstdc
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libstdc

If not available you can install using YUM.

# yum install libcap.so.1

how to check the availability of rpm files:

# yum list | grep libcap

---------------------------------------------------------------------------------------------------

1. Below are the Minmum Recommended Kernel Parameter settings required for Database Software Installation. Modify your kernel settings in /etc/sysctl.conf as follows.

NOTE: If the current value for any parameter is higher than the value listed, do not change the value of that parameter.

kernel.shmall = 1/2 of physical memory in pages, this will be the value 2097152. See Note 301830.1 for more information.
kernel.shmmax = 1/2 of physical memory in bytes. This would be the value 2147483648 for a system with 4GB of physical RAM.

For 32-bit Linux Systems :
Minimum: 536870912 (512 MB)
Maximum: A value that is 1 byte less than 4 GB, or 4294967295
Recommended: More than half the physical memory

For 64-bit Linux Systems :
Minimum: 536870912 (512 MB)
Maximum: A value that is 1 byte less than the physical memory
Recommended: More than half the physical memory

See My Oracle Support Note 567506.1 for additional information about configuring shmmax.

kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
fs.aio-max-nr = 1048576

Note: This value limits concurrent outstanding requests and should be set to avoid I/O subsystem failures.

net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

2. To activate these new settings into the running kernel space, run the "sysctl -p" command as root.

3. Set Shell Limits for the oracle User. Assuming that the "oracle" Unix user will perform the installation, do the following:

a.) Add the following settings to /etc/security/limits.conf configuration file for the installation owner.

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 10240

NOTE: When the limits.conf file is changed, these changes take effect immediately. However, if the oracle users are logged in, then these changes do not take effect until you log these users out and log them back in. You must do this before you use these accounts for installation.

------------------------------------------------------------------------------------------------

Oracle  Database 12c Software Installation:

--------------------------------------------------

cd /opt/app/oracle/INSTALL/database

./runInstaller -showProgress -waitforcompletion -silent -noconfig -debug -force -responseFile /opt/app/oracle/INSTALL/database/response/db_install.rsp

vi /opt/app/oracle/INSTALL/database/response/db_install.rsp

#-------------------------------------------------------------------------------

# Do not change the following system generated value.

#-------------------------------------------------------------------------------

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.1.0

oracle.install.option=INSTALL_DB_SWONLY

ORACLE_HOSTNAME=qpass-dev-oracle12c-1.sea2.qpass.net

UNIX_GROUP_NAME=dba

INVENTORY_LOCATION=/opt/app/oraInventory

ORACLE_HOME=/opt/app/oracle/product/12.1.0

ORACLE_BASE=/opt/app/oracle

oracle.install.db.InstallEdition=EE

DECLINE_SECURITY_UPDATES=true

oracle.installer.autoupdates.option=SKIP_UPDATES

oracle.install.db.DBA_GROUP=dba

oracle.install.db.OPER_GROUP=dba

oracle.install.db.BACKUPDBA_GROUP=dba

oracle.install.db.DGDBA_GROUP=dba

oracle.install.db.KMDBA_GROUP=dba

----------------------------------------------------------------------------------

Oracle  ASM (GRID) 12c Software Installation:

--------------------------------------------------------

cd /opt/app/oracle/INSTALL/grid

./runInstaller -showProgress -waitforcompletion -silent -noconfig -debug -force -responseFile /opt/app/oracle/INSTALL/grid/response/grid_install.rsp

Sample Response file:

vi /opt/app/oracle/INSTALL/grid/response/grid_install.rsp

###############################################################################

## Copyright(c) Oracle Corporation 1998,2013. 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 contains plain text passwords and               ##

## should be secured to have read permission only by oracle user             ##

## or db administrator who owns this installation.                           ##

##                                                                           ##

###############################################################################

###############################################################################

##                                                                           ##

## Instructions to fill this response file                                   ##

## To install and configure 'Grid Infrastructure for Cluster'                ##

##  - Fill out sections A,B,C,D,E,F and G                                    ##

##  - Fill out section G if OCR and voting disk should be placed on ASM      ##

##                                                                           ##

## To install and configure 'Grid Infrastructure for Standalone server'      ##

##  - Fill out sections A,B and G                                            ##

##                                                                           ##

## To install software for 'Grid Infrastructure'                             ##

##  - Fill out sections A,B and C                                            ##

##                                                                           ##

## To upgrade clusterware and/or Automatic storage management of earlier     ##

## releases                                                                  ##

##  - Fill out sections A,B,C,D and H                                        ##

##                                                                           ##

###############################################################################

#------------------------------------------------------------------------------

# Do not change the following system generated value.

#------------------------------------------------------------------------------

oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v12.1.0

###############################################################################

#                                                                             #

#                          SECTION A - BASIC                                  #

#                                                                             #

###############################################################################

#-------------------------------------------------------------------------------

# Specify the hostname of the system as set during the install. It can be used

# to force the installation to use an alternative hostname rather than using the

# first hostname found on the system. (e.g., for systems with multiple hostnames

# and network interfaces)

#-------------------------------------------------------------------------------

ORACLE_HOSTNAME=qpass-dev-oracle12c-1.sea2.qpass.net

#-------------------------------------------------------------------------------

# Specify the location which holds the inventory files.

# This is an optional parameter if installing on

# Windows based Operating System.

#-------------------------------------------------------------------------------

INVENTORY_LOCATION=/opt/app/oracle/oraInventory

#-------------------------------------------------------------------------------

# Specify the languages in which the components will be installed.

#

# en   : English                  ja   : Japanese

# fr   : French                   ko   : Korean

# ar   : Arabic                   es   : Latin American Spanish

# bn   : Bengali                  lv   : Latvian

# pt_BR: Brazilian Portuguese     lt   : Lithuanian

# bg   : Bulgarian                ms   : Malay

# fr_CA: Canadian French          es_MX: Mexican Spanish

# ca   : Catalan                  no   : Norwegian

# hr   : Croatian                 pl   : Polish

# cs   : Czech                    pt   : Portuguese

# da   : Danish                   ro   : Romanian

# nl   : Dutch                    ru   : Russian

# ar_EG: Egyptian                 zh_CN: Simplified Chinese

# en_GB: English (Great Britain)  sk   : Slovak

# et   : Estonian                 sl   : Slovenian

# fi   : Finnish                  es_ES: Spanish

# de   : German                   sv   : Swedish

# el   : Greek                    th   : Thai

# iw   : Hebrew                   zh_TW: Traditional Chinese

# hu   : Hungarian                tr   : Turkish

# is   : Icelandic                uk   : Ukrainian

# in   : Indonesian               vi   : Vietnamese

# it   : Italian

#

# all_langs   : All languages

#

# Specify value as the following to select any of the languages.

# Example : SELECTED_LANGUAGES=en,fr,ja

#

# Specify value as the following to select all the languages.

# Example : SELECTED_LANGUAGES=all_langs

#-------------------------------------------------------------------------------

SELECTED_LANGUAGES=en

#-------------------------------------------------------------------------------

# Specify the installation option.

# Allowed values: CRS_CONFIG or HA_CONFIG or UPGRADE or CRS_SWONLY or HA_SWONLY

#   - CRS_CONFIG : To configure Grid Infrastructure for cluster

#   - HA_CONFIG  : To configure Grid Infrastructure for stand alone server

#   - UPGRADE    : To upgrade clusterware software of earlier release

#   - CRS_SWONLY : To install clusterware files only (can be configured for cluster

#                  or stand alone server later)

#   - HA_SWONLY  : To install clusterware files only (can be configured for stand

#                  alone server later. This is only supported on Windows.)

#-------------------------------------------------------------------------------

oracle.install.option=CRS_SWONLY

#-------------------------------------------------------------------------------

# Specify the complete path of the Oracle Base.

#-------------------------------------------------------------------------------

ORACLE_BASE=/opt/app

#-------------------------------------------------------------------------------

# Specify the complete path of the Oracle Home.

#-------------------------------------------------------------------------------

ORACLE_HOME=/opt/app/oragrid/12.1.0

################################################################################

#                                                                              #

#                              SECTION B - GROUPS                              #

#                                                                              #

#   The following three groups need to be assigned for all GI installations.   #

#   OSDBA and OSOPER can be the same or different.  OSASM must be different    #

#   than the other two.                                                        #

#   The value to be specified for OSDBA, OSOPER and OSASM group is only for    #

#   Unix based Operating System.                                               #

#                                                                              #

################################################################################

#-------------------------------------------------------------------------------

# The DBA_GROUP is the OS group which is to be granted OSDBA privileges.

#-------------------------------------------------------------------------------

oracle.install.asm.OSDBA=dba

#-------------------------------------------------------------------------------

# The OPER_GROUP is the OS group which is to be granted OSOPER privileges.

# The value to be specified for OSOPER group is optional.

#-------------------------------------------------------------------------------

oracle.install.asm.OSOPER=dba

#-------------------------------------------------------------------------------

# The OSASM_GROUP is the OS group which is to be granted OSASM privileges. This

# must be different than the previous two.

#-------------------------------------------------------------------------------

oracle.install.asm.OSASM=dba

################################################################################

#                                                                              #

#                           SECTION C - SCAN                                   #

#                                                                              #

################################################################################

#-------------------------------------------------------------------------------

# Specify a name for SCAN

#-------------------------------------------------------------------------------

oracle.install.crs.config.gpnp.scanName=

#-------------------------------------------------------------------------------

# Specify a unused port number for SCAN service

#-------------------------------------------------------------------------------

oracle.install.crs.config.gpnp.scanPort=

################################################################################

#                                                                              #

#                           SECTION D - CLUSTER & GNS                         #

#                                                                              #

################################################################################

#-------------------------------------------------------------------------------

# Specify the type of cluster you would like to configure

# Allowed values: FLEX and STANDARD

#-------------------------------------------------------------------------------

oracle.install.crs.config.ClusterType=

#-------------------------------------------------------------------------------

# Specify a name for the Cluster you are creating.

#

# The maximum length allowed for clustername is 15 characters. The name can be

# any combination of lower and uppercase alphabets (A - Z), (0 - 9), hyphen(-)

# and underscore(_).

#-------------------------------------------------------------------------------

oracle.install.crs.config.clusterName=

#-------------------------------------------------------------------------------

# Specify 'true' if you would like to configure Grid Naming Service(GNS), else

# specify 'false'

#-------------------------------------------------------------------------------

oracle.install.crs.config.gpnp.configureGNS=

#-------------------------------------------------------------------------------

# Applicable only if you choose to configure GNS

# Specify 'true' if you would like to assign SCAN name VIP and Node VIPs by DHCP

# , else specify 'false'

#-------------------------------------------------------------------------------

oracle.install.crs.config.autoConfigureClusterNodeVIP=

#-------------------------------------------------------------------------------

# Applicable only if you choose to configure GNS

# Specify the type of GNS configuration for cluster

# Allowed values are: CREATE_NEW_GNS and USE_SHARED_GNS

#-------------------------------------------------------------------------------

oracle.install.crs.config.gpnp.gnsOption=

#-------------------------------------------------------------------------------

# Applicable only if SHARED_GNS is being configured for cluster

# Specify the path to the GNS client data file

#-------------------------------------------------------------------------------

oracle.install.crs.config.gpnp.gnsClientDataFile=

#-------------------------------------------------------------------------------

# Applicable only if you choose to configure GNS for this cluster

# oracle.install.crs.config.gpnp.gnsOption=CREATE_NEW_GNS

# Specify the GNS subdomain and an unused virtual hostname for GNS service

#-------------------------------------------------------------------------------

oracle.install.crs.config.gpnp.gnsSubDomain=

oracle.install.crs.config.gpnp.gnsVIPAddress=

#-------------------------------------------------------------------------------

# Specify the list of nodes that have to be configured to be part of the cluster.

#

# The list should a comma-separated list of tuples.  Each tuple should be a

# colon-separated string that contains

# - 2 fields if configuring a Standard Cluster, or

# - 3 fields if configuring a Flex Cluster

#

# The fields should be ordered as follows:

# 1. The first field should be the public node name.

# 2. The second field should be the virtual host name

#    (Should be specified as AUTO if you have chosen 'auto configure for VIP'

#     i.e. autoConfigureClusterNodeVIP=true)

# 3. The third field indicates the role of node (HUB,LEAF). This has to

#    be provide only if Flex Cluster is being configured.

#

# Examples

# For configuring Standard Cluster: oracle.install.crs.config.clusterNodes=node1:node1-vip,node2:node2-vip

# For configuring Flex Cluster: oracle.install.crs.config.clusterNodes=node1:node1-vip:HUB,node2:node2-vip:LEAF

#

#

#-------------------------------------------------------------------------------

oracle.install.crs.config.clusterNodes=

#-------------------------------------------------------------------------------

# The value should be a comma separated strings where each string is as shown below

# InterfaceName:SubnetMask:InterfaceType

# where InterfaceType can be either "1", "2", "3", "4", or "5"

# InterfaceType stand for the following values

#   - 1 : PUBLIC

#   - 2 : PRIVATE

#   - 3 : DO NOT USE

#   - 4 : ASM

#   - 5 : ASM & PRIVATE

#

# For example: eth0:140.87.24.0:1,eth1:10.2.1.0:2,eth2:140.87.52.0:3

#

#-------------------------------------------------------------------------------

oracle.install.crs.config.networkInterfaceList=

#-------------------------------------------------------------------------------

# Specify 'true' if you would like to configure Management Database Option, else

# specify 'false'

#-------------------------------------------------------------------------------

oracle.install.crs.managementdb.configure=

################################################################################

#                                                                              #

#                              SECTION E - STORAGE                             #

#                                                                              #

################################################################################

#-------------------------------------------------------------------------------

# Specify the type of storage to use for Oracle Cluster Registry(OCR) and Voting

# Disks files

#   - LOCAL_ASM_STORAGE

#   - FLEX_ASM_STORAGE

#   - FILE_SYSTEM_STORAGE

# If configuring a Flex Cluster, FLEX_ASM_STORAGE is the only allowed value

#-------------------------------------------------------------------------------

oracle.install.crs.config.storageOption=

#-------------------------------------------------------------------------------

# These properties are applicable only if FILE_SYSTEM_STORAGE is chosen for

# storing OCR and voting disk

# Specify the location(s) and redundancy for OCR and voting disks

# Multiple locations can be specified, separated by commas.

# In case of windows, mention the drive location that is specified to be

# formatted for DATA in the above property.

# Redundancy can be one of these:

#     EXTERNAL - one(1) location should be specified for OCR and voting disk

#     NORMAL - three(3) locations should be specified for OCR and voting disk

# Example:

#     For Unix based Operating System:

#     oracle.install.crs.config.sharedFileSystemStorage.votingDiskLocations=/oradbocfs/storage/vdsk1,/oradbocfs/storage/vdsk2,/oradbocfs/storage/vdsk3

#     oracle.install.crs.config.sharedFileSystemStorage.ocrLocations=/oradbocfs/storage/ocr1,/oradbocfs/storage/ocr2,/oradbocfs/storage/ocr3

#     For Windows based Operating System OCR/VDSK on shared storage is not supported.

#-------------------------------------------------------------------------------

oracle.install.crs.config.sharedFileSystemStorage.votingDiskLocations=

oracle.install.crs.config.sharedFileSystemStorage.votingDiskRedundancy=

oracle.install.crs.config.sharedFileSystemStorage.ocrLocations=

oracle.install.crs.config.sharedFileSystemStorage.ocrRedundancy=

################################################################################

#                                                                              #

#                               SECTION F - IPMI                               #

#                                                                              #

################################################################################

#-------------------------------------------------------------------------------

# Specify 'true' if you would like to configure Intelligent Power Management interface

# (IPMI), else specify 'false'

#-------------------------------------------------------------------------------

oracle.install.crs.config.useIPMI=

#-------------------------------------------------------------------------------

# Applicable only if you choose to configure IPMI

# i.e. oracle.install.crs.config.useIPMI=true

# Specify the username and password for using IPMI service

#-------------------------------------------------------------------------------

oracle.install.crs.config.ipmi.bmcUsername=

oracle.install.crs.config.ipmi.bmcPassword=

################################################################################

#                                                                              #

#                                SECTION G - ASM                               #

#                                                                              #

################################################################################

#-------------------------------------------------------------------------------

# Specify a password for SYSASM user of the ASM instance

#-------------------------------------------------------------------------------

oracle.install.asm.SYSASMPassword=oracle12c

#-------------------------------------------------------------------------------

# The ASM DiskGroup

#

# Example: oracle.install.asm.diskGroup.name=data

#

#-------------------------------------------------------------------------------

oracle.install.asm.diskGroup.name=

#-------------------------------------------------------------------------------

# Redundancy level to be used by ASM.

# It can be one of the following

#   - NORMAL

#   - HIGH

#   - EXTERNAL

# Example: oracle.install.asm.diskGroup.redundancy=NORMAL

#

#-------------------------------------------------------------------------------

oracle.install.asm.diskGroup.redundancy=

#-------------------------------------------------------------------------------

# Allocation unit size to be used by ASM.

# It can be one of the following values

#   - 1

#   - 2

#   - 4

#   - 8

#   - 16

#   - 32

#   - 64

# Example: oracle.install.asm.diskGroup.AUSize=4

# size unit is MB

#

#-------------------------------------------------------------------------------

oracle.install.asm.diskGroup.AUSize=

#-------------------------------------------------------------------------------

# List of disks to create a ASM DiskGroup

#

# Example:

#     For Unix based Operating System:

#     oracle.install.asm.diskGroup.disks=/oracle/asm/disk1,/oracle/asm/disk2

#     For Windows based Operating System:

#     oracle.install.asm.diskGroup.disks=\\.\ORCLDISKDATA0,\\.\ORCLDISKDATA1

#

#-------------------------------------------------------------------------------

oracle.install.asm.diskGroup.disks=

#-------------------------------------------------------------------------------

# The disk discovery string to be used to discover the disks used create a ASM DiskGroup

#

# Example:

#     For Unix based Operating System:

#     oracle.install.asm.diskGroup.diskDiscoveryString=/oracle/asm/*

#     For Windows based Operating System:

#     oracle.install.asm.diskGroup.diskDiscoveryString=\\.\ORCLDISK*

#

#-------------------------------------------------------------------------------

oracle.install.asm.diskGroup.diskDiscoveryString=

#-------------------------------------------------------------------------------

# oracle.install.asm.monitorPassword=password

#-------------------------------------------------------------------------------

oracle.install.asm.monitorPassword=

################################################################################

#                                                                              #

#                             SECTION H - UPGRADE                              #

#                                                                              #

################################################################################

#-------------------------------------------------------------------------------

# Specify whether to ignore down nodes during upgrade operation.

# Value should be 'true' to ignore down nodes otherwise specify 'false'

#-------------------------------------------------------------------------------

oracle.install.crs.config.ignoreDownNodes=

#------------------------------------------------------------------------------

# Specify the auto-updates option. It can be one of the following:

#   - MYORACLESUPPORT_DOWNLOAD

#   - OFFLINE_UPDATES

#   - SKIP_UPDATES

#------------------------------------------------------------------------------

oracle.installer.autoupdates.option=

#------------------------------------------------------------------------------

# In case MYORACLESUPPORT_DOWNLOAD option is chosen, specify the location where

# the updates are to be downloaded.

# In case OFFLINE_UPDATES option is chosen, specify the location where the updates

# are present.

#------------------------------------------------------------------------------

oracle.installer.autoupdates.downloadUpdatesLoc=

#------------------------------------------------------------------------------

# Specify the My Oracle Support Account Username which has the patches download privileges

# to be used for software updates.

#  Example   : AUTOUPDATES_MYORACLESUPPORT_USERNAME=abc@oracle.com

#------------------------------------------------------------------------------

AUTOUPDATES_MYORACLESUPPORT_USERNAME=

#------------------------------------------------------------------------------

# Specify the My Oracle Support Account Username password which has the patches download privileges

# to be used for software updates.

#

# Example    : AUTOUPDATES_MYORACLESUPPORT_PASSWORD=password

#------------------------------------------------------------------------------

AUTOUPDATES_MYORACLESUPPORT_PASSWORD=

#------------------------------------------------------------------------------

# Specify the Proxy server name. Length should be greater than zero.

#

# Example    : PROXY_HOST=proxy.domain.com

#------------------------------------------------------------------------------

PROXY_HOST=

#------------------------------------------------------------------------------

# Specify the proxy port number. Should be Numeric and atleast 2 chars.

#

# Example    : PROXY_PORT=25

#------------------------------------------------------------------------------

PROXY_PORT=

#------------------------------------------------------------------------------

# Specify the proxy user name. Leave PROXY_USER and PROXY_PWD

# blank if your proxy server requires no authentication.

#

# Example    : PROXY_USER=username

#------------------------------------------------------------------------------

PROXY_USER=

#------------------------------------------------------------------------------

# Specify the proxy password. Leave PROXY_USER and PROXY_PWD

# blank if your proxy server requires no authentication.

#

# Example    : PROXY_PWD=password

#------------------------------------------------------------------------------

PROXY_PWD=

#------------------------------------------------------------------------------

# Specify the proxy realm.

#

# Example    : PROXY_REALM=metalink

#------------------------------------------------------------------------------

PROXY_REALM=

**************************************************************************

                                                              Thank You

***************************************************************************