初始化
#关闭防火墙
生产环境不关闭firewalld开机启动
systemctl disable firewalld
systemctl stop firewalld
#关闭selinux
setenforce 0
sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config
cat >> /etc/hosts << EOF
192.168.10.36 dg19c1
192.168.10.37 dg19c2
EOF
RPM检查
rpm -q bc binutils compat-libcap1 compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libX11 libXau libXi libXtst libXrender libXrender-devel libgcc libstdc++ libstdc++-devel libxcb make smartmontools sysstat net-tools nfs-utils sysstat gcc gcc-c++ unixODBC unixODBC-devel| grep "not installed"
RPM 包安装
yum install -y bc binutils compat-libcap1 compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libX11 libXau libXi libXtst libXrender libXrender-devel libgcc libstdc++ libstdc++-devel libxcb make smartmontools sysstat net-tools nfs-utils sysstat gcc gcc-c++ unixODBC unixODBC-devel
sysctl文件修改
cat >> /etc/sysctl.conf << EOF
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 4194304
kernel.shmmax =17179869184
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
EOF
sysctl -p
#资源限制参数调整
cat >> /etc/security/limits.conf << EOF
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
oracle hard memlock 3145728
oracle soft memlock 3145728
EOF
#network添加NOZEROCONF=yes
cat >> /etc/sysconfig/network << EOF
NOZEROCONF=yes
EOF
#测试环境关闭时间服务
systemctl stop chronyd
systemctl disable chronyd
mv /etc/chrony.conf /etc/chrony.conf.bak
#关闭 avahi-daemo 服务
systemctl stop avahi-dnsconfd
systemctl stop avahi-daemon
systemctl disable avahi-dnsconfd
systemctl disable avahi-daemon
##创建配置grid,oracle用户
/usr/sbin/groupadd -g 54321 oinstall
/usr/sbin/groupadd -g 54322 dba
/usr/sbin/groupadd -g 54323 oper
/usr/sbin/useradd -u 54321 -g oinstall -G dba,oper oracle
echo "SIGasmlib"|passwd --stdin oracle
id oracle
添加oracle用户环境变量
cat >> /home/oracle/.bash_profile << EOF
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=\$ORACLE_BASE/product/19.0.0/db_1
export ORACLE_SID=orcl
export PATH=/usr/bin:/usr/sbin:\$PATH
export PATH=\$ORACLE_HOME/bin:\$PATH
export LD_LIBRARY_PATH=\$ORACLE_HOME/bin:/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin/
export CLASSPATH=\$ORACLE_HOME/JRE:\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib
umask 022
EOF
#创建安装目录
mkdir -p /u01/app/oracle/product/19.0.0/db_1
mkdir -p /u01/install
chown -R oracle.oinstall /u01
chmod -R 775 /u01
注意:从18C 开始 database同grid为简单安装模式
解压 zip包至 oracle $ORACLE_HOME中
unzip LINUX.X64_193000_db_home.zip -d $ORACLE_HOME
oracle用户
cd $ORACLE_HOME
./runInstaller
数据库软件安装
执行脚本后点击OK
数据库dbca建库
单实例模式
先不配置后面手动netca配置
根据安装需求进行配置
netca创建监听
netmgr 配置静态监听