« Install19cOracleRedhat8 » : différence entre les versions
Aller à la navigation
Aller à la recherche
Aucun résumé des modifications |
Aucun résumé des modifications |
||
Ligne 103 : | Ligne 103 : | ||
dnf install -y gcc | dnf install -y gcc | ||
yum install -y net-tools | yum install -y net-tools | ||
</syntaxhighlight> | |||
#sysctl<syntaxhighlight lang="bash"> | |||
#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 | |||
</syntaxhighlight> | |||
#limit<syntaxhighlight lang="bash"> | |||
# /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 | |||
</syntaxhighlight> | |||
#disable firewall<syntaxhighlight lang="bash"> | |||
systemctl stop firewalld | |||
systemctl disable firewalld | |||
</syntaxhighlight> | |||
#se linux<syntaxhighlight> | |||
# /etc/selinux/config | |||
SELINUX=permissive | |||
</syntaxhighlight> | </syntaxhighlight> | ||
[[Catégorie:Oracle]] | [[Catégorie:Oracle]] |
Dernière version du 24 mars 2023 à 18:23
- 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
- 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
- X11 forwarding
#check setting in /etc/ssh/sshd_config AllowTcpForwarding yes X11UseLocalhost yes X11DisplayOffset 10 X11Forwarding yes
- install SAR
sudo yum install sysstat sudo systemctl enable sysstat sudo systemctl start sysstat
- Snmp /etc/snmp/snmpd.conf
- 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
- - add keyssh dba
- monitoring centreon
- 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
- 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
- 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
- disable firewall
systemctl stop firewalld systemctl disable firewalld
- se linux
# /etc/selinux/config SELINUX=permissive