Oracle 11gR2 (11.2.0.4) Installation OL8 (Oracle Linux 8)

Oracle Linux 8 is certified with 11.2.0.4 only.

Below is the instructions to install 11.2.0.4 on OL8.

Do a fresh installation of OL8 and perform OS patch.

Hostname: orcldb1

Host IP:  192.168.0.113

1) vi /etc/hosts
192.168.0.113 orcldb1

2) vi /etc/sysconfig/selinux
SELINUX=disabled

setenforce disabled

3) Disable firewall
systemctl stop firewalld
systemctl disable firewalld

4) OS Setting
groupadd -g 1100 oinstall
groupadd -g 1200 asmadmin
groupadd -g 1201 asmdba
groupadd -g 1202 asmoper
groupadd -g 1300 dba
groupadd -g 1301 oper

useradd -m -u 1101 -g oinstall -G dba,oper,asmdba -d /home/oracle -s /bin/bash -c "Oracle Software Owner" oracle

passwd oracle

mkdir -p /u01/app/oracle
chown oracle:oinstall /u01/app/oracle
chmod -R 775 /u01

cat >> /etc/security/limits.conf <<EOF
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF

cat >> /etc/pam.d/login <<EOF
session    required     pam_limits.so
EOF

cat >> /etc/profile <<EOF
if [ \$USER = "oracle" ] || [ \$USER = "grid" ]; then
      if [ \$SHELL = "/bin/ksh" ]; then
         ulimit -p 16384
         ulimit -n 65536     
      else         
ulimit -u 16384 -n 65536     
      fi     
umask 022
fi
EOF

cat >> /etc/csh.login <<EOF
if ( \$USER == "oracle" || \$USER == "grid" )
then
limit maxproc 16384
limit descriptors 65536
endif
EOF

cat >> /etc/sysctl.conf <<EOF  
# Controls the maximum number of shared memory segments system wide
kernel.shmmni = 4096  
# Sets the following semaphore values:
# SEMMSL_value  SEMMNS_value  SEMOPM_value  SEMMNI_value
kernel.sem = 250 32000 100 128  
# Sets the maximum number of file-handles that the Linux kernel will allocate
fs.file-max = 6815744
# Defines the local port range that is used by TCP and UDP
# traffic to choose the local port
net.ipv4.ip_local_port_range = 9000 65500  
# Default setting in bytes of the socket "receive" buffer which
# may be set by using the SO_RCVBUF socket option
net.core.rmem_default=262144  
# Maximum setting in bytes of the socket "receive" buffer which
# may be set by using the SO_RCVBUF socket option
net.core.rmem_max=4194304  
# Default setting in bytes of the socket "send" buffer which
# may be set by using the SO_SNDBUF socket option
net.core.wmem_default=262144  
# Maximum setting in bytes of the socket "send" buffer which  
# may be set by using the SO_SNDBUF socket option
net.core.wmem_max=1048576  
# Maximum number of allowable concurrent asynchronous I/O requests requests
fs.aio-max-nr=1048576
EOF

sysctl -p

4) Prerequired software (some may not found, just ignore, I copy from previous installation)
yum install binutils -y
yum install gcc -y
yum install gcc-c++ -y
yum install glibc -y
yum install glibc.i686 -y
yum install glibc-devel -y
yum install glibc-devel.i686 -y
yum install ksh -y
yum install libgcc -y
yum install libgcc.i686 -y
yum install libstdc++ -y
yum install libstdc++.i686 -y
yum install libstdc++-devel -y
yum install libstdc++-devel.i686 -y
yum install libaio -y
yum install libaio.i686 -y
yum install libaio-devel -y
yum install libaio-devel.i686 -y
yum install libXext -y
yum install libXext.i686 -y
yum install libXtst -y
yum install libXtst.i686 -y
yum install libX11 -y
yum install libX11.i686 -y
yum install libXau -y
yum install libXau.i686 -y
yum install libxcb -y
yum install libxcb.i686 -y
yum install libXi -y
yum install libXi.i686 -y
yum install make -y
yum install sysstat -y
yum install unixODBC -y
yum install unixODBC-devel -y
yum install zlib-devel -y
yum install elfutils-libelf-devel -y

dnf install libnsl
dnf groupinstall "Server with GUI" -y
reboot
dnf install -y tigervnc-server tigervnc-server-module

***This is the critical part***

Have to remove the libaio come with OL8, runInstaller will give error when linking. Reinstall the libaio from OL7.

After remove libaio and the dependent packages, including the lvm2, may cause the lvm partition unable to mount. Reinstall the lvm2 after install libaio from OL7.

dnf remove libaio-0.3.112-1.el8.i686
dnf remove libaio-0.3.112-1.el8.x86_64

dnf install https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/libaio-0.3.109-13.el7.i686.rpm
dnf install https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/libaio-0.3.109-13.el7.x86_64.rpm
dnf install https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/libaio-devel-0.3.109-13.el7.i686.rpm
dnf install https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/libaio-devel-0.3.109-13.el7.x86_64.rpm

dnf install lvm2

5) Oracle user profile
vi /home/oracle/.bash_profile
# Oracle Settingsexi
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=orcldb1; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

6) Oracle DB Software Install
./runInstaller

## if Installer not showing popup window for user to choose input (Yes / No) ##
1. download java: https://www.oracle.com/java/technologies/javase-java-archive-javase6-downloads.html , choose: jdk-6u45-linux-x64.bin
2.
#chmod +x jdk-6u45-linux-x64.bin
#./jdk-6u45-linux-x64.bin
install at /usr/java/jdk1.6.0_45/
3. ./runInstaller -jreLoc /usr/java/jdk1.6.0_45
## if Installer not showing popup window for user to choose input (Yes / No) - END ##
 
* ignore Prerequisites check
* During the linking phase, ignore any error related to EM (enterprise manager)

7) Oracle DB Install
dbca

8) Oracle Listener Install
netca