1. Sudo dba

$ su -

1. echo -e “dba=(ALL): ALL” > /etc/sudoers.d/020_sudo_dba

1. cat /etc/sudoers.d/020_sudo_dba

your_id ALL=(ALL) NOPASSWD: ALL

1. Remove graphic interface

$ sudo dnf groupinstall -y “Minimal Install” $ sudo dnf groupremove -y “Server with GUI” $ sudo dnf groupinstall -y “Server”

1. 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

1. X11 forwarding
2. check setting in /etc/ssh/sshd_config

AllowTcpForwarding yes X11UseLocalhost yes X11DisplayOffset 10 X11Forwarding yes

1. install SAR

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

1. Snmp /etc/snmp/snmpd.conf
2. Users and Groups
3. 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

1. 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

1. sudo usermod -u 54321 -G oinstall,dba,oper,backupdba,dgdba,kmdba,racdba oracle

1. - add keyssh  dba
2. monitoring centreon
3. basic packages to install

um install -y bc yum install -y binutils

1. yum install -y compat-libcap1 #not exist redhat8
2. 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

1. 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

1. https://anuragkumarjoy.blogspot.com/2020/04/oracle-19c-installation-on-linux-8.html
   1. /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

1. sysctl
2. 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
   

1. aply(or reboot)99-oracle.conf

   /sbin/sysctl -p
   /sbin/sysctl -p /etc/sysctl.d/99-oracle.conf
   

1. reload

   sysctl --system

1. limit
2. /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

1. disable firewall

   systemctl stop firewalld
   systemctl disable firewalld

1. se linux
2. /etc/selinux/config

SELINUX=permissive

Catégorie:Oracle