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

# Oracle安装/优化脚本
安装环境：
oracle linux 6.8
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

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
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle hard stack 10240
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
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/oel68x64.iso ] ; then
    echo -ne "\033[44;37mISO exists, ready to mount& install RPMs \033[0m"
    mkdir /mnt/cdrom
    mount -o loop /oracle/orasoft/oel68x64.iso /mnt/cdrom
    rm -f /etc/yum.repos.d/public-yum-ol6.repo
    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-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-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
```