Simplified Oracle Database 12c and 11g Installation

Installations on Linux 6 Before installing Oracle Database 12c or 11g on a system, you need to preconfigure the operating environment since the database requires certain software packages, package versions, and tweaks to kernel parameters. (Be sure to review the appropriate Oracle Database installation guide to familiarize yourself with hardware, software, and operating system requirements.) The oracle-rdbms-server-12cR1-preinstall and oracle-rdbms-server-11gR2-preinstall parses the existing /etc/sysctl.conf and /etc/security/limits.conf files and updates values only as needed for database installation.

  • Here are the steps for preconfiguring a system for Oracle Database installation using oracle-rdbms-server-11gR2-preinstall. Remember, the steps are the same when using the oracle-rdbms-server-12cR1-preinstall package; you simply need to change the name of the RPM package during the yum installation step.
[root@BIH002 home]# cd /etc/yum.repos.d
[root@BIH002 yum.repos.d]# wget http://public-yum.oracle.com/public-yum-ol6.repo
--2013-11-11 14:45:18--  http://public-yum.oracle.com/public-yum-ol6.repo
Resolving public-yum.oracle.com... 23.33.187.89, 23.33.187.96
Connecting to public-yum.oracle.com|23.33.187.89|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 3512 (3.4K) [text/plain]
Saving to: âpublic-yum-ol6.repo.1â

100%[====================================================================================] 3,512       --.-K/s   in 0s

2013-11-11 14:45:18 (7.15 MB/s) - âpublic-yum-ol6.repo.1â saved [3512/3512]
  • Using a text editor, modify the file, changing the field enabled=0 to enabled=1 to reflect repositories that correspond to the machine's operating system release.
[root@BIH002 yum.repos.d]# vim public-yum-ol6.repo
[ol6_latest]
name=Oracle Linux $releasever Latest ($basearch)
baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/$basearch/
gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6
gpgcheck=1
enabled=1

[ol6_UEK_latest]
name=Latest Unbreakable Enterprise Kernel for Oracle Linux $releasever ($basearch)
baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/UEK/latest/$basearch/
gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6
gpgcheck=1
enabled=1
// ]]>
  • Next, install the oracle-rdbms-server-11gR2-preinstall RPM using the yum install command. If you are using Oracle Database 12c, then you would type yum install.
[root@BIH002 yum.repos.d]# yum install oracle-rdbms-server-11gR2-preinstall
Loaded plugins: security
ol6_UEK_latest                                                                                         | 1.2 kB     00:00
ol6_latest                                                                                             | 1.4 kB     00:00
Setting up Install Process
Resolving Dependencies
-- Running transaction check
--- Package oracle-rdbms-server-11gR2-preinstall.x86_64 0:1.0-7.el6 will be installed
-- Processing Dependency: gcc-c++ for package: oracle-rdbms-server-11gR2-preinstall-1.0-7.el6.x86_64
-- Processing Dependency: libstdc++-devel for package: oracle-rdbms-server-11gR2-preinstall-1.0-7.el6.x86_64
-- Processing Dependency: compat-libstdc++-33 for package: oracle-rdbms-server-11gR2-preinstall-1.0-7.el6.x86_64
-- Processing Dependency: sysstat for package: oracle-rdbms-server-11gR2-preinstall-1.0-7.el6.x86_64
-- Processing Dependency: libaio-devel for package: oracle-rdbms-server-11gR2-preinstall-1.0-7.el6.x86_64
-- Processing Dependency: ksh for package: oracle-rdbms-server-11gR2-preinstall-1.0-7.el6.x86_64
-- Processing Dependency: compat-libcap1 for package: oracle-rdbms-server-11gR2-preinstall-1.0-7.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-3.el6 will be installed
--- Package ksh.x86_64 0:20100621-19.el6_4.4 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-3.el6 will be installed
--- Package sysstat.x86_64 0:9.0.4-20.el6 will be installed
-- Finished Dependency Resolution

Dependencies Resolved

==============================================================================================================================
 Package                                         Arch              Version                        Repository             Size
==============================================================================================================================
Installing:
 oracle-rdbms-server-11gR2-preinstall            x86_64            1.0-7.el6                      ol6_latest             15 k
Installing for dependencies:
 compat-libcap1                                  x86_64            1.10-1                         ol6_latest             17 k
 compat-libstdc++-33                             x86_64            3.2.3-69.el6                   ol6_latest            183 k
 gcc-c++                                         x86_64            4.4.7-3.el6                    ol6_latest            4.7 M
 ksh                                             x86_64            20100621-19.el6_4.4            ol6_latest            686 k
 libaio-devel                                    x86_64            0.3.107-10.el6                 ol6_latest             13 k
 libstdc++-devel                                 x86_64            4.4.7-3.el6                    ol6_latest            1.6 M
 sysstat                                         x86_64            9.0.4-20.el6                   ol6_latest            224 k

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

Total download size: 7.4 M
Installed size: 23 M
Is this ok [y/N]: y
Downloading Packages:
(1/8): compat-libcap1-1.10-1.x86_64.rpm                                                                |  17 kB     00:00
(2/8): compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm                                                     | 183 kB     00:00
(3/8): gcc-c++-4.4.7-3.el6.x86_64.rpm                                                                  | 4.7 MB     00:23
(4/8): ksh-20100621-19.el6_4.4.x86_64.rpm                                                              | 686 kB     00:04
(5/8): libaio-devel-0.3.107-10.el6.x86_64.rpm                                                          |  13 kB     00:00
(6/8): libstdc++-devel-4.4.7-3.el6.x86_64.rpm                                                          | 1.6 MB     00:17
(7/8): oracle-rdbms-server-11gR2-preinstall-1.0-7.el6.x86_64.rpm                                       |  15 kB     00:00
(8/8): sysstat-9.0.4-20.el6.x86_64.rpm                                                                 | 224 kB     00:03
------------------------------------------------------------------------------------------------------------------------------
Total                                                                                         144 kB/s | 7.4 MB     00:52
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : libstdc++-devel-4.4.7-3.el6.x86_64                                                                         1/8
  Installing : gcc-c++-4.4.7-3.el6.x86_64                                                                                 2/8
  Installing : sysstat-9.0.4-20.el6.x86_64                                                                                3/8
  Installing : compat-libstdc++-33-3.2.3-69.el6.x86_64                                                                    4/8
  Installing : libaio-devel-0.3.107-10.el6.x86_64                                                                         5/8
  Installing : ksh-20100621-19.el6_4.4.x86_64                                                                             6/8
  Installing : compat-libcap1-1.10-1.x86_64                                                                               7/8
  Installing : oracle-rdbms-server-11gR2-preinstall-1.0-7.el6.x86_64                                                      8/8
  Verifying  : compat-libcap1-1.10-1.x86_64                                                                               1/8
  Verifying  : ksh-20100621-19.el6_4.4.x86_64                                                                             2/8
  Verifying  : gcc-c++-4.4.7-3.el6.x86_64                                                                                 3/8
  Verifying  : libaio-devel-0.3.107-10.el6.x86_64                                                                         4/8
  Verifying  : oracle-rdbms-server-11gR2-preinstall-1.0-7.el6.x86_64                                                      5/8
  Verifying  : compat-libstdc++-33-3.2.3-69.el6.x86_64                                                                    6/8
  Verifying  : sysstat-9.0.4-20.el6.x86_64                                                                                7/8
  Verifying  : libstdc++-devel-4.4.7-3.el6.x86_64                                                                         8/8

Installed:
  oracle-rdbms-server-11gR2-preinstall.x86_64 0:1.0-7.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-3.el6
  ksh.x86_64 0:20100621-19.el6_4.4     libaio-devel.x86_64 0:0.3.107-10.el6          libstdc++-devel.x86_64 0:4.4.7-3.el6
  sysstat.x86_64 0:9.0.4-20.el6

Complete!
// ]]>
  • In the kernel settings file /etc/sysctl.conf, the oracle-rdbms-server-11gR2-preinstall has modified and added the necessary settings to ensure the minimum requirements are met.
# oracle-rdbms-server-11gR2-preinstall setting for fs.file-max is 6815744
fs.file-max = 6815744

# oracle-rdbms-server-11gR2-preinstall setting for kernel.sem is '250 32000 100 128'
kernel.sem = 250 32000 100 128

# oracle-rdbms-server-11gR2-preinstall setting for kernel.shmmni is 4096
kernel.shmmni = 4096

# oracle-rdbms-server-11gR2-preinstall setting for kernel.shmall is 1073741824 on x86_64
# oracle-rdbms-server-11gR2-preinstall setting for kernel.shmall is 2097152 on i386
kernel.shmall = 1073741824

# oracle-rdbms-server-11gR2-preinstall setting for kernel.shmmax is 4398046511104 on x86_64
# oracle-rdbms-server-11gR2-preinstall setting for kernel.shmmax is 4294967295 on i386
kernel.shmmax = 4398046511104

# oracle-rdbms-server-11gR2-preinstall setting for net.core.rmem_default is 262144
net.core.rmem_default = 262144

# oracle-rdbms-server-11gR2-preinstall setting for net.core.rmem_max is 4194304
net.core.rmem_max = 4194304

# oracle-rdbms-server-11gR2-preinstall setting for net.core.wmem_default is 262144
net.core.wmem_default = 262144

# oracle-rdbms-server-11gR2-preinstall setting for net.core.wmem_max is 1048576
net.core.wmem_max = 1048576

# oracle-rdbms-server-11gR2-preinstall setting for fs.aio-max-nr is 1048576
fs.aio-max-nr = 1048576

# oracle-rdbms-server-11gR2-preinstall setting for net.ipv4.ip_local_port_range is 9000 65500
net.ipv4.ip_local_port_range = 9000 65500
  • Installing the oracle-rdbms-server-12cR1-preinstall and oracle-rdbms-server-11gR2-preinstall RPMs can save time when installing Oracle Database 12c and 11g on Oracle Linux. These RPMs address most Oracle Database installation prerequisites and greatly simplify the installation process.