Oracle安装/优化脚本11g-oel79

# Oracle安装/优化脚本11g-oel79
安装环境：
oracle linux 7.9
oracle 11gr2

[【附件】Oracle Database 11g RAC手册 原书第2版.zip](/media/attachment/2021/05/Oracle_Database_11g_RAC手册_原书第2版.zip)

## oracle 安装与优化
https://www.cnblogs.com/lvbinbin2yujie/p/10496837.html

优化脚本
```shell
#!/bin/bash
PASSWD=`uuidgen`
EchoSlash(){
NUM=0
echo -ne "\n"
while (("$NUM < 50")) ;
do
    echo -n "-" 
    let "NUM=$NUM+1"
done
echo -ne "\n"
}
startRun() {
touch /oracle/preinstall.lock
chmod 400 /oracle/preinstall.lock
echo "关闭防火墙"
service iptables stop > /dev/null >&1
chkconfig iptables off > /dev/null >&1
EchoSlash
unzip -d /oracle/orasoft/ /oracle/orasoft/p13390677_112040_Linux-x86-64_1of7.zip
unzip -d /oracle/orasoft/ /oracle/orasoft/p13390677_112040_Linux-x86-64_2of7.zip
sed -i 's/OEL4/OEL6/' /oracle/orasoft/database/stage/cvu/cv/admin/cvu_config
EchoSlash
echo "关闭selinux"
sed -i "s/enforcing/disabled/" /etc/selinux/config
setenforce 1
EchoSlash
echo "内核配置"
cat >> /etc/sysctl.conf <<EOF
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
fs.file-max = 6815744
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 = 1048586
fs.aio-max-nr = 1048576
EOF
sysctl -p > /dev/null
EchoSlash
echo "系统参数优化"
cat >> /etc/security/limits.conf <<EOF
* soft nproc 65535
* hard nproc 65535
* soft nofile 65535
* hard nofile 65535
* hard stack 65535
* soft stack 65535
EOF
EchoSlash
echo "系统认证配置"
cat >> /etc/pam.d/login <<EOF
session required /lib64/security/pam_limits.so
session required pam_limits.so
EOF
EchoSlash
echo "用户参数优化"
cat >> /etc/profile <<EOF
if [ \$USER = "oracle" ]; then
 if [ \$SHELL = "/bin/ksh" ]; then
  ulimit -p 16384
  ulimit -n 65536
 else
  ulimit -u 16384 -n 65536
 fi
fi
EOF
EchoSlash
echo "创建用户及用户组"
groupadd  oinstall
groupadd  dba
useradd  -g  oinstall  -G  dba  oracle
echo $PASSWD | passwd --stdin oracle > /dev/null >&1 
echo -ne "user oracle password is:\n$PASSWD\n" >> /root/serverinfo.txt 
echo -ne "\033[44;37muser oracle password is:\n$PASSWD\n \033[0m"
EchoSlash
echo "创建安装目录"
mkdir -p /oracle/app/oracle
mkdir -p /oracle/data
mkdir -p /oracle/log
mkdir -p /oracle/arc
chown -R oracle:oinstall  /oracle/
echo "配置oracle用户环境变量"
cat >> /home/oracle/.bash_profile <<EOF
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=\$ORACLE_BASE/product/dbhome_1
export ORACLE_SID=
export PATH=\$PATH:\$HOME/bin:\$ORACLE_HOME/bin
export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/usr/lib
EOF
EchoSlash
echo "安装镜像源,检查并安装软件包"
if [ -f /oracle/orasoft/oel79x64.iso ] ; then
    echo -ne "\033[44;37mISO exists, ready to mount& install RPMs \033[0m"
    mkdir /mnt/cdrom
    mount -o loop /oracle/orasoft/oel79x64.iso /mnt/cdrom
    rm -f /etc/yum.repos.d/*
    cat >> /etc/yum.repos.d/cdrom.repo <<EOF
[cdrom]
name=cdrom
baseurl=file:///mnt/cdrom
enabled=1
gpgcheck=0
gpgkey=file:///mnt/cdrom/RPM-GPG-KEY-redhat-release
EOF
    yum clean all > /dev/null >&1 
    yum makecache > /dev/null >&1
    echo -ne "\nInstalling RPMs"
    rpm -q --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" make sysstat unixODBC unixODBC-devel binutils gcc libaio libaio-devel glibc tigervnc-server compat-libcap1 compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel glibc-common glibc-devel glibc-headers gcc-c++ libgcc libstdc++ libstdc++-devel expat xorg-x11-apps xorg-x11-utils wget ksh |grep "not installed" |for i in $(awk '{print $2}') ;do yum -y install $i > /dev/null >&1 ;done
    echo -ne "\nInstalling Desktop"
    yum -y groupinstall "Desktop" > /dev/null >&1 
else
    echo -ne "\033[41;37mISO not exists, mount it first, begin rpm check... \033[0m"
    rpm -q --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" make sysstat unixODBC unixODBC-devel binutils gcc libaio libaio-devel glibc tigervnc-server compat-libcap1 compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel glibc-common glibc-devel glibc-headers gcc-c++ libgcc libstdc++ libstdc++-devel expat xorg-x11-apps xorg-x11-utils wget ksh |grep "not installed" 
fi 
EchoSlash
echo "更改host文件"
sed -i "s/ localhost / localhost $HOSTNAME /" /etc/hosts
EchoSlash
echo "配置vncserver"
if [ -f /etc/yum.repos.d/cdrom.repo ] ; then
    mkdir -p /root/.vnc
    chmod 755 /root/.vnc
    echo 'oracle@dg@sustech' |vncpasswd -f > /root/.vnc/passwd
    echo 'VNC password: oracle@dg@sustech' >> /root/serverinfo.txt 
    chmod 600 /root/.vnc/passwd
    vncserver  > /dev/null >&1
    echo -ne "\033[44;37mLogin vncserver on:'\$ip:1' \n \033[0m"
fi
echo -ne "登陆VNC后执行 \nxhost + \n/oracle/orasoft/database/runInstaller \n开始安装数据库"
}
USERID=`id -u`
if [ -f /oracle/preinstall.lock ] ; then
    echo -ne "Already done!! See '/root/serverinfo.txt' \nExiting..."
    exit
else
    if [ $USERID -eq 0 ] ; then
        startRun
        exit
    else
        echo "You need to be root!"
    fi
fi
```

## 数据库创建脚本

[【附件】SZDXSOFT.zip](/media/attachment/2021/05/SZDXSOFT.zip)
- 使用方式
```shell
# 使用前需要修改脚本调用的sql文件位置与数据库SID，然后
bash SZDXSOFT.sh
```