Oracle篇：Oracle安装前自动配置脚本

一时失言乱红尘 2024-03-16 19:09 48阅读 0赞

### 介绍 ###

为了加快安装Oracle的速度，也为了能够偷个懒，不用再手动复制大量的命令去执行，我就写了个简单的Shell的脚本，自动执行Oracle安装前所需要执行的命令。

### 说明 ###

脚本首先会检查oracle用户是否存在，如果存在，则直接退出，否则，会执行以下步骤：

*  创建oracle用户
 *  配置redhat-release
 *  检查firewalld的状态。如果firewalld是运行状态，则开放指定的端口并重启；反之，则不执行任何操作。
 *  检查selinux的状态。如果selinux状态不是disable，则立即改为disable状态，并配置到/etc/selinux/config中。
 *  配置内核参数
 *  配置用户资源限制
 *  配置oracle用户的环境变量

注意，在脚本执行后，需要手动去安装oracle所需要的依赖。否则，在安装时先决条件检查会出现大量的错误。

CentOS 7 安装依赖

`shell [root@localhost home]# yum install binutils* compat* gcc* glibc* ksh* libaio* libgcc* libstdc* libXi* libXtst* make* sysstat* elfutils*`

\`\`\`

### 参数 ###

脚本有以下需要根据实际环境手动去配置的参数：

*  HOME 指定安装Oracle的目录位置，会在此目录创建oracle、database和oraInventory目录
 *  ORACLE\_PASSWD 指定创建oracle用户的密码
 *  ORACLE\_SID 指定配置到oracle用户环境变量的SID
 *  PORT 指定要开放的端口号，通常是1521
 *  MEM\_PERCENTAGE 指定内核参数kernel.shmall和kernel.shmmax的大小，大小会基于操作系统的内存的百分比计算。例如指定80，则会指定成内存的80%。单实例建议设置为85%

### 脚本内容如下： ###

\`\`\`shell

## !/bin/bash ##

## Date:2021-01-10 ##

## Author:Created by b ##

## Version:1.0 ##

## Describe:Automatically configure the configuration required for Oracle installation ##

HOME="/home" ORACLE*PASSWD="123456" ORACLE*SID=orcl PORT=1521 MEM\_PERCENTAGE=85

function User*Create()\{ groupadd oinstall groupadd dba useradd -g oinstall -g dba -m oracle groups oracle > /dev/null echo $\{ORACLE*PASSWD\} | passwd --stdin oracle > /dev/null echo "=============== User created success ===============" \}

function Directory\_Create()\{

mkdir -p $\{HOME\}/oracle mkdir -p $\{HOME\}/oraInventory mkdir -p $\{HOME\}/database chown -R oracle:oinstall $\{HOME\}/oracle chown -R oracle:oinstall $\{HOME\}/oraInventory chown -R oracle:oinstall $\{HOME\}/database echo "=============== Directory created successfully ==============="

function System*Version*Update()\{ echo "redhat-7" > /etc/redhat-release

function Port*Configure()\{ local temp*parameter=$(systemctl status firewalld | grep Active |awk '\{printf($2)\}')

if \[ $temp\_parameter == "active" \] then firewall-cmd --permanent --zone=public --add-port=1521/tcp > /dev/null systemctl restart firewalld

echo "=============== port ${PORT} configure successfully ==============="
    else
      echo "---------- Firewalld has been disabled  ----------"

function Selinux*Configure()\{ local temp*parameter=$(getenforce)

if \[ $\{temp*parameter\} == "Enforcing" \] || \[ $\{temp*parameter\} == "Permissive" \] then setenforce 0 sed -i 's\#SELINUX=.\*\#SELINUX=disabled\#' /etc/selinux/config echo "=============== selinux configure successfully ===============" else echo "---------- selinux does not require configuration ----------" fi

function Kernel*Configure()\{ local kernel*shmmax=$(cat /proc/meminfo | grep "MemTotal:" |awk -v mem=$\{MEM*PERCENTAGE\} '\{printf($2\*1024/100\*mem)\}' |awk '\{printf("%d",$0)\}') local kernel*shmall=$(cat /proc/meminfo | grep "MemTotal:" |awk -v mem=$\{MEM\_PERCENTAGE\} '\{printf($2*1024/100*mem)/4096\}' |awk '\{printf("%d",$0)\}')

if \[ $\{kernel*shmall\} -le 2097152 \]; then kernel*shmall=2097152 fi

echo "net.ipv4.icmp*echo*ignore*broadcasts = 1" >> /etc/sysctl.conf echo "net.ipv4.conf.all.rp*filter = 1" >> /etc/sysctl.conf echo "fs.file-max = 6815744" >> /etc/sysctl.conf echo "fs.aio-max-nr = 1048576" >> /etc/sysctl.conf echo "kernel.shmall = $\{kernel*shmall\}" >> /etc/sysctl.conf echo "kernel.shmmax = $\{kernel*shmmax\}" >> /etc/sysctl.conf echo "kernel.shmmni = 4096" >> /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= 1048576" >> /etc/sysctl.conf

sysctl -p > /dev/null

echo "=============== kernel configure successfully ==============="

function User*Resource*Configure()\{

echo "session required /lib/security/pam\_limits.so" >>/etc/pam.d/login 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 'if \[ $USER = "oracle" \] || \[ $USER = "grid" \] ; then' >> /etc/profile echo ' if \[ $SHELL = "/bin/ksh" \]; then' >> /etc/profile echo ' ulimit -p 16384' >> /etc/profile echo ' ulimit -n 65536' >> /etc/profile echo ' else' >> /etc/profile echo ' ulimit -u 16384 -n 65536' >> /etc/profile echo ' fi' >> /etc/profile echo 'fi' >> /etc/profile

echo "=============== user resource configure successfully ===============" \}

function Oracle*Env*Configure()\{

echo "export ORACLE*BASE=$\{HOME\}/oracle">> /home/oracle/.bash*profile echo "export ORACLE*HOME=$\{HOME\}/oracle/app/oracle/product/11.2.0/dbhome*1">> /home/oracle/.bash*profile echo "export ORACLE*SID=$\{ORACLE*SID\}">> /home/oracle/.bash*profile echo "export ORACLE*TERM=xterm">> /home/oracle/.bash*profile echo "export PATH=\\$ORACLE*HOME/bin:/usr/sbin:\\$PATH">> /home/oracle/.bash*profile echo "export LD*LIBRARY*PATH=\\$ORACLE*HOME/lib:/lib:/usr/lib">> /home/oracle/.bash*profile echo "export LANG=C">> /home/oracle/.bash*profile echo "export NLS*LANG=AMERICAN*AMERICA.ZHS16GBK">> /home/oracle/.bash*profile source /home/oracle/.bash\_profile

echo "=============== configure oracle environment successfully ==============="

function main()\{ if \[ "$(grep -o "^oracle" /etc/passwd)" = oracle \] then echo "User already exists ! " else User*Create Directory*Create System*Version*Update Port*Configure Selinux*Configure Kernel*Configure User*Resource*Configure Oracle*Env\_Configure echo "After the initial configuration is complete, install Oracle dependencies"  
fi

main \`\`\`