安装Oracle 19.3 数据库系统 For Linux OS 最佳部署手册

Oracle 19.3 on the linux OS

搭建 yum 仓库

[root@localhost ~]# mkdir /mnt/cdrom

[root@localhost ~]# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/mapper/VolGroup-lv_root

45G 3.1G 40G 8% /

tmpfs 995M 224K 995M 1% /dev/shm

/dev/sda1 477M 64M 384M 15% /boot

Filesystem Size Used Avail Use% Mounted on

/dev/mapper/VolGroup-lv_root

45G 3.1G 40G 8% /

tmpfs 995M 224K 995M 1% /dev/shm

/dev/sda1 477M 64M 384M 15% /boot

/dev/sr0 3.6G 3.6G 0 100% /media/OL6.6 x86_64 Disc 1 20141018

/dev/sr0 3.6G 3.6G 0 100% /mnt/cdrom

[root@localhost ~]#

[root@localhost cdrom]# cd /etc/yum.repos.d/

[root@localhost yum.repos.d]# mv public-yum-ol7.repo public-yum-ol7.repobk

i 编辑模式

󰷅󰷅󰷅󰷅󰷅

Esc 退出编辑模式

在退出编辑模式下 dd 是删除当前行

:q! 强制退出编辑

:wq 写后退出

安装数据库软件所需要的包

yum install binutils -y

yum install compat-libcap1 -y

yum install compat-libstdc++-33 -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 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

如果遇到以下问题

解决方法：

net.ipv4.conf.default.accept_source_route = 0

kernel.sysrq = 0

kernel.core_uses_pid = 1

net.ipv4.tcp_syncookies = 1

kernel.msgmnb = 65536

kernel.msgmax = 65536

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

kernel.shmmax = 8589934592

kernel.shmall = 4194304

fs.aio-max-nr = 1048576

kernel.panic_on_oops = 1

修改后让内核参数生效

[root@localhost ~]# sysctl -p

2. 设置 Oracle 和 Grid 用户的 SHELL 限制

vi /etc/security/limits.conf

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft stack 10240

oracle hard stack 32768

groupadd -g 1009 oinstall

groupadd -g 1010 dba

groupadd -g 1011 oper

groupadd -g 1003 backupdba

groupadd -g 1004 dgdba

groupadd -g 1005 kmdba

groupadd -g 1006 asmdba

groupadd -g 1007 asmoper

groupadd -g 1008 asmadmin

groupadd -g 1012 racdba