1.配置好yum yum -y install libXp yum -y install libaio 2.按照自己的需求修改chprofile文件内的SID 3.rpm -ivh rlwrap-0.30-1.el5.i386.rpm 4.执行脚本 #install目录下存放了一下脚本:adduser.sh、chprofile.sh、install.sh、limits.sh、mkdir.sh、sysctl.sh ./install adduser脚本内容 #/bin/bash ADDGROUPS="oinstall dba" ADDUSERS="oracle" for group in $ADDGROUPS ; do if [ -z "$( awk -F: '{print $1}' /etc/group |grep $group)" ]; then groupadd $group echo " Add new group $group" else echo " Group $group already existed" fi done for user in $ADDUSERS ; do if [ -z "$( awk -F: '{print $1}' /etc/passwd |grep $user)" ]; then useradd $user echo " Add new user $user" else echo " User $user already existed" fi done if $(usermod -g oinstall -G dba oracle) ; then echo " Modify user oracle account success" else echo " Modify user oracle account failure" fi chprofile脚本内容 #/bin/bash PROFILES="/home/oracle/.bashrc" for PROFILE in $PROFILES ; do if [ -f "$PROFILE" ] ; then if [ -z "$(grep "Oracle" $PROFILE)" ] ; then cat >>$PROFILE << END # Oracle configure profile parameters success export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=\$ORACLE_BASE/product/10.2.0/db_1 export PATH=\$ORACLE_HOME/bin:\$PATH export ORACLE_OWNER=oracle export ORACLE_SID=cctv export ORACLE_TERM=vt100 export THREADS_FLAG=native export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:\$LD_LIBRARY_PATH export PATH=\$ORACLE_HOME/bin:\$PATH export SQLPATH=/home/oracle export EDITOR=vi alias sqlplus='rlwrap sqlplus' # # change this NLS settings to suit your country: # example: # german_germany.we8iso8859p15, american_america.we8iso8859p2 etc. # export LANG=en_US END echo " Add Oracle configure $PROFILE parameters success" else echo " Oracle configure $PROFILE parameters already existed" fi else echo "$0: $PROFILE not found " fi done install脚本内容 #/bin/bash . ./adduser.sh . ./sysctl.sh . ./limits.sh . ./mkdir.sh . ./chprofile.sh limits脚本内容 #/bin/bash LIMITS_FILE="/etc/security/limits.conf" if [ -f "$LIMITS_FILE" ] ; then if [ -z "$(grep "Oracle" $LIMITS_FILE)" ] ; then cat >>$LIMITS_FILE << END #Oracle configure shell parameters oracle soft nofile 65536 oracle hard nofile 65536 oracle soft nproc 16384 oracle hard nproc 16384 END echo " Add Oracle configure shell parameters success" else echo " Oracle configure shell parameters already existed" fi else echo "$0: $LIMITS_FILE not found " fi mkdir脚本内容 #/bin/bash ORACLE_FILE_BASE="/u01/app/oracle" ORACLE_FILE_VAR="/var/opt/oracle" ORACLE_FILE_HOME="$ORACLE_FILE_BASE/product/10.2.0/db_1" for directory in $ORACLE_FILE_BASE $ORACLE_FILE_VAR $ORACLE_FILE_HOME ; do if [ -d $directory ]; then echo " Directory $directory already existed" else mkdir -p $directory chown -R oracle.dba $directory echo " Change directory $directory owner and group success" fi done sysctl脚本内容 #/bin/bash # echo 250 32000 100 128 > /proc/sys/kernel/sem # echo 536870912 > /proc/sys/kernel/shmmax # echo 4096 > /proc/sys/kernel/shmmni # echo 2097152 > /proc/sys/kernel/shmall # echo 65536 > /proc/sys/fs/file-max # echo 1024 65000 > /proc/sys/net/ipv4/ip_local_port_range SYSCTL_FILE="/etc/sysctl.conf" RCLOCAL_FILE="/etc/rc.local" if [ -f "$SYSCTL_FILE" ] ; then if [ -z "$(grep "Oracle" $SYSCTL_FILE)" ] ; then cat >>$SYSCTL_FILE << END #Oracle configure kernel parameters kernel.shmmax = 2147483648 kernel.shmmni = 4096 kernel.shmall = 2097152 kernel.sem = 250 32000 100 128 fs.file-max = 65536 net.ipv4.ip_local_port_range = 1024 65000 net.core.rmem_default = 262144 net.core.rmem_max = 262144 net.core.wmem_default = 262144 net.core.wmem_max = 262144 END /sbin/sysctl -p echo " Add Oracle configure kernel parameters success" else echo " Oracle configure kernel parameters already existed" fi else if [ -z "$(grep "Oracle" $RCLOCAL_FILE)" ] ; then cat >>$RCLOCAL_FILE << END #Oracle configure kernel parameters echo 536870912 > /proc/sys/kernel/shmmax echo 4096 > /proc/sys/kernel/shmmni echo 2097152 > /proc/sys/kernel/shmall echo 250 32000 100 128 > /proc/sys/kernel/sem echo 65536 > /proc/sys/fs/file-max echo 1024 65000 > /proc/sys/net/ipv4/ip_local_port_range END . $RCLOCAL_FILE echo " Add Oracle configure kernel parameters success" else echo " Oracle configure kernel parameters already existed" fi fi
用shell脚本配置oracle安装需求
原创文章标签 用shell脚本配置oracle安装需求 文章分类 Oracle 数据库
-
shell脚本安装Oracle(docker版)
#!/bin/bash<<INFOAUTHOR:运维@小兵DATE:2021-08-16DESCRIBE:Docker方式安装OracleSYSTEM:CentOS7/RedHat7W
shell shell安装Oracle oracle docker json -
shell脚本安装Oracle(rpm版)
参考文章linux安装Oracle11GOracle 设置开机自启动脚本#!/bin/bash# vim:sw=4:ts=4:et<<INFOAUTHOR:运维@小兵DATE:20
oracle linux shell安装Oracle sed