How to install the recommanded specifications/prerequistes system packages, kernel parameters and system security limits, for Oracle database 12c Release 2 on Oracle Linux 7.
Tables of contents:
- System versions
- Install the prerequist
- Vérificatiosn of the prerequistes.
- Hostname resolution.
1. System versions:
a. To check the Oracle Linux version:
# cat /etc/oracle-release Oracle Linux Server release 7.4
b. The kernel version
# uname -a Linux ol-7u4.wadhahdaouehi.tn 4.1.12-94.3.9.el7uek.x86_64 #2 SMP Fri Jul 14 20:09:40 PDT 2017 x86_64 x86_64 x86_64 GNU/Linux
2. Install the Oracle database prerequistes on Oracle Linux:
For any Oracle RDBMS version, check what recommanded prerequist from the source software or from the Oracle web site.
- What packages ?
- What kernel parameters ?
- What security limits.
- What groups should have the Oracle database software owner.
Note: With Oracle Linux, we can install all the prerequistes with One step, just to install the package oracle-rdbms-server-11gR2-preinstall.x86_64.
Step 0: Search for the package
# yum search oracle ==================================================== N/S matched: oracle ===================================================== kmod-oracleasm.x86_64 : oracleasm kernel module(s) oracle-database-server-12cR2-preinstall.x86_64 : Sets the system for Oracle Database single instance and Real Application: Cluster install for Oracle Linux 7 oracle-logos.noarch : Oracle-related icons and pictures oracle-rdbms-server-11gR2-preinstall.x86_64 : Sets the system for Oracle single instance and Real Application Cluster install: for Oracle Linux 7 oracle-rdbms-server-12cR1-preinstall.x86_64 : Sets the system for Oracle Database single instance and Real Application Cluster: install for Oracle Linux 7 oracleasm-support.x86_64 : The Oracle Automatic Storage Management support programs. oraclelinux-release.x86_64 : Oracle Linux 7 release file tuned-profiles-oracle.noarch : Additional tuned profile(s) targeted to Oracle loads basesystem.noarch : The skeleton package which defines a simple Oracle Linux system kabi-yum-plugins.noarch : The Oracle Linux kernel ABI yum plugin ocfs2-tools.x86_64 : Tools for managing the Oracle Cluster Filesystem 2 redhat-bookmarks.noarch : Oracle Linux bookmarks redhat-indexhtml.noarch : Browser default start page for Oracle Linux redhat-upgrade-tool.noarch : The Oracle Linux Upgrade tool Name and summary matches only, use "search all" for everything.
Step 1: Install the package
# yum -y install oracle-database-server-12cR2-preinstall.x86_64
Step 2: Check the package information details:
# yum info oracle-database-server-12cR2-preinstall.x86_64 Loaded plugins: langpacks, ulninfo Available Packages Name : oracle-database-server-12cR2-preinstall Arch : x86_64 Version : 1.0 Release : 3.el7 Size : 19 k Repo : ol7_latest/x86_64 Summary : Sets the system for Oracle Database single instance and Real Application Cluster install for Oracle Linux 7 License : GPLv2 Description : The Oracle Preinstallation RPM package installs software packages and sets system parameters required for Oracle Database single instance and : Oracle Real Application Clusters installations for Oracle Linux Release 7 Files affected: /etc/sysctl.conf, /boot/grub/menu.lst OR : /boot/grub2/grub.cfg Files added: /etc/security/limits.d/oracle-database-server-12cR2-preinstall.conf
3. Vérificatiosn of the prerequistes:
We are going to check the prerequistes:
a. Check the kernel parameters
# cat /etc/sysctl.conf .... # For more information, see sysctl.conf(5) and sysctl.d(5). # oracle-database-server-12cR2-preinstall setting for fs.file-max is 6815744 fs.file-max = 6815744 # oracle-database-server-12cR2-preinstall setting for kernel.sem is '250 32000 100 128' kernel.sem = 250 32000 100 128 # oracle-database-server-12cR2-preinstall setting for kernel.shmmni is 4096 kernel.shmmni = 4096 # oracle-database-server-12cR2-preinstall setting for kernel.shmall is 1073741824 on x86_64 kernel.shmall = 1073741824 # oracle-database-server-12cR2-preinstall setting for kernel.shmmax is 4398046511104 on x86_64 kernel.shmmax = 4398046511104 # oracle-database-server-12cR2-preinstall setting for kernel.panic_on_oops is 1 per Orabug 19212317 kernel.panic_on_oops = 1 # oracle-database-server-12cR2-preinstall setting for net.core.rmem_default is 262144 net.core.rmem_default = 262144 # oracle-database-server-12cR2-preinstall setting for net.core.rmem_max is 4194304 net.core.rmem_max = 4194304 # oracle-database-server-12cR2-preinstall setting for net.core.wmem_default is 262144 net.core.wmem_default = 262144 # oracle-database-server-12cR2-preinstall setting for net.core.wmem_max is 1048576 net.core.wmem_max = 1048576 # oracle-database-server-12cR2-preinstall setting for net.ipv4.conf.all.rp_filter is 2 net.ipv4.conf.all.rp_filter = 2 # oracle-database-server-12cR2-preinstall setting for net.ipv4.conf.default.rp_filter is 2 net.ipv4.conf.default.rp_filter = 2 # oracle-database-server-12cR2-preinstall setting for fs.aio-max-nr is 1048576 fs.aio-max-nr = 1048576 # oracle-database-server-12cR2-preinstall setting for net.ipv4.ip_local_port_range is 9000 65500 net.ipv4.ip_local_port_range = 9000 65500
b. Check the security Limits:
# cat /etc/security/limits.d/oracle-database-server-12cR2-preinstall.conf ... # oracle-database-server-12cR2-preinstall setting for nofile soft limit is 1024 oracle soft nofile 1024 # oracle-database-server-12cR2-preinstall setting for nofile hard limit is 65536 oracle hard nofile 65536 # oracle-database-server-12cR2-preinstall setting for nproc soft limit is 16384 # refer orabug15971421 for more info. oracle soft nproc 16384 # oracle-database-server-12cR2-preinstall setting for nproc hard limit is 16384 oracle hard nproc 16384 # oracle-database-server-12cR2-preinstall setting for stack soft limit is 10240KB oracle soft stack 10240 # oracle-database-server-12cR2-preinstall setting for stack hard limit is 32768KB oracle hard stack 32768 # oracle-database-server-12cR2-preinstall setting for memlock hard limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90 % of RAM oracle hard memlock 134217728 # oracle-database-server-12cR2-preinstall setting for memlock soft limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90% of RAM oracle soft memlock 134217728
c. Check the Groups:
# cat /etc/group ... oracle:x:1000: oinstall:x:54321: dba:x:54322: oper:x:54323: backupdba:x:54324: dgdba:x:54325: kmdba:x:54326: racdba:x:54330:
d. Check the user RDBMS owner:
In my case, the system Linux user oracle will be the Owner of the Oracle software:
d.1. Check user groups:
# id oracle uid=1000(oracle) gid=1000(oracle) groups=1000(oracle),10(wheel)
d.2. Add user groups:
# usermod -g oinstall -G dba,oper,backupdba,dgdba,kmdba,racdba oracle
d.3. Check user groups:
# id oracle uid=1000(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)
4. Hostname resolution:
Step 1: Check the hostname
# hostname ol-7u4.wadhahdaouehi.tn
Step 2: Add hostname to the hosts file
# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 127.0.0.1 ol-7u4.wadhahdaouehi.tn ol-7u4
Conclusion:
After Installing the system Linux prerequistis for the Oracle database, it is time to enjoy installing Oracle database.
Pingback: Install Step by Step Oracle database 12R2 on Oracle Linux 7 – Wadhah DAOUEHI