shell：安装oracle 及后期参数调优

#!/bin/bash

echo "yum"
yum -y install binutils compat-libcap1 compat-libstdc++ gcc gcc-c++ glibc glibc-devel ksh libstdc++ libstdc++-devel sysstat libaio libaio-devel elfutils-libelf-devel unixODBC unixODBC-devel ntpdate lvm2 rsync net-tools libaio libaio-devel libgcc libstdc++ libstdc++-devel libXi libXtst make sysstat cpp glibc-headers mpfr cpan perl readline-devel unzip

echo "Install rpm rlwrap"
cd /data/xjk/software
tar zxvf rlwrap-0.42.tar.gz
cd rlwrap-0.42
./configure
make
make instal

echo "limits.conf"
cat >> /etc/security/limits.conf << EoF
oracle soft nofile 65536
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
EoF

echo "sysctc.conf"
cat >> /etc/sysctl.conf << EOF
kernel.shmmax = 4046471168
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.sem = 250 32000 100 128 
fs.file-max = 6815744
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
fs.aio-max-nr = 1048576
EOF
sysctl -p

echo "make directory"

mkdir -p /data/ora11g/product/11.2.0.4/db_1 
mkdir -p /home/oracle
mkdir -p /data/ora11g/oraInventory 
/usr/sbin/groupadd -g 501 oinstall
/usr/sbin/groupadd -g 502 dba
/usr/sbin/groupadd -g 503 oper
/usr/sbin/useradd -g oinstall -G dba,oper -d /home/oracle -s /bin/bash oracle
chown -R oracle:oinstall /data/ora11g
chmod -R 775 /data/ora11g 
chown -R oracle:oinstall /home/oracle
chown -R oracle:oinstall /data/ora11g/oraInventory
chown -R oracle:oinstall /data/xjk/software/oracle
chmod 775  /data/xjk/software/oracle -R


echo ".bash_profile"
cat >> /home/oracle/.bash_profile << EOF
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_BASE=/data/ora11g
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4/db_1
export ORACLE_SID=test
export ORACLE_TERM=xterm
export PATH=/usr/sbin:$ORACLE_HOME/bin:/usr/local/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"
alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'
alias dgmgrl='rlwrap dgmgrl'
EOF

source /home/oracle/.bash_profile


set -x
su - oracle << !
cd /data/xjk/software/oracle/
unzip p13390677_112040_Linux-x86-64_1of7.zip
unzip p13390677_112040_Linux-x86-64_2of7.zip
unzip p13390677_112040_Linux-x86-64_3of7.zip
cd /data/xjk/software/oracle/database
!
exit 0


dbca -silent -responseFile /data/xjk/software/oracle/database/response/dbca.rsp 
./runInstaller -silent -force -ignoreSysPrereqs -ignorePrereq -responseFile /data/xjk/software/oracle/database/response/db_install.rsp


alter system set processes=3000 scope=spfile;


alter system set memory_max_target=15G scope=spfile;
alter system set memory_target=15G scope=spfile;

alter system set sga_target=0 scope=spfile; 
alter system set sga_max_size=0 scope=spfile; 
alter system set pga_aggregate_target=0 scope=spfile;


ALTER SYSTEM SET undo_retention=3600 SCOPE=BOTH;


alter database datafile '/data/ora11g/oradata/bxjk/undotbs01.dbf' resize 30g;

alter database add logfile group 4 '/data/ora11g/oradata/bxjk/redo04.log' size 1g;
alter database add logfile group 5 '/data/ora11g/oradata/bxjk/redo05.log' size 1g;
alter database add logfile group 6 '/data/ora11g/oradata/bxjk/redo06.log' size 1g;
alter database add logfile group 7 '/data/ora11g/oradata/bxjk/redo07.log' size 1g;


ALTER DATABASE DROP LOGFILE GROUP 2;
ALTER DATABASE DROP LOGFILE GROUP 3;