groupadd oinstall
groupadd dba
useradd -g oinstall -G dba -d /home/oracle -m -s /bin/bash -c "ORACLE" oracle
echo "oracle:oracle" > /root/oracle_pass
chpasswd < /root/oracle_pass
rm -rf /root/oracle_pass
id oracle;
id nobody;
echo "";
echo "##########create oracle directory"
mkdir -p /oracle;
mkdir -p /oracle/oraInventory;
chown -R oracle:oinstall /oracle;
chmod -R 775 /oracle/;
echo "##########Add Oracle to sudu user "
chmod u+w /etc/sudoers
echo "oracle ALL=(ALL) ALL" >>/etc/sudoers
chmod u-w /etc/sudoers
}
#配置内核参数
sysctl_config()
{
echo "#########################Step 4:configure system kernal args ############################################"
cat>>/etc/sysctl.conf<
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967295
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 = 1048576
EOF
sysctl -p
echo "Have sourced the nernel args"
}
#配置安全限制参数等
security_config()
{
echo "";
echo "#########################Step 5:configure security limits args ###########################################"
cat>>/etc/security/limits.conf<< EOF
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF
echo "##########set security login args";
cat>>/etc/pam.d/login<
session required pam_limits.so
EOF
}
#这里安装一个rlwrap的SQLPLUS增强文件，可以使sqlplus使用方向键，方便操作
rlwrap_config()
{
echo "#########################Step 6:install rlwrap for sqlplus direction#####################################"
rpm -ivh /root/rpm-centos/readline-devel-6.0-4.el6.x86_64.rpm
tar -zxvf /root/rpm-centos/rlwrap-0.37-x86_64.tar.gz -C /root > /dev/null
cd /root/rlwrap-0.37
echo "configuring rlwrap......"
./configure > /dev/null
echo "making rlwrap......"
make > /dev/null
echo "make installing rlwrap......"
make install > /dev/null
echo "rlwrap installed finished!"
}
#配置环境变量
environment_config(){
echo "#########################Step 7:config etc profile environment ##############################################"
echo "set oracle profile environment------------------------"
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
echo "#########################Step 8:config oracle install environment############################################"
echo "set oracel path and environment-----------------------"
echo "";
ora_profile="/home/oracle/.bash_profile"
cat >> /home/oracle/.bash_profile << EOF
ORACLE_BASE=/oracle
ORACLE_HOME=\$ORACLE_BASE/product/11.2.0/db_1
ORACLE_SID=SDK
PATH=\$ORACLE_HOME/bin:PATH=\$PATH:\$HOME/bin
LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/usr/lib
export ORACLE_BASE
export ORACLE_HOME
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
export ORACLE_SID
export PATH
export LD_LIBRARY_PATH
EOF
source $ora_profile
echo "alias sqlplus='/usr/local/bin/rlwrap sqlplus'" >> /home/oracle/.bashrc
echo "alias rman='/usr/local/bin/rlwrap rman'" >> /home/oracle/.bashrc
chmod 775 /home/oracle/.bash*
chown oracle:oinstall /home/oracle/.bash*
}
#必要时恢复配置文件，在运行时先不要调用此函数
restore_conf