ORACLE安装预设置脚本

                                 ORACLE安装预设置脚本

        对于DBA来说，经常需要不断去部署oracle database软件，设置一些环境变量或是系统
参数感觉十分枯燥，通过脚本来实现可以减少很多重复的工作.

#!/bin/bash

#writen by dongdongtang
#purpose: install oracle database software

#modify sid by yourself
SID=test

export PATH=/usr/bin:/usr/sbin:/bin:/sbin

echo "kernel.shmmax = 6294967296" >>/etc/sysctl.conf
echo "kernel.shmmni = 4096" >>/etc/sysctl.conf
echo "kernel.shmall = 2097152" >>/etc/sysctl.conf
echo "kernel.sem = 250 32000 100 142" >>/etc/sysctl.conf
echo "net.ipv4.ip_local_port_range = 1024 65000"  >>/etc/sysctl.conf
echo "fs.aio-max-nr" = 3145728" >>/etc/sysctl.conf
echo "fs.file-max" = 6815744" >>/etc/sysctl.conf
echo "net.core.rmem_default = 4194304" >>/etc/sysctl.conf
echo "net.core.rmem_max = 4194304"  >>/etc/sysctl.conf
echo "net.core.wmem_default = 262144" >>/etc/sysctl.conf
echo "net.core.wmem_max = 1048586" >>/etc/sysctl.conf

#reload kernel settings
sysctl -p

echo "oracle soft nofile 600000" >>/etc/security/limits.conf
echo "oracle hard nofile 600000" >>/etc/security/limits.conf
echo "oracle soft noproc 16384"  >>/etc/security/limits.conf
echo "oracle soft noproc 16384"  >>/etc/security/limits.conf

service iptables stop

sed -i 's/SELINUX=permissive/SELINUX=disabled/' /etc/sysconfig/selinux
sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/sysconfig/selinux

yum install binutils* -y
yum install compat-libstdc++* -y
yum install gcc-* -y
yum install gcc-c++* -y
yum install glibc* -y
yum install glibc* -y
yum install glibc* -y
yum install ksh
yum install  libaio* -y
yum install  libaio* -y
yum install  libgcc* -y
yum install  libstdc* -y
yum install  libstdc++-devel* -y
yum install  libXext* -y
yum install libXtst* -y
yum install libX11* -y
yum install libXau* -y
yum install libXi* -y
yum install make* -y
yum install  sysstat* -y

groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle

mkdir -p /u01/app/oracle/product/12.1.0.1/db_1

chown -R oracle:oinstall /u01

echo  "export ORACLE_BASE=/u01/app/oracle" >> /home/oracle/.bash_profile
echo  "export ORACLE_HOME=/u01/app/oracle/product/12.1.0.1/db_1" >> /home/oracle/.bash_profile
echo "export ORACLE_SID=${SID}" >> /home/oracle/.bash_profile
echo "export PATH=$PATH:$ORACLE_HOME/bin:/bin:/sbin:/usr/bin:/usr/sbin" >> /home/oracle/.bash_profile

部分的设置需要视具体环境而调整.