oracle安装脚本

yum groupinstall -y 'X Window System'

yum install -y binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33.i686 gcc gcc-c++ glibc glibc.i686 glibc-devel glibc-devel.i686 ksh libgcc libgcc.i686 libstdc++ libstdc++.i686 libstdc++-devel libstdc++-devel.i686 libaio libaio.i686 libaio-devel libaio-devel.i686 make sysstat

yum install -y expat expat.i686 mksh unixODBC-devel unixODBC-devel.i686 unixODBC unixODBC.i686 glibc-headers glibc-common elfutils-libelf elfutils-libelf.i686  elfutils-libelf-devel elfutils-libelf-devel.i686 binutils-devel binutils-devel.i686

groupadd oinstall
groupadd dba

useradd -g oinstall -G dba oracle
echo oracle | passwd --stdin oracle

sysctl -a |grep aio-max |sed 's/65536/1048576/' >> /etc/sysctl.conf
sysctl -a |grep file-max |sed 's/386461/6815744/' >> /etc/sysctl.conf 
sysctl -a |grep kernel.shmall |sed 's/4294967296/2097152/' >> /etc/sysctl.conf 
sysctl -a |grep kernel.shmmax |sed 's/68719476736/536870912/' >> /etc/sysctl.conf 
sysctl -a |grep kernel.sem |sed 's/32/100/2' >> /etc/sysctl.conf
sysctl -a |grep local_port_range |sed -e 's/32768/9000/' -e 's/61000/65500/' >> /etc/sysctl.conf
sysctl -a |grep rmem_default |sed 's/229376/262144/' >> /etc/sysctl.conf 
sysctl -a |grep rmem_max |sed 's/229376/4194304/' >> /etc/sysctl.conf 
sysctl -a |grep wmem_default |sed 's/229376/262144/' >> /etc/sysctl.conf 
sysctl -a |grep wmem_max|sed 's/229376/1048576/' >> /etc/sysctl.conf

sysctl -p

echo 'oracle           soft    nofile          1024' >> /etc/security/limits.conf
echo 'oracle           hard    nofile          65536' >> /etc/security/limits.conf
echo 'oracle           soft    nproc           2047' >> /etc/security/limits.conf
echo 'oracle           hard    nproc           16384' >> /etc/security/limits.conf
echo 'oracle           soft    stack           10240' >> /etc/security/limits.conf
echo 'oracle           hard    stack           32768' >> /etc/security/limits.conf

mkdir -p /u01/app/
chown -R oracle.oinstall /u01/app/
chmod -R 775 /u01/app/

TMP=/tmp
TMPDIR=/tmp
export TMP TMPDIR

ORACLE_BASE=/u01/app/oracle
export ORACLE_BASE

if [ -z "$(ifconfig eth0 |grep 'inet addr' |awk '{print $2}' |awk -F: '{print $2}' )" ]
then
    ipaddr=$(ifconfig br0 |grep 'inet addr' |awk '{print $2}' |awk -F: '{print $2}')
else
    ipaddr=$(ifconfig eth0 |grep 'inet addr' |awk '{print $2}' |awk -F: '{print $2}')
fi

machinename=$(hostname)

echo -e "$ipaddr \t $machinename" >> /etc/hosts



# Oracle Settings
export TMP=/tmp;
export TMPDIR=$TMP;
export ORACLE_BASE=/oracle;
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1;
export ORACLE_SID=testdb;
export ORACLE_TERM=xterm;
export PATH=/usr/sbin:$PATH;
export PATH=$ORACLE_HOME/bin:$PATH;
export PATH
export ORACLE_HOME
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;

if [ $USER = "oracle" ]; then
       if [ $SHELL = "/bin/ksh" ]; then
            ulimit -p 16384
            ulimit -n 65536
       else
            ulimit -u 16384 -n 65536
       fi
fi