CentOS7安装单机版oracle 11g R2

##关闭防火墙
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
useradd -g oinstall -G dba oracle -d /home/oracle
passwd oracle　　 　　　　　　　　
############配置oracle
cat /etc/sysctl.conf << EOF
####oracle content
fs.aio-max-nr=1048576
fs.file-max=6815744
kernel.shmall=2097152
kernel.shmmni=4096
kernel.shmmax = 536870912
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=1048586
EOF
##########生效命令
sysctl -p

cat >> /etc/security/limits.conf << EOF
#####oracle configure
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 10240
EOF

cat >> /etc/pam.d/login << EOF
#####oracle configure
session required /lib64/security/pam_limits.so
session required pam_limits.so
EOF

cat >> /etc/profile << EOF
####oracle enviroment
if [ $USER = “oracle” ]; then
if [ $SHELL = “/bin/ksh” ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
EOF

source /etc/profile

mkdir -p /db/app/oracle/product/11.2.0
mkdir /db/app/oracle/oradata
mkdir /db/app/oracle/oraInventory
mkdir /db/app/oracle/fast_recovery_area
chown -R oracle:oinstall /db/app/oracle
chmod -R 775 /db/app/oracle

cat >> /etc/oraInst.loc <<EOF
inventory_loc=/db/app/oracle/oraInventory
inst_group=oinstall
EOF
######################### 安装vnc ，调用centos可视化界面
yum install tigervnc-server

systemctl enable [email protected]:1.service

systemctl start [email protected]:1.service
systemctl stop [email protected]:1.service
###################################

mkdir /home/oracle/etc/
cp /home/oracle/database/response/* /home/oracle/etc/
chmod 777 /home/oracle/etc/*.rsp

##########切换用户
su – oracle
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

##########################调用本机xshell
##############192.168.1.14 为本地xshell客户端ip地址
export DISPLAY=192.168.1.14:0.0
xhost +

#################单机版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

############安装完毕，使用可视化工具登录