CentOS7安装单机版oracle 11g R2,一键安装shell脚本

#!/bin/bash
##关闭防火墙
systemctl stop firewalld.service
systemctl disable firewalld.service
###查看selinux状态
awk ‘/SELINUX/’ /etc/selinux/config
sed -i ‘s/SELINUX=enforcing/SELINUX=disabled/g’ /etc/selinux/config
###创建用户及组
groupadd oinstall
groupadd dba
groupadd oracle
useradd -g oinstall -G dba oracle -d /home/oracle
echo oracle | passwd --stdin oracle
echo “fs.aio-max-nr=1048576”>>/etc/sysctl.conf
echo “fs.file-max=6815744”>>/etc/sysctl.conf
echo “kernel.shmall=2097152”>>/etc/sysctl.conf
echo “kernel.shmmni=4096”>>/etc/sysctl.conf
echo “kernel.shmmax = 536870912”>>/etc/sysctl.conf
echo “kernel.sem=250 32000 100 128”>>/etc/sysctl.conf
echo “net.ipv4.ip_local_port_range=9000 65500”>>/etc/sysctl.conf
echo “net.core.rmem_default=262144”>>/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
echo “”>>/etc/sysctl.conf
echo “”>>/etc/sysctl.conf
##########生效命令
/sbin/sysctl -p
echo “oracle soft nproc 2047”>>/etc/security/limits.conf
echo “oracle hard nproc 16384”>>/etc/security/limits.conf
echo “oracle soft nofile 1024”>>/etc/security/limits.conf
echo “oracle hard nofile 65536”>>/etc/security/limits.conf
echo “oracle soft stack 10240”>>/etc/security/limits.conf
echo “oracle hard stack 10240”>>/etc/security/limits.conf
echo “session required /lib64/security/pam_limits.so”>>/etc/pam.d/login
echo “session required pam_limits.so”>>/etc/pam.d/login
######################### 安装vnc ，调用centos可视化界面
yum install tigervnc-server
systemctl enable vncserver@:1.service
systemctl start vncserver@:1.service
#systemctl stop vncserver@:1.service
###################################
<<COMMENT
################################################ skip
cat >> /home/oracle/etc/db_install.rsp << EOF
##oracle conf
oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/db/app/oracle/oraInventory
SELECTED_LANGUAGES=en,zh_CN
ORACLE_HOSTNAME=oracle
ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1
ORACLE_BASE=/home/oracle/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.isCustomInstall=true
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oinstall
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=orcl
oracle.install.db.config.starterdb.SID=orcl
oracle.install.db.config.starterdb.memoryLimit=512
oracle.install.db.config.starterdb.password.ALL=oracle
DECLINE_SECURITY_UPDATES=true
EOF
################################################ skip
cat >> /etc/profile << EOF
export ORACLE_BASE=/home/oracle/app/oracle
export ORACLE_HOME=$ORACL{E}_{B}ASE/product/11.2.0/dbhom{e}_1/exportORACL{E}_{S}ID=orcl;exportPATH=$ORACLE_HOME/bin:$PATH;
EOF
source /etc/profile
COMMENT
##########切换用户
su – oracle
##########################调用本机xshell
##############192.168.1.14 为本地xshell客户端ip地址
#export DISPLAY=192.168.1.14:0.0
#xhost +
#cd database && ./runInstaller

#################单机版oracle
#############高级安装

###建议添加中文

#################与前面配置路径保持一致

############x修改字符集

##########处理方法
cat >> /etc/sysctl.conf << EOF
kernel.sem=250 32000 100 128
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
fs.file-max = 6815744
EOF
/sbin/sysctl -p

echo “fs.file-max = 6815744” >> /etc/sysctl.conf

#################依赖包安装
su root
yum -y install libaio glibc compat-libstdc libaio-devel libgcc libstdc unixODBC unixODBC-devel pdksh

su oracle
echo “export ORACLE_BASE=/home/oracle/app/oracle”>>/home/oracle/.bash_profile
echo “export ORACLE_HOME=$ORACL{E}_{B}ASE/product/11.2.0/dbhom{e}_1/">>/home/oracle/.bas{h}_{p}rofileecho"exportORACL{E}_{S}ID=orcl;">>/home/oracle/.bas{h}_{p}rofileecho"exportPATH=$ORACLE_HOME/bin:$PATH;”>>/home/oracle/.bash_profile
sh /home/oracle/app/oracle/product/11.2.0/dbhome_1/root.sh
sh /home/oracle/app/oracle/product/11.2.0/dbhome_1/inventory/orainstRoot.sh
#vim /etc/oratab 中N修改为Y
#orcl:/home/oracle/app/oracle/product/11.2.0/dbhome_1:N
#orcl:/home/oracle/app/oracle/product/11.2.0/dbhome_1:Y
sed -i ‘s/dbhome_1:N/dbhome_1:Y/g’ /etc/oratab
############安装完毕，使用可视化工具登录
export DISYPLAY=192.168.1.13:0.0
xhost +
netca