系统安装规划
OS version Red Hat 7.6 x86_64
HOSTNAME lsy
IP 192.168.0.120
Root账号密码 root/123456
Oracle version Oracle 19.3
数据库名 orcl
Oracle软件下载链接 https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html
安装前配置
修改hosts文件
[root@memaapex ~]# vim /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.3.6 memaapex
编辑内核参数sysctl.conf
[root@memaapex ~]# vim /etc/sysctl.conf
添加:
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
重新载入
[root@memaapex etc]# /sbin/sysctl -p
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
修改oracle访问限制
[root@memaapex etc]# vi /etc/security/limits.d/oracle-database-preinstall-19c.conf
添加:
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 hard memlock 134217728
oracle soft memlock 134217728
安装操作系统RPM包
yum install -y bc
yum install -y binutils
yum install -y compat-libcap1
yum install -y compat-libstdc++-33
#yum install -y dtrace-modules
#yum install -y dtrace-modules-headers
#yum install -y dtrace-modules-provider-headers
yum install -y dtrace-utils
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
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 net-tools # Clusterware
yum install -y nfs-utils # ACFS
yum install -y python # ACFS
yum install -y python-configshell # ACFS
yum install -y python-rtslib # ACFS
yum install -y python-six # ACFS
yum install -y targetcli # ACFS
yum install -y smartmontools
yum install -y sysstat
# Added by me.
yum install -y unixODBC
创建组和用户及目录
[root@memaapex ~]#groupadd -g 54321 oinstall
[root@memaapex ~]#groupadd -g 54322 dba
[root@memaapex ~]#groupadd -g 54323 oper
[root@memaapex ~]#useradd -u 54321 -g oinstall -G dba,oper oracle
[root@memaapex ~]#mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1
[root@memaapex ~]#mkdir -p /u01/oradata
[root@memaapex ~]#chown -R oracle:oinstall /u01
[root@memaapex ~]#chmod -R 775 /u01
修改firewall和selinux
[root@memaapex ~]#vim /etc/selinux/config
修改selinux参数
SELINUX=disabled
关闭和禁用防火墙
[root@memaapex ~]#systemctl stop firewalld
[root@memaapex ~]#systemctl disable firewalld
编辑Oracle profile文件
[root@memaapex ~]#vi /home/oracle/.bash_profile
# Oracle Settings
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=lsy
export ORACLE_UNQNAME=orcl
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1
export ORACLE_SID=orcl
export PATH=/usr/sbin:/usr/local/bin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
数据库软件安装
上传Oracle安装包$ORACLE_HOME
[root@memaapex u01]# chown -R oracle:oinstall /u01
[root@memaapex u01]# chmod -R 775 /u01
[root@memaapex u01]# cd $ORACLE_HOME
[root@memaapex u01]# unzip LINUX.X64_193000_db_home.zip
图形化安装数据库软件
[root@memaapex soft]# xhost +
access control disabled, clients can connect from any host
Printenv 显示display及所有参数
[root@memaapex soft]#
NETCA创建监听
[oracle@memaapex dbhome_1]$ netca
Oracle Net Services Configuration:
DBCA建库