OEL Base Config for Oracle DB
All steps on this page should be performed as 'root' unless otherwise indicated.
12.1.0.2
Check:
yum list oracle-rdbms-server-12cR1-preinstall
Install:
yum install oracle-rdbms-server-12cR1-preinstall -y
12.2.0.1
Check:
yum list oracle-database-server-12cR2-preinstall
Install:
yum install oracle-database-server-12cR2-preinstall -y
18.1
Linux is assumed to be Oracle Enterprise Linux 7
As root:
yum install oracle-database-preinstall-18c.x86_64 –y
To check if it is already installed use:
yum list oracle-database-preinstall-18c.x86_64
19c
Linux is assumed to be Oracle Enterprise Linux 7
As root:
yum install oracle-database-preinstall-19c
To check if it is already installed use:
yum list oracle-database-preinstall-19c
Password
The preinstall package will create the 'oracle' user. You should change the password to a known value:
passwd oracle
/etc/security/limits.conf
Add the following lines to the /etc/security/limits.conf file:
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
Huge Pages
Disable Transparent Huge Pages
You should Disable Transparent Huge Pages before installing Oracle Database.
Transparent HugePages is disabled on UEK2 and later UEK kernels
Check (Red Hat Kernel):
cat /sys/kernel/mm/redhat_transparent_hugepage/enabled
Check (Oracle Kernel):
cat /sys/kernel/mm/transparent_hugepage/enabled
NOTE: If Transparent HugePages is removed from the kernel, then neither /sys/kernel/mm/transparent_hugepage nor /sys/kernel/mm/redhat_transparent_hugepage files exist.
Output as shown below indicates that transparent hugepages are disabled
always madvise [never]
https://docs.oracle.com/en/database/oracle/oracle-database/18/ladbi/disabling-transparent-hugepages.html
Configure Huge Pages
GCC
Runlevel
To run the installer, runlevel must be 3 or 5...
runlevel