Install19cOracleRedhat8

1. Sudo dba

   $ su -
   # echo -e "dba\tALL=(ALL)\tNOPASSWD: ALL" > /etc/sudoers.d/020_sudo_dba
   
   # cat /etc/sudoers.d/020_sudo_dba
   your_id ALL=(ALL) NOPASSWD: ALL

2. Remove graphic interface

   $ sudo dnf groupinstall -y "Minimal Install"
   $ sudo dnf groupremove -y "Server with GUI"
   $ sudo dnf groupinstall -y "Server"
   
   # minimal graphic
   	
   sudo subscription-manager repos --enable=codeready-builder-for-rhel-8-x86_64-rpms
   sudo yum install  xorg-x11-server-Xorg xorg-x11-xauth xorg-x11-apps -y

3. X11 forwarding

   #check setting in /etc/ssh/sshd_config
   
   AllowTcpForwarding     yes
   X11UseLocalhost        yes
   X11DisplayOffset       10
   X11Forwarding          yes

4. install SAR

   	sudo yum install sysstat
   	sudo systemctl enable sysstat
   	sudo systemctl start sysstat

5. Snmp /etc/snmp/snmpd.conf
6. Users and Groups

   #basic groups for database management or check 
   ```
   getent group | grep oinstall
   54321 => ok 
   getent group | grep dba
   54322 => ok 
   getent group | grep oper
   54323 => ok 
   getent group | grep dgdba
   => missing  ko
   getent group | grep kmdba
   => missing  ko
   getent group | grep backupdba
   => missing  ko
   
   # if missing we need to add 
   
   groupadd -g 54321 oinstall
   groupadd -g 54322 dba
   groupadd -g 54323 oper
   sudo sudo groupadd -g 65539 dgdba
   sudo sudo groupadd -g 65540 kmdba
   sudo sudo groupadd -g 65538 backupdba
   
   > the oper have the same guid than monitor
   
   sudo useradd -u 54321 -g oinstall -G dba,oper,backupdba,dgdba,kmdba oracle
   
   #sudo usermod -u 54321 -G oinstall,dba,oper,backupdba,dgdba,kmdba,racdba  oracle

7. - add keyssh  dba
8. monitoring centreon
9. basic packages to install

   um install -y bc 
   yum install -y binutils 
   # yum install -y compat-libcap1  #not exist redhat8
   # yum install -y compat-libstdc++-33 #not exist redhat8
   yum install -y elfutils-libelf 
   yum install -y elfutils-libelf-devel 
   yum install -y fontconfig-devel 
   yum install -y glibc 
   yum install -y glibc-devel 
   yum install -y ksh 
   yum install -y libaio 
   yum install -y libaio-devel 
   # yum install -y libdtrace-ctf-devel  not exist redhat8 
   yum install -y libXrender 
   yum install -y libXrender-devel 
   yum install -y libX11 
   yum install -y libXau 
   yum install -y libXi 
   yum install -y libXtst 
   yum install -y libgcc 
   yum install -y librdmacm-devel 
   yum install -y libstdc++ 
   yum install -y libstdc++-devel 
   yum install -y libxcb 
   yum install -y make 
   yum install -y smartmontools 
   yum install -y sysstat
   
   # https://anuragkumarjoy.blogspot.com/2020/04/oracle-19c-installation-on-linux-8.html
   ## /u2/oracle/install/perl/bin/perl: error while loading shared libraries: libnsl.so.1: cannot open shared object file: No such file or directory
   dnf install -y libnsl
   dnf install -y libnsl.i686
   dnf install -y libnsl2
   dnf install -y libnsl2.i686
   
   
   dnf install -y gcc
   yum install -y net-tools

10. sysctl

    #vim /etc/sysctl.d/99-oracle.conf
    
    	fs.file-max = 6815744
    	kernel.sem = 250 32000 100 128
    	kernel.shmmni = 4096
    	kernel.shmall = 1073741824
    	kernel.shmmax = 4398046511104
    	net.core.rmem_default = 262144
    	net.core.rmem_max = 4194304
    	net.core.wmem_default = 262144
    	net.core.wmem_max = 1048576
    	fs.aio-max-nr = 1048576
    	net.ipv4.conf.all.rp_filter = 2
    	net.ipv4.conf.default.rp_filter = 2
    	net.ipv4.ip_local_port_range = 9000 65500
    	
    #aply(or reboot)99-oracle.conf
    	/sbin/sysctl -p
    	/sbin/sysctl -p /etc/sysctl.d/99-oracle.conf
    	
    #reload 
    	sysctl --system

11. limit

    # /etc/security/limits.d/99-oracle-limits.conf
    
    	# shell limits for users oracle 19C
    
    	oracle   soft   nofile   1024
    	oracle   hard   nofile   65536
    	oracle   soft   nproc    16384
    	oracle   hard   nproc    16384
    	oracle   soft   stack    10240
    	oracle   hard   stack    32768
    	oracle   soft   memlock  134217728
    	oracle   hard   memlock  134217728

12. disable firewall

    	systemctl stop firewalld
    	systemctl disable firewalld

13. se linux

    # /etc/selinux/config	
    SELINUX=permissive