共计 58220 个字符，预计需要花费 146 分钟才能阅读完成。
| #!/bin/bash | |
| ## Linux7 上装置 Oracle 数据库一键配置脚本 | |
| # 装置介质所在目录 | |
| # You must put the installation package in the /tmp/soft directory, Like this: | |
| # /tmp/soft/ | |
| # ├── 11 | |
| # ├── 12 | |
| # ├── 19 | |
| # │ ├── LINUX.X64_193000_db_home.zip | |
| # │ ├── LINUX.X64_193000_grid_home.zip | |
| # │ ├── p34773504_190000_Linux-x86-64_OJVM+GI_RU_19.18.0.0.230117.zip | |
| # │ ├── p6880880_190000_Linux-x86-64-OPatch_12.2.0.1.36.zip | |
| # │ └── patch | |
| # │ ├── 34762026 | |
| # │ ├── 34786990 | |
| # │ ├── PatchSearch.xml | |
| # │ └── README.html | |
| # └── compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm | |
| # 定义变量 | |
| # db_type | si/SI -- 单实例；rac/RAC --RAC(两节点) | |
| export db_type=RAC | |
| # 定义 Public IP、Virtual IP、SCAN IP 等业务网段 IP 地址信息 | |
| export PubIP1=192.168.11.31 | |
| export hostname1=Jeff-Test-RAC01 | |
| export PubIP2=192.168.11.32 | |
| export hostname2=Jeff-Test-RAC02 | |
| export VIP1=192.168.11.33 | |
| export VIP1NAME=Jeff-Test-VIP1 | |
| export VIP2=192.168.11.34 | |
| export VIP2NAME=Jeff-Test-VIP2 | |
| export SCANIP=192.168.11.35 | |
| export SCANNAME=Jeff-Test-SCAN | |
| # Pub_Mask 业务网络子网掩码，数字 23 或者 255.255.254.0 均反对 | |
| export Pub_Mask=23 | |
| export scanPort=1525 | |
| export cluster_name=Jeff-Test | |
| export ORA_SID_PREFIX=Jeff0 | |
| export DB_NAME=Jeff | |
| export DB_UNIQUE_NAME=JeffTest | |
| export ORA_SID1=Jeff01 | |
| export ORA_SID2=Jeff02 | |
| # 定义心跳网络 Private IP 信息 | |
| export PrivIP1=11.11.11.31 | |
| export Priv1NAME=Jeff-Test-Priv1 | |
| export PrivIP2=11.11.11.32 | |
| export Priv2NAME=Jeff-Test-Priv2 | |
| # Priv_Mask 心跳网络子网掩码，数字 23 或者 255.255.254.0 均反对 | |
| export Priv_Mask=24 | |
| # ntpserver 用于配置 chronyd 服务 | |
| export ntpserver=11.11.11.1 | |
| # oraver: 装置的数据库版本:11、12、18、19、23 | |
| export oraver=19 | |
| # 指定 root 明码、oracle&grid 明码、DB 治理明码 | |
| export rootpw="Test01" | |
| export ORAPWD="Oracle_19C" # oracle && grid 设置雷同明码 | |
| export db_admin_pwd="Oracle_19C" # 预设数据库治理应用的对立明码 | |
| # needcdb 指定是否 Y(y) 须要 CDB 容器数据库，needpdb 是否 Y(y) 须要创立 PDB（限度创立 1 个）,PDB_SID 指定 PDB 名字 | |
| export needcdb=Y | |
| export needpdb=y | |
| export PDB_SID=Jeff_PDB | |
| # 指定内存、FRA 参数设置，如下是很小的参数了，再小会导致装置失败 | |
| export sgasize=1800MB | |
| export sga_max_size=2000MB | |
| export pgasize=600MB | |
| export recovery_size=18000MB | |
| export processes=5000 | |
| # 软件装置目录设置 | |
| export rootdir=/u01 | |
| export ORA_BASE=$rootdir/app/oracle | |
| export ORA_HOME=$ORA_BASE/product/19.3.0/db_1 | |
| export ORA_INV=$rootdir/app/oraInventory | |
| export GI_BASE=$rootdir/app/grid | |
| export GI_HOME=$rootdir/app/19.3.0/grid | |
| export logfile=/tmp/install_$(date +%F).log | |
| # ASM 磁盘组调配 | |
| # mapper_dir 指定提供给 ASM 治理的磁盘辨认门路, 或者 /dev/mapper 等 | |
| export mapper_dir=/dev | |
| # sd : 提供给 ASM 治理的磁盘前缀 | |
| export mapper_prefix=sd | |
| # asm_ocr_disks: OCR\Voting 磁盘组, 多组应用空格 \,\; 等字符隔开，倡议命令行应用,，不容易凌乱；不写前缀 | |
| export asm_ocr_disks="b c d" | |
| export asm_ocr_dir=OCR | |
| # asm_fra_disks: 归档日志、闪回区 磁盘组 | |
| export asm_fra_disks="e f g" | |
| export asm_fra_dir=FRA | |
| # asm_data_disks: 数据文件 磁盘组；默认 redo 寄存 $asm_data_dir 和 $asm_fra_dir，须要另外配置则调整脚本 | |
| export asm_data_disks="h" | |
| export asm_data_dir=DATA | |
| # 指定是否须要格式化磁盘 Y(y) 格式化，其余不执行 | |
| export need_format=y | |
| # 装置介质指定 | |
| export softroot=/tmp/soft | |
| export softdir=$softroot/$oraver | |
| export db_zip_file=LINUX.X64_193000_db_home.zip | |
| export grid_zip_file=LINUX.X64_193000_grid_home.zip | |
| export opatch_zip_file=p6880880_190000_Linux-x86-64-OPatch_12.2.0.1.36.zip | |
| export ru=34762026 | |
| ############################################ 以上是主要参数定义，以下局部可不设置 ############################################ | |
| # 以下局部没有参数设置 | |
| split1() {echo -e "\033[1;40;33m\n\n ===================================== $(date +'%F %T') =====================================\n$1\033[0m"} | |
| result_err() {echo -e "\033[5;31m\n (*>﹏<*)(*>﹏<*)(*>﹏<*) $1 (*>﹏<*)(*>﹏<*)(*>﹏<*)\n\033[0m"} | |
| result_ok() {echo -e "\n\033[32m (*^_^*)(*^_^*)(*^_^*) $1 (*^_^*)(*^_^*)(*^_^*)\033[0m\n"} | |
| # db_zip_file 默认值 LINUX.X64_193000_db_home.zip | |
| if [-z ${db_zip_file} ];then | |
| db_zip_file=LINUX.X64_193000_db_home.zip | |
| fi | |
| # grid_zip_file 默认值 LINUX.X64_193000_grid_home.zip | |
| if [-z ${grid_zip_file} ];then | |
| grid_zip_file=LINUX.X64_193000_grid_home.zip | |
| fi | |
| # opatch_zip_file 默认值 p6880880_190000_Linux-x86-64.zip，每次下载最新文件 | |
| if [-z ${opatch_zip_file} ];then | |
| opatch_zip_file=p6880880_190000_Linux-x86-64.zip | |
| fi | |
| # 须要 apply 的 RU，不 apply 则置空 | |
| export ru_zip_file=$softdir/p${ru}*.zip | |
| # 辨认 RU 对应的 zip 文件 | |
| export RUs=$softdir/patch/$ru | |
| # 装置时须要同时装置的 RU 绝对路径 | |
| if [-d $softroot] && [! -d $softdir/patch];then | |
| mkdir -p $softdir/patch | |
| fi | |
| echo "################ Begin : $(date +'%F %T') ################">$logfile | |
| chmod -R 777 $softroot | |
| export db_install_file=$softdir/$db_zip_file | |
| export grid_install_file=$softdir/$grid_zip_file | |
| export opatch_install_file=$softdir/$opatch_zip_file | |
| export upper_db_type=$(echo $db_type | tr [:lower:] [:upper:]) | |
| if [! -f ${db_install_file} ];then | |
| result_err "Error: DB install file not found!" >>$logfile | |
| exit 1 | |
| elif [${upper_db_type} == "RAC" ] && [! -f ${grid_install_file} ];then | |
| result_err "You select Db type as RAC, But can not found GRID install file!">>$logfile | |
| exit 1 | |
| elif [-n ${ru} ] && [! -f ${ru_zip_file} ];then | |
| result_err "You Want to apply an RU, But not found zip file!">>$logfile | |
| exit 1 | |
| if [! -f ${opatch_install_file} ];then | |
| result_err "You choose to apply RU and must update OPatch">>$logfile | |
| exit 1 | |
| fi | |
| fi | |
| split1 "# 依照输出参数解析各文件压缩包名如下，The input installation media is analyzed as follows: | |
| DB install file: $db_install_file | |
| GRID install file: $grid_install_file | |
| OPatch install file: $opatch_install_file | |
| RU zip file: $ru_zip_file">>$logfile | |
| split1 "# 依照输出参数解析各文件压缩包名如下，The input installation media is analyzed as follows: | |
| DB install file: $db_install_file | |
| GRID install file: $grid_install_file | |
| OPatch install file: $opatch_install_file | |
| RU zip file: $ru_zip_file" | |
| sleep 5 | |
| # 如下实现掩码数字计算:255.255.254.0 转换 23 | |
| export tmp1=$(echo $Pub_Mask | grep -o '\.' | wc -l) | |
| if [$tmp1 -eq 3]; then | |
| export Pub_Mask=$(echo $Pub_Mask | sed 's/\./ + /g;s/255/8/g;s/254/7/g;s/252/6/g;s/248/5/g;s/240/4/g;s/224/3/g;s/192/2/g;s/128/1/g' | bc) | |
| elif [$tmp1 -gt 0]; then | |
| result_err "# 请输出正确的 Public 网卡子网掩码 ($Pub_Mask)">>$logfile | |
| exit 1 | |
| elif [$Pub_Mask -lt 32] && [$Pub_Mask -gt 1] && [$tmp1 -eq 0]; then | |
| echo -e | |
| else | |
| result_err "# 请输出正确的 Public($Pub_Mask) 网卡掩码位数字 2-31">>$logfile | |
| exit 1 | |
| fi | |
| echo "# SCAN_IP: $SCANIP/$Pub_Mask" >>$logfile | |
| export tmp2=$(echo $Priv_Mask | grep -o '\.' | wc -l) | |
| if [$tmp2 -eq 3]; then | |
| export Priv_Mask=$(echo $Priv_Mask | sed 's/\./ + /g;s/255/8/g;s/254/7/g;s/252/6/g;s/248/5/g;s/240/4/g;s/224/3/g;s/192/2/g;s/128/1/g' | bc) | |
| elif [$tmp2 -gt 0]; then | |
| result_err "# 请输出正确的 Private 网卡子网掩码 ($Priv_Mask)">>$logfile | |
| exit 1 | |
| elif [$Priv_Mask -lt 32] && [$Priv_Mask -gt 1] && [$tmp2 -eq 0]; then | |
| echo -e | |
| else | |
| result_err "# 请输出正确的 Private($Priv_Mask) 网卡掩码位数字 2-31">>$logfile | |
| exit 1 | |
| fi | |
| echo "# PrivIP1: $PrivIP1/$Priv_Mask" >>$logfile | |
| # 获取子网函数 | |
| get_ipgate() { | |
| #ip 地址转换整数 | |
| ipgate_int=$(echo $1 | awk -F'.' '{print $1*(256^3) + $2*(256^2) + $3*256 + $4}') | |
| #主机位:32 - $2 | |
| #按位运算，右移，ip 地址移除主机位，保留网络位 | |
| #按位运算，左移，ip 地址以 0 补全主机位 | |
| ((ipgate = ((ipgate_int >> ((32 - $2)))) << ((32 - $2)))) | |
| #获取子网: 整数转换 ip 地址, 整数右移取低 8 位 | |
| echo $((ipgate >> 24 & 0xFF)).$((ipgate >> 16 & 0xFF)).$((ipgate >> 8 & 0xFF)).$((ipgate & 0xFF)) | |
| } | |
| export scan_subnet=$(get_ipgate $SCANIP $Pub_Mask) | |
| export priv_subnet=$(get_ipgate $PrivIP1 $Priv_Mask) | |
| echo "# pub-subnet: $scan_subnet ; Priv-subnet: $priv_subnet">>$logfile | |
| netcard_name() { | |
| findIP=$1 | |
| # 依照网卡名行，结尾为数字编号，进行过滤抉择 | |
| for devEnum in $(ip link show | grep ^[0-9]\\+: | awk -F '' {'print $2'}); do | |
| # 去掉后缀冒号 | |
| devName=${devEnum%:} | |
| # 去掉可能的子网卡接口后缀 | |
| devName=${devName%@*} | |
| if [$(ip addr show $devName | grep -c $findIP) -gt 0 ]; then | |
| echo $devName | |
| break | |
| fi | |
| done | |
| } | |
| if ["$(hostname)" == "$hostname1" ]; then | |
| pub_netcard=$(netcard_name $PubIP1) | |
| priv_netcard=$(netcard_name $PrivIP1) | |
| echo "# pub_netcard: $pub_netcard ; priv_netcard: $priv_netcard" >>$logfile | |
| fi | |
| # 提取 ASM 磁盘信息，转换后提供 for 循环应用 (-->21 asm 配置) | |
| export asm_ocr_disks=$(echo $asm_ocr_disks | sed 's/,/ /g' | sed 's/\./ /g' | sed 's/;/ /g' | sed 's/\// /g' | sed 's/\\/ /g') | |
| export asm_fra_disks=$(echo $asm_fra_disks | sed 's/,/ /g' | sed 's/\./ /g' | sed 's/;/ /g' | sed 's/\// /g' | sed 's/\\/ /g') | |
| export asm_data_disks=$(echo $asm_data_disks | sed 's/,/ /g' | sed 's/\./ /g' | sed 's/;/ /g' | sed 's/\// /g' | sed 's/\\/ /g') | |
| # 确认长期安装文件存储目录 /tmp 存在，且可用空间大于 10GB | |
| echo "# $(hostname) 查看 /tmp 目录存在，且可用空间大于 10GB:" >>$logfile | |
| if [! -d /tmp]; then | |
| echo "# /tmp Filesystem does not exist,Create it." >>$logfile | |
| mkdir /tmp | |
| fi | |
| export tmpsizemb=$(cd /tmp && df -PmT . | grep -v Filesystem | awk '{print $5}') | |
| if [$tmpsizemb -lt 10240]; then | |
| cd /tmp && df -PmT . | |
| result_err "# /tmp Filesystem has size $tmpsizemb MB, less than 10G, exit this scripts." | |
| result_err "# /tmp Filesystem has size $tmpsizemb MB, less than 10G, exit this scripts." >>$logfile | |
| exit 1 | |
| fi | |
| # 0. yum 查看及装置依赖包 | |
| split1 "# 0. 查看 yum 装置源是否可用, 并装置依赖包 ($(hostname)):" | |
| if [$(hostname) == "$hostname1" ]; then | |
| split1 "# 0. 查看 yum 装置源是否可用, 并装置依赖包 ($(hostname)):" >>$logfile | |
| echo '#!/bin/bash' >/tmp/yumlist.sh | |
| cat >>/tmp/yumlist.sh <<yumlist | |
| export yumlist=\$(yum list 2>/dev/null | wc -l) | |
| if [\$yumlist -gt 2000]; then | |
| export yumusable=1 | |
| echo "# yum avaliable on \$(hostname)" | |
| else | |
| export yumusable=0 | |
| echo "# YUM Unavailable on \$(hostname), Try to mount /dev/cdrom make it available" | |
| if [-h /dev/cdrom];then | |
| echo "# /dev/cdrom exist, mount it to /mnt for use" | |
| mount /dev/cdrom /mnt/ | |
| if [! -d /etc/yum.repos.d/bak]; then | |
| mkdir /etc/yum.repos.d/bak | |
| fi | |
| mv /etc/yum.repos.d/*.repo /etc/yum.repos.d/bak/ | |
| echo "[Local_mnt] | |
| name=Local_mnt | |
| baseurl=file:///mnt | |
| enabled=1 | |
| gpgcheck=0" >/etc/yum.repos.d/Local_mnt.repo | |
| yum -y clean all | |
| yum makecache | |
| else | |
| echo "# /dev/cdrom does not exist, do nothing." | |
| fi | |
| if [\$(yum list 2>/dev/null | wc -l) -lt 2000 ];then | |
| echo "# Yum is not available on \$(hostname), try Failed" | |
| exit 1 | |
| fi | |
| fi | |
| # Install need rpms | |
| echo "# Installing need rpms on \$(hostname) ... ..." | |
| sleep 5 | |
| yum install -y bc binutils compat-libcap1 compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libXrender libXrender-devel libX11 libXau libXi libXtst libgcc libstdc++ libstdc++-devel libxcb make policycoreutils policycoreutils-python smartmontools sysstat net-tools nfs-utils python python-configshell python-rtslib python-six targetcli xorg-x11-xauth xorg-x11-fonts-* xorg-x11-font-utils xorg-x11-fonts-Type1 xorg-x11-apps xclock ncurses-devel redhat-lsb-core readline-devel vim-enhanced bzip2 chrony iotop xterm lsof tree expect gcc-c++ zip unzip 2>/dev/null | |
| yumlist | |
| chmod 777 /tmp/yumlist.sh | |
| sh /tmp/yumlist.sh >>$logfile | |
| if [$? -ne 0]; then | |
| result_err "# $PubIP1 执行 yumlist.sh, Failed" | |
| result_err "# $PubIP1 执行 yumlist.sh, Failed" >>$logfile | |
| cat /tmp/yumlist.sh >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# $PubIP1 执行 yumlist.sh, successful" | |
| result_ok "# $PubIP1 执行 yumlist.sh, successful" >>$logfile | |
| fi | |
| expect >>$logfile <<EOF | |
| set timeout 100 | |
| spawn ssh -o StrictHostKeyChecking=no $PubIP2 | |
| expect {"(yes/no)" {send "yes\r"; exp_continue} | |
| "password:" {send "$rootpw\r"} | |
| } | |
| expect "root@*" {send "if \[ ! -d /tmp \]; then mkdir /tmp; fi\r"} | |
| expect "root@*" {send "exit\r"} | |
| expect eof | |
| EOF | |
| # 近程 $hostname2 做雷同脚本 | |
| # 拷贝脚本到对端 | |
| echo "# 近程 $hostname2 执行雷同 yumlist 脚本" | |
| echo "# 近程 $hostname2 执行雷同 yumlist 脚本" >>$logfile | |
| if [$(grep $PubIP2 ~/.ssh/authorized_keys 2>/dev/null | wc -l) -lt 1 ];then | |
| expect >>$logfile <<EOF | |
| set timeout 100 | |
| spawn scp /tmp/yumlist.sh $PubIP2:/tmp/ | |
| expect {"password:" {send "$rootpw\r"} | |
| } | |
| expect eof | |
| EOF | |
| else | |
| scp /tmp/yumlist.sh $PubIP2:/tmp/ | |
| fi | |
| if [$? -ne 0]; then | |
| result_err "# scp yumlist.sh 到 $PubIP2, Failed" | |
| result_err "# scp yumlist.sh 到 $PubIP2, Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# scp yumlist.sh 到 $PubIP2, successful" | |
| result_ok "# scp yumlist.sh 到 $PubIP2, successful" >>$logfile | |
| fi | |
| # 执行脚本 | |
| expect >>$logfile <<EOF | |
| set timeout 100 | |
| spawn ssh $PubIP2 | |
| expect {"password:" {send "$rootpw\r"} | |
| } | |
| expect "root@*" {send "sh /tmp/yumlist.sh\r"} | |
| expect "root@*" {send "exit\r"} | |
| expect eof | |
| EOF | |
| if [$? -ne 0]; then | |
| result_err "# $PubIP2 执行 yumlist.sh, Failed" | |
| result_err "# $PubIP2 执行 yumlist.sh, Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# $PubIP2 执行 yumlist.sh, successful" | |
| result_ok "# $PubIP2 执行 yumlist.sh, successful" >>$logfile | |
| fi | |
| else | |
| result_err "# Please run this script on $hostname1 node!" | |
| result_err "# Please run this script on $hostname1 node!" >>$logfile | |
| exit 1 | |
| fi | |
| # 1. 配置 hosts | |
| split1 "# 1. 配置 $(hostname) /etc/hosts 文件:" | |
| split1 "# 1. 配置 $(hostname) /etc/hosts 文件:" >>$logfile | |
| hostnamectl set-hostname $hostname1 --static | |
| cp /etc/hosts /etc/hosts_$(date +"%Y%m%d_%H%M%S") | |
| sed -i "/IP\|^$\|$PubIP1\|$PubIP2\|$PrivIP1\|$PrivIP2\|$VIP1\|$VIP2\|$SCANIP/d" /etc/hosts | |
| echo "# Public IP | |
| $PubIP1 $hostname1 | |
| $PubIP2 $hostname2 | |
| # Private IP | |
| $PrivIP1 $Priv1NAME | |
| $PrivIP2 $Priv2NAME | |
| # Virtual IP (VIP) | |
| $VIP1 $VIP1NAME | |
| $VIP2 $VIP2NAME | |
| # SCAN IP | |
| $SCANIP $SCANNAME" >>/etc/hosts | |
| cat /etc/hosts >>$logfile | |
| # 拷贝脚本到对端 | |
| echo "# 拷贝 /etc/hosts 文件到 $hostname2 :" | |
| echo "# 拷贝 /etc/hosts 文件到 $hostname2 :" >>$logfile | |
| expect >>$logfile<< EOF | |
| set timeout 100 | |
| spawn scp /etc/hosts $PubIP2:/etc/ | |
| expect {"password:" {send "$rootpw\r"} | |
| } | |
| expect eof | |
| EOF | |
| # 执行脚本 | |
| expect >>$logfile << EOF | |
| set timeout 100 | |
| spawn ssh $PubIP2 | |
| expect {"password:" {send "$rootpw\r"} | |
| } | |
| expect "root@*" {send "hostnamectl set-hostname $hostname2 --static\r"} | |
| expect "root@*" {send "exit\r"} | |
| expect eof | |
| EOF | |
| # 2. 配置 OS 组及用户 | |
| # https://docs.oracle.com/en/database/oracle/oracle-database/19/cwsol/example-of-creating-minimal-groups-users-paths.html#GUID-103186A1-74E0-42A8-AC3D-15AF833DCB40 | |
| split1 "# 2. 配置 OS 组及用户 on $(hostname) :" | |
| split1 "# 2. 配置 OS 组及用户 on $(hostname) :" >>$logfile | |
| echo '#!/bin/bash' >/tmp/usergrp.sh | |
| cat >>/tmp/usergrp.sh <<userg | |
| echo "# \$(hostname) 配置 OS 组及用户:" | |
| groupadd -g 54321 oinstall | |
| groupadd -g 54322 dba | |
| groupadd -g 54323 oper | |
| groupadd -g 54324 backupdba | |
| groupadd -g 54325 dgdba | |
| groupadd -g 54326 kmdba | |
| groupadd -g 54327 asmdba | |
| groupadd -g 54328 asmoper | |
| groupadd -g 54329 asmadmin | |
| groupadd -g 54330 racdba | |
| u1=\$(grep oracle /etc/passwd | wc -l) | |
| u2=\$(grep oracle /etc/passwd | wc -l) | |
| if [\$u1 -ge 1]; then | |
| userdel oracle | |
| fi | |
| if [\$u2 -ge 1]; then | |
| userdel grid | |
| fi | |
| useradd -g oinstall -G dba,oper,backupdba,dgdba,kmdba,asmdba,asmoper,asmadmin,racdba -u 1000 -m oracle | |
| useradd -g oinstall -G dba,asmdba,asmoper,asmadmin,racdba -u 1001 -m grid | |
| echo "$ORAPWD" | passwd --stdin oracle | |
| echo "$ORAPWD" | passwd --stdin grid | |
| mkdir -p $GI_HOME | |
| mkdir -p $GI_BASE | |
| mkdir -p $ORA_BASE | |
| mkdir -p $ORA_HOME | |
| mkdir -p $ORA_INV | |
| chown -R grid:oinstall $rootdir | |
| chown -R oracle:oinstall $ORA_BASE | |
| chmod -R 775 $rootdir | |
| userg | |
| chmod +x /tmp/usergrp.sh; sh /tmp/usergrp.sh >>$logfile | |
| # 拷贝脚本到 $hostname2 并执行 | |
| echo "# 拷贝脚本 /tmp/usergrp.sh 到 $hostname2 并执行:" | |
| echo "# 拷贝脚本 /tmp/usergrp.sh 到 $hostname2 并执行:" >>$logfile | |
| expect >>$logfile << EOF | |
| set timeout 100 | |
| spawn scp /tmp/usergrp.sh $PubIP2:/tmp/ | |
| expect {"(yes/no)" {send "yes\r"; exp_continue} | |
| "password:" {send "$rootpw\r"} | |
| } | |
| expect eof | |
| EOF | |
| # 执行脚本 | |
| expect >>$logfile << EOF | |
| set timeout 100 | |
| spawn ssh $PubIP2 | |
| expect {"password:" {send "$rootpw\r"} | |
| } | |
| expect "root@*" {send "sh /tmp/usergrp.sh\r"} | |
| expect "root@*" {send "exit\r"} | |
| expect eof | |
| EOF | |
| # 3. 设置环境变量配置文件 | |
| split1 "# 3. 设置环境变量配置文件 .bash_profile:" | |
| split1 "# 3. 设置环境变量配置文件 .bash_profile:" >>$logfile | |
| if ["$(hostname)" == "$hostname1" ]; then | |
| # For root on node01 | |
| sed -i '/ORACLE_HOME/d' /root/.bash_profile | |
| echo "export ORACLE_HOME=$GI_HOME | |
| export GRID_HOME=\$ORACLE_HOME | |
| export PATH=\$PATH:\$ORACLE_HOME/bin:\$ORACLE_HOME/OPatch" >>/root/.bash_profile | |
| echo -e "# root: \n$(cat /root/.bash_profile)\n" >>$logfile | |
| # For root on node02 | |
| expect >>$logfile << EOF | |
| set timeout 100 | |
| spawn scp /root/.bash_profile $PubIP2:/root/ | |
| expect {"password:" {send "$rootpw\r"} | |
| } | |
| expect eof | |
| EOF | |
| # # For oracle on node01 | |
| sed -i '/export\|alias\|umask\|^$/d' /home/oracle/.bash_profile | |
| cat >>/home/oracle/.bash_profile <<EOF | |
| umask 022 | |
| export TMP=/tmp | |
| export TMPDIR=\$TMP | |
| export ORACLE_HOSTNAME=$hostname1 | |
| export ORACLE_BASE=$ORA_BASE | |
| export ORACLE_HOME=$ORA_HOME | |
| export ORACLE_SID=$ORA_SID1 | |
| export ORACLE_INVENTORY=$ORA_INV | |
| export INVENTORY_LOCATION=\$ORACLE_INVENTORY | |
| # export ORACLE_PDB_SID=$PDB_SID | |
| export NLS_LANG="AMERICAN_AMERICA.AL32UTF8" | |
| export NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS" | |
| export TNS_ADMIN=\$ORACLE_HOME/network/admin | |
| export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib | |
| export PATH=.:\$PATH:\$HOME/bin:\$ORACLE_HOME/bin:\$ORACLE_HOME/OPatch | |
| export THREADS_FLAG=native | |
| # alias sqlplus='rlwrap sqlplus' | |
| # alias rman='rlwrap rman' | |
| alias ss='sqlplus / as sysdba' | |
| EOF | |
| echo -e "# oracle: \n$(cat /home/oracle/.bash_profile)\n" >>$logfile | |
| # For oracle on node02 | |
| expect >>$logfile << EOF | |
| set timeout 100 | |
| spawn scp /home/oracle/.bash_profile oracle@$PubIP2:/home/oracle/ | |
| expect {"password:" {send "$ORAPWD\r"} | |
| } | |
| expect eof | |
| EOF | |
| # 执行脚本 | |
| expect >>$logfile << EOF | |
| set timeout 100 | |
| spawn ssh oracle@$PubIP2 | |
| expect {"password:" {send "$ORAPWD\r"} | |
| } | |
| expect "oracle@*" {send "sed -i's/$ORA_SID1/$ORA_SID2/g'/home/oracle/.bash_profile\r"} | |
| expect "oracle@*" {send "sed -i's/$hostname1/$hostname2/g'/home/oracle/.bash_profile\r"} | |
| expect "oracle@*" {send "exit\r"} | |
| expect eof | |
| EOF | |
| # # For grid on node01 | |
| sed -i '/export\|alias\|umask\|^$/d' /home/grid/.bash_profile | |
| cat >>/home/grid/.bash_profile <<EOF | |
| umask 022 | |
| export TMP=/tmp | |
| export TMPDIR=\$TMP | |
| export ORACLE_HOSTNAME=$hostname1 | |
| export ORACLE_SID=+ASM1 | |
| export ORACLE_BASE=$GI_BASE | |
| export GRID_BASE=\$ORACLE_BASE | |
| export ORACLE_HOME=$GI_HOME | |
| export GRID_HOME=\$ORACLE_HOME | |
| export ORACLE_INVENTORY=$ORA_INV | |
| export INVENTORY_LOCATION=\$ORACLE_INVENTORY | |
| export NLS_LANG="AMERICAN_AMERICA.AL32UTF8" | |
| export NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS" | |
| export TNS_ADMIN=\$ORACLE_HOME/network/admin | |
| export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib | |
| export PATH=.:\$PATH:\$HOME/bin:\$ORACLE_HOME/bin:\$ORACLE_HOME/OPatch | |
| export THREADS_FLAG=native | |
| # alias sqlplus='rlwrap sqlplus' | |
| # alias rman='rlwrap rman' | |
| alias ss='sqlplus / as sysasm' | |
| EOF | |
| echo -e "# grid: \n$(cat /home/grid/.bash_profile)\n" >>$logfile | |
| # For grid on node02 | |
| expect >>$logfile << EOF | |
| set timeout 100 | |
| spawn scp /home/grid/.bash_profile grid@$PubIP2:/home/grid/ | |
| expect {"(yes/no)" {send "yes\r"; exp_continue} | |
| "password:" {send "$ORAPWD\r"} | |
| } | |
| expect eof | |
| EOF | |
| # 执行脚本 | |
| expect >>$logfile << EOF | |
| set timeout 100 | |
| spawn ssh grid@$PubIP2 | |
| expect {"(yes/no)" {send "yes\r"; exp_continue} | |
| "password:" {send "$ORAPWD\r"} | |
| } | |
| expect "grid@*" {send "sed -i's/ASM1/ASM2/g'/home/grid/.bash_profile\r"} | |
| expect "grid@*" {send "sed -i's/$hostname1/$hostname2/g'/home/grid/.bash_profile\r"} | |
| expect "grid@*" {send "exit\r"} | |
| expect eof | |
| EOF | |
| else | |
| result_err "# Please execute this script on $hostname1,while this machine hostname is: $(hostname)" | |
| result_err "# Please execute this script on $hostname1,while this machine hostname is: $(hostname)" >>$logfile | |
| exit 1 | |
| fi | |
| if [$? -ne 0]; then | |
| result_err "# 设置环境变量, Failed" | |
| result_err "# 设置环境变量, Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# 设置环境变量, successful" | |
| result_ok "# 设置环境变量, successful" >>$logfile | |
| fi | |
| # 4. Check OS and Configuration 查看系统配置 | |
| # $ISVirtual ≥ 1, is Virtual Machine | |
| # export routeip=$(route -n | egrep -iv "Gateway|routing" | awk '{print $2}' | grep -v "0\.0\.0\.0") | |
| # export routeprefix=$(echo $routeip | awk -F"." '{print $1"."$2}') | |
| split1 "# 4. Check OS and Configuration 查看系统配置:" | |
| split1 "# 4. Check OS and Configuration 查看系统配置:" >>$logfile | |
| echo '#!/bin/bash'>/tmp/osinfo.sh | |
| cat >>/tmp/osinfo.sh <<osinfo | |
| export routeprefix=\$(route -n | egrep -iv "Gateway|routing" | awk '{print \$2}' | grep -v "0\.0\.0\.0" | awk -F"." '{print \$1"."\$2}') | |
| export client_ip=\$(ip a | grep -w inet | grep -Eiv "secondary|virbr|docker|:|127.0.0.1|192.168.1\." | awk -F "+|/" '{ print \$3}' | grep \$routeprefix) | |
| export ISVirtual=\$(dmidecode -s system-product-name | grep -i virtual | wc -l) | |
| export MachineName=\$(dmidecode -s system-product-name) | |
| if [-f /etc/yum/pluginconf.d/subscription-manager.conf]; then | |
| sed -i 's/enabled=1/enabled=0/g' /etc/yum/pluginconf.d/subscription-manager.conf | |
| yum remove subscription-manager -y | |
| else | |
| echo "subscription-manager.conf file not exist, Do nothing" | |
| fi | |
| if [\$ISVirtual -eq 0]; then | |
| machine_type="物理机" | |
| export RAM_GB=\$(dmidecode | grep -P -A5 "Memory\s+Device" | grep GB | awk '{sum+=\$2} END {print sum}') | |
| else | |
| machine_type="虚拟机" | |
| export RAM_GB=\$(free -g | grep Mem | awk '{print \$2}') | |
| fi | |
| cpus=\$(lscpu | grep ^'CPU(s):' | awk '{print \$2}' | grep -v ^\$) | |
| sockets=\$(lscpu | grep ^'Socket(s):' | awk -F":" '{print \$2}' | grep -v ^\$ | sed 's/^[]*//g') | |
| cores_per_sock=\$(lscpu | grep "Core(s) per socket:" | awk -F":" '{print \$2}' | grep -v ^\$ | sed 's/^[]*//g') | |
| cpu_name=\$(lscpu | grep "Model name:" | awk -F":" '{print \$2}' | grep -v ^\$ | sed 's/^[]*//g') | |
| Cores=\$((\${sockets} * \${cores_per_sock})) | |
| echo "# \$(hostname) 硬件及 OS Version 信息采集: | |
| 服务器 IP:\$client_ip | |
| 服务器类型:\$machine_type | |
| 机器型号 / 平台:\$MachineName | |
| CPU name:\$cpu_name | |
| CPU(s):\$cpus | |
| Core(s):\$Cores | |
| Socket(s):\$sockets | |
| Core(s) per socket:\$cores_per_sock" | |
| osinfo | |
| chmod +x /tmp/osinfo.sh; sh /tmp/osinfo.sh >>$logfile | |
| if [$? -ne 0]; then | |
| result_err "# Check OS and Configuration 查看系统配置, Failed" | |
| result_err "# Check OS and Configuration 查看系统配置, Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# Check OS and Configuration 查看系统配置, successful" | |
| result_ok "# Check OS and Configuration 查看系统配置, successful" >>$logfile | |
| fi | |
| # 拷贝到 $hostname2 并执行脚本 | |
| expect >>$logfile << EOF | |
| set timeout 100 | |
| spawn scp /tmp/osinfo.sh $PubIP2:/tmp/ | |
| expect {"password:" {send "$rootpw\r"} | |
| } | |
| expect eof | |
| EOF | |
| # 执行脚本 | |
| expect >>$logfile << EOF | |
| set timeout 100 | |
| spawn ssh $PubIP2 | |
| expect {"password:" {send "$rootpw\r"} | |
| } | |
| expect "root@*" {send "sh /tmp/osinfo.sh\r"} | |
| expect "root@*" {send "exit\r"} | |
| expect eof | |
| EOF | |
| if [$? -ne 0]; then | |
| result_err "# $hostname2 查看系统配置, Failed" | |
| result_err "# $hostname2 查看系统配置, Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# $hostname2 查看系统配置, successful" | |
| result_ok "# $hostname2 查看系统配置, successful" >>$logfile | |
| fi | |
| # 5. 解压软件，如果存在，仅节点 1 执行 | |
| split1 "# 5. 解压软件，如果存在，仅节点 1 执行:" | |
| split1 "# 5. 解压软件，如果存在，仅节点 1 执行:" >>$logfile | |
| if [-f $grid_install_file] && ["$(hostname)" == "$hostname1" ]; then | |
| echo "# unziping grid install file to $GI_HOME..." | |
| echo "# unziping grid install file to $GI_HOME..." >>$logfile | |
| su - grid -c "unzip -qo $grid_install_file -d $GI_HOME/; mv $GI_HOME/OPatch $GI_HOME/OPatch.$(date +%Y%m%d%H%M); unzip -qo $opatch_install_file -d $GI_HOME/" >>$logfile | |
| echo -e "\n# unzip grid install file End!\n$(ls $GI_HOME/)\n" >>$logfile | |
| fi | |
| if [-f $db_install_file] && ["$(hostname)" == "$hostname1" ]; then | |
| echo "# unziping DB install file to $ORA_HOME..." | |
| echo "# unziping DB install file to $ORA_HOME..." >>$logfile | |
| su - oracle -c "unzip -qo $db_install_file -d $ORA_HOME/; mv $ORA_HOME/OPatch $ORA_HOME/OPatch.$(date +%Y%m%d%H%M); unzip -qo $opatch_install_file -d $ORA_HOME/" >>$logfile | |
| echo -e "\n# unzip DB install file End!\n$(ls $ORA_HOME/)\n" >>$logfile | |
| fi | |
| if [-f ${ru_zip_file} ] && ["$(hostname)" == "$hostname1" ];then | |
| echo "# unziping RU zip file to $softdir/patch/..." | |
| echo "# unziping RU zip file to $softdir/patch/..." >>$logfile | |
| unzip -qo ${ru_zip_file} -d $softdir/patch/; chmod -R 777 $softdir/patch/ | |
| echo -e "\n# unzip Ru zip file End!\n$(ls -l $softdir/patch/)\n" >>$logfile | |
| fi | |
| chown -R grid:oinstall $rootdir | |
| chown -R oracle:oinstall $ORA_BASE | |
| chmod -R 775 $rootdir | |
| # 测试环境空间不太够用，$rootdir 和 /tmp 都在 / 下，判断目录有余时清理 zip 文件 | |
| tmpmnt=$(df -m /tmp/ | grep -v Filesystem | awk '{print $6}' | sed -e '/^$/d') | |
| rootdirmnt=$(df -m $rootdir | grep -v Filesystem | awk '{print $6}' | sed -e '/^$/d') | |
| rootdirleft=$(df -m $rootdir | grep -v Filesystem | awk '{print $4}' | sed -e '/^$/d') | |
| if ["$tmpmnt" == "$rootdirmnt"] && [$rootdirleft -le 20480];then | |
| echo "# $rootdirmnt 残余空间太少，且同 zip 文件雷同文件系统，删除 zip 文件" | |
| echo "# $rootdirmnt 残余空间太少，且同 zip 文件雷同文件系统，删除 zip 文件" >>$logfile | |
| rm -rf $softdir/*.zip >>$logfile | |
| elif [$rootdirleft -le 20480]; then | |
| echo "# $rootdirmnt 残余空间太少, 请留神" | |
| echo "# $rootdirmnt 残余空间太少, 请留神" >>$logfile | |
| fi | |
| # 6. 配置 ssh 互信 | |
| split1 "# 6. 配置 ssh 互信 (oracle grid root), 仅在解压文件的节点 1 执行:" | |
| split1 "# 6. 配置 ssh 互信 (oracle grid root), 仅在解压文件的节点 1 执行:" >>$logfile | |
| if [-f $GI_HOME/oui/prov/resources/scripts/sshUserSetup.sh]; then | |
| for i in oracle grid root; do | |
| if ["$i" == "root"]; then | |
| export pass=$rootpw | |
| else | |
| export pass=$ORAPWD | |
| fi | |
| expect >>$logfile << EOF | |
| spawn $GI_HOME/oui/prov/resources/scripts/sshUserSetup.sh -user $i -hosts "$hostname1 $hostname2" -advanced -noPromptPassphrase | |
| expect {"(yes/no)" {send "yes\r"; exp_continue} | |
| "*assword:" {send "$pass\r";exp_continue} | |
| } | |
| expect eof | |
| EOF | |
| expect >>$logfile << EOF | |
| spawn $GI_HOME/oui/prov/resources/scripts/sshUserSetup.sh -user $i -hosts "$Priv1NAME $Priv2NAME" -advanced -noPromptPassphrase | |
| expect {"(yes/no)" {send "yes\r"; exp_continue} | |
| "*assword:" {send "$pass\r";exp_continue} | |
| } | |
| expect eof | |
| EOF | |
| for g in $hostname1 $hostname2 $Priv1NAME $Priv2NAME; do | |
| echo "# Testing $g for $i" >>$logfile | |
| if ["$i" == "root"]; then | |
| ssh -l $i -o StrictHostKeyChecking=no $g date >>$logfile | |
| else | |
| su - $i -c "ssh -l $i -o StrictHostKeyChecking=no $g date" >>$logfile | |
| fi | |
| if [$? -ne 0]; then | |
| result_err "# $i Test $g sshUserSetup Maybe Failed" | |
| result_err "# $i Test $g sshUserSetup Maybe Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# $i 配置 $g ssh 互信, successful" | |
| result_ok "# $i 配置 $g ssh 互信, successful" >>$logfile | |
| fi | |
| done | |
| done | |
| fi | |
| # 7. 查看 RAM\Swap\shm | |
| # swap 不须要设置过大，最大 32GB，Oracle 倡议是 16GB(内存 >=16GB)；eq 内存大小 (小于 16GB) | |
| # shm 默认是内存的 1 /2，配置 Oracle 会不够用，调整为等同可用内存大小 (自己未取总内存) | |
| split1 "# 7. 查看 RAM\Swap\shm" | |
| split1 "# 7. 查看 RAM\Swap\shm" >>$logfile | |
| echo '#!/bin/bash'>/tmp/shm.sh | |
| cat >>/tmp/shm.sh<<shm | |
| echo "# 设置 /dev/shm:\$(hostname)" | |
| shmsizegb=\$(echo "scale=0;\$(df -PmT /dev/shm | grep shm | awk'{print \$3}')/1024" | bc) | |
| swapgb=\$(echo "scale=0;\$(grep SwapTotal /proc/meminfo | awk'{print \$2}')/1024/1024" | bc) | |
| memgb=\$(echo "scale=0;\$(grep MemTotal /proc/meminfo | awk'{print \$2}')/1024/1024" | bc) | |
| if [\$shmsizegb -lt \$memgb]; then | |
| echo "resize /dev/shm to \${memgb}G" | |
| sed -i '/\/dev\/shm/d' /etc/fstab | |
| echo "tmpfs /dev/shm tmpfs defaults,size=\${memgb}G,noatime,nodiratime 0 0" >>/etc/fstab | |
| mount -o remount /dev/shm | |
| else | |
| echo "/dev/shm equal to MemTotal, Now \$(df -h | grep /dev/shm | awk'{print $2}')" | |
| fi | |
| shm | |
| chmod +x /tmp/shm.sh;sh /tmp/shm.sh >>$logfile | |
| if [$? -ne 0]; then | |
| result_err "# 查看 RAM\Swap\shm, Failed" | |
| result_err "# 查看 RAM\Swap\shm, Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# 查看 RAM\Swap\shm, successful" | |
| result_ok "# 查看 RAM\Swap\shm, successful" >>$logfile | |
| fi | |
| scp /tmp/shm.sh $hostname2:/tmp/ >>$logfile | |
| echo "sh /tmp/shm.sh;exit" | ssh $hostname2 >>$logfile | |
| if [$? -ne 0]; then | |
| result_err "# $hostname2 查看 RAM\Swap\shm, Failed" | |
| result_err "# $hostname2 查看 RAM\Swap\shm, Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# $hostname2 查看 RAM\Swap\shm, successful" | |
| result_ok "# $hostname2 查看 RAM\Swap\shm, successful" >>$logfile | |
| fi | |
| # 8. 禁用防火墙 firewalld | |
| split1 "# 8. $(hostname) 禁用防火墙 firewalld:" | |
| split1 "# 8. $(hostname) 禁用防火墙 firewalld:" >>$logfile | |
| systemctl stop firewalld | |
| systemctl disable firewalld | |
| echo "# $hostname2 禁用防火墙 firewalld" >>$logfile | |
| echo "systemctl stop firewalld;systemctl disable firewalld;exit" | ssh $hostname2 >>$logfile | |
| if [$? -ne 0]; then | |
| result_err "# $hostname2 禁用防火墙 firewalld, Failed" | |
| result_err "# $hostname2 禁用防火墙 firewalld, Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# $hostname2 禁用防火墙 firewalld, successful" | |
| result_ok "# $hostname2 禁用防火墙 firewalld, successful" >>$logfile | |
| fi | |
| # 9. 禁用 SElinux | |
| split1 "# 9. 禁用 SElinux:" | |
| split1 "# 9. 禁用 SElinux:" >>$logfile | |
| echo '#!/bin/bash' >/tmp/sel.sh | |
| cat >>/tmp/sel.sh <<sel | |
| echo "# 9 禁用 SElinux: \$(hostname)" | |
| if [\$(getenforce) != "Disabled" ]; then | |
| export SELINUX=\$(grep ^SELINUX= /etc/selinux/config) | |
| if [\$SELINUX != "SELINUX=disabled"]; then | |
| cp /etc/selinux/config /etc/selinux/config_\$(date +"%Y%m%d_%H%M%S") && sed -i 's/SELINUX\=enforcing/SELINUX\=disabled/g' /etc/selinux/config | |
| echo "Changed SElinux configuration, reboot later..." | |
| else | |
| echo "The SELINUX configuration file has been modified before." | |
| fi | |
| setenforce 0 | |
| else | |
| echo "SELINUX is already disabled, Do nothing." | |
| fi | |
| sel | |
| chmod 777 /tmp/sel.sh;sh /tmp/sel.sh >>$logfile | |
| if [$? -ne 0]; then | |
| result_err "# 禁用 SElinux, Failed" | |
| result_err "# 禁用 SElinux, Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# 禁用 SElinux, successful" | |
| result_ok "# 禁用 SElinux, successful" >>$logfile | |
| fi | |
| scp /tmp/sel.sh $hostname2:/tmp/ >>$logfile | |
| echo "sh /tmp/sel.sh;exit" | ssh $hostname2 >>$logfile | |
| if [$? -ne 0]; then | |
| result_err "# $hostname2 禁用 SElinux, Failed" | |
| result_err "# $hostname2 禁用 SElinux, Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# $hostname2 禁用 SElinux, successful" | |
| result_ok "# $hostname2 禁用 SElinux, successful" >>$logfile | |
| fi | |
| # 10. 禁用虚构网卡 | |
| split1 "# 10. 禁用虚构网卡 libvirtd on $hostname1:" | |
| split1 "# 10. 禁用虚构网卡 libvirtd on $hostname1:" >>$logfile | |
| systemctl stop libvirtd | |
| systemctl disable libvirtd | |
| yum remove libvirt-libs | |
| echo "# 10 禁用虚构网卡，for $hostname2" | |
| echo "# 10 禁用虚构网卡，for $hostname2" >>$logfile | |
| echo "systemctl stop libvirtd;systemctl disable libvirtd;yum remove libvirt-libs;exit"|ssh $hostname2 >>$logfile | |
| if [$? -ne 0]; then | |
| result_err "# $hostname2 禁用虚构网卡, Failed" | |
| result_err "# $hostname2 禁用虚构网卡, Failed" >>$logfile | |
| else | |
| result_ok "# $hostname2 禁用虚构网卡, successful" | |
| result_ok "# $hostname2 禁用虚构网卡, successful" >>$logfile | |
| fi | |
| # 11. 禁用 zeroconf 路由 | |
| # Zero configuration networking(zeroconf) 零配置网络服务标准，是一种用于主动生成可用 IP 地址的网络技术，不须要额定的手动配置和专属的配置服务器。Avahi 是 Zeroconf 标准的开源实现 | |
| split1 "# 11. 禁用 zeroconf 路由:" | |
| split1 "# 11. 禁用 zeroconf 路由:" >>$logfile | |
| # 配置 NOZEROCONF | |
| sed -i '/NOZEROCONF/d' /etc/sysconfig/network | |
| echo "NOZEROCONF=yes" >>/etc/sysconfig/network | |
| # 禁用 Avahi | |
| systemctl stop avahi-daemon.service | |
| systemctl stop avahi-daemon.socket | |
| systemctl disable avahi-daemon.service | |
| systemctl disable avahi-daemon.socket | |
| echo "# 禁用 zeroconf 路由 for $hostname2:" | |
| echo "# 禁用 zeroconf 路由 for $hostname2:" >>$logfile | |
| scp /etc/sysconfig/network $hostname2:/etc/sysconfig/ >>$logfile | |
| echo "systemctl stop avahi-daemon.service;systemctl stop avahi-daemon.socket;systemctl disable avahi-daemon.service;systemctl disable avahi-daemon.socket;exit"|ssh $hostname2 >>$logfile | |
| # 12. 禁用通明大页 THP 和 NUMA | |
| split1 "# 12. 禁用通明大页 THP 和 NUMA:" | |
| split1 "# 12. 禁用通明大页 THP 和 NUMA:" >>$logfile | |
| echo '#!/bin/bash'>/tmp/thp.sh | |
| cat >>/tmp/thp.sh<<thp | |
| echo "# 12 \$(hostname) 禁用通明大页 THP 和 NUMA:" | |
| export AnonHP=\$(grep AnonHugePages /proc/meminfo | awk '{print \$2}') | |
| export TPHstatus=\$(cat /sys/kernel/mm/transparent_hugepage/enabled | awk -F"[][]" '{print \$2}') | |
| if [\$AnonHP -gt 0] || [\$TPHstatus != "never"]; then | |
| echo "Checked TPH is not completely disabled!" | |
| cp /etc/default/grub /etc/default/grub_\$(date +"%Y%m%d_%H%M%S") && sed -i 's/quiet"/quiet numa=off transparent_hugepage=never"/' /etc/default/grub | |
| if [-d /sys/firmware/efi]; then | |
| # On UEFI: | |
| echo "OS running use UEFI, Turn off TPH By grub /boot/efi/EFI/redhat/grub.cfg" | |
| cp /boot/efi/EFI/redhat/grub.cfg /boot/efi/EFI/redhat/grub.cfg_\$(date +"%Y%m%d_%H%M%S") && grub2-mkconfig -o /boot/efi/EFI/redhat/grub.cfg | |
| else | |
| # On BIOS: | |
| echo "OS running use BIOS, Turn off TPH By grub /boot/grub2/grub.cfg" | |
| cp /boot/grub2/grub.cfg /boot/grub2/grub.cfg_\$(date +"%Y%m%d_%H%M%S") && grub2-mkconfig -o /boot/grub2/grub.cfg | |
| fi | |
| else | |
| echo "TPH already disabled." | |
| fi | |
| sed -i '/transparent_hugepage/d' /etc/rc.local | |
| sed -i "/^fi\b/Id" /etc/rc.local | |
| echo "if test -f /sys/kernel/mm/transparent_hugepage/enabled; then | |
| echo never > /sys/kernel/mm/transparent_hugepage/enabled | |
| fi | |
| if test -f /sys/kernel/mm/transparent_hugepage/defrag; then | |
| echo never > /sys/kernel/mm/transparent_hugepage/defrag | |
| fi" >>/etc/rc.local | |
| thp | |
| chmod +x /tmp/thp.sh;sh /tmp/thp.sh >>$logfile | |
| if [$? -ne 0]; then | |
| result_err "# $hostname1 禁用通明大页 THP 和 NUMA, Failed" | |
| result_err "# $hostname1 禁用通明大页 THP 和 NUMA, Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# $hostname1 禁用通明大页 THP 和 NUMA, successful" | |
| result_ok "# $hostname1 禁用通明大页 THP 和 NUMA, successful" >>$logfile | |
| fi | |
| scp /tmp/thp.sh $hostname2:/tmp/ | |
| echo "sh /tmp/thp.sh;exit" | ssh $hostname2 >>$logfile | |
| if [$? -ne 0]; then | |
| result_err "# $hostname2 禁用通明大页 THP 和 NUMA, Failed" | |
| result_err "# $hostname2 禁用通明大页 THP 和 NUMA, Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# $hostname2 禁用通明大页 THP 和 NUMA, successful" | |
| result_ok "# $hostname2 禁用通明大页 THP 和 NUMA, successful" >>$logfile | |
| fi | |
| # 13. 配置时钟同步机制 chronyd | |
| split1 "# 13. 配置 chronyd 时钟同步机制 chronyd:" | |
| split1 "# 13. 配置 chronyd 时钟同步机制 chronyd:" >>$logfile | |
| systemctl stop ntpd | |
| systemctl disable ntpd | |
| sed -i "/$ntpserver\|logchange\|syslog/Id" | |
| sed -i "/server 0/i server $ntpserver iburst" /etc/chrony.conf | |
| sed -i "/pool.ntp.org/d" /etc/chrony.conf | |
| sed -i "/makestep/d" /etc/chrony.conf | |
| echo "# Send message to syslog when clock adjustment is larger than 0.1 seconds. | |
| logchange 0.1" >>/etc/chrony.conf | |
| systemctl restart chronyd | |
| systemctl enable chronyd | |
| scp /etc/chrony.conf $hostname2:/etc/ >>$logfile | |
| echo "systemctl stop ntpd;systemctl disable ntpd;systemctl restart chronyd;systemctl enable chronyd;exit"|ssh $hostname2 >>$logfile | |
| if [$? -ne 0]; then | |
| result_err "# $hostname2 配置 chronyd 时钟同步机制, Failed" | |
| result_err "# $hostname2 配置 chronyd 时钟同步机制, Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# $hostname2 配置 chronyd 时钟同步机制, successful" | |
| result_ok "# $hostname2 配置 chronyd 时钟同步机制, successful" >>$logfile | |
| fi | |
| # 14. 批改登录验证 | |
| split1 "# 14. 批改 pam 登录验证:" | |
| split1 "# 14. 批改 pam 登录验证:" >>$logfile | |
| sed -i '/pam_limits.so/d' /etc/pam.d/login | |
| echo "session required pam_limits.so | |
| session required /lib64/security/pam_limits.so" >>/etc/pam.d/login | |
| echo "# 14 批改 pam 登录验证:for $hostname2" >>$logfile | |
| scp /etc/pam.d/login $hostname2:/etc/pam.d/ >>$logfile | |
| if [$? -ne 0]; then | |
| result_err "# $hostname2 批改 pam 登录验证, Failed" | |
| result_err "# $hostname2 批改 pam 登录验证, Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# $hostname2 批改 pam 登录验证, successful" | |
| result_ok "# $hostname2 批改 pam 登录验证, successful" >>$logfile | |
| fi | |
| # 15. 批改 limit 资源限度 | |
| split1 "# 15. 批改 /etc/security/limits.conf limit 资源限度:" | |
| split1 "# 15. 批改 /etc/security/limits.conf limit 资源限度:" >>$logfile | |
| sed -i "/oracle\|grid\|oinstall/d" /etc/security/limits.conf | |
| echo "# Add oinstall group limits | |
| @oinstall soft nofile 16384 | |
| @oinstall hard nofile 65536 | |
| @oinstall soft nproc 16384 | |
| @oinstall hard nproc 65536 | |
| @oinstall soft stack 16384 | |
| @oinstall hard stack 32768 | |
| @oinstall soft memlock unlimited | |
| @oinstall hard memlock unlimited" >>/etc/security/limits.conf | |
| echo "# 批改 /etc/security/limits.conf limit 资源限度: for $hostname2" | |
| echo "# 批改 /etc/security/limits.conf limit 资源限度: for $hostname2" >>$logfile | |
| scp /etc/security/limits.conf $hostname2:/etc/security/ >>$logfile | |
| if [$? -ne 0]; then | |
| result_err "# $hostname2 批改 /etc/security/limits.conf limit 资源限度, Failed" | |
| result_err "# $hostname2 批改 /etc/security/limits.conf limit 资源限度, Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# $hostname2 批改 /etc/security/limits.conf limit 资源限度, successful" | |
| result_ok "# $hostname2 批改 /etc/security/limits.conf limit 资源限度, successful" >>$logfile | |
| fi | |
| # 16. 批改 kernel 配置 | |
| split1 "# 16. 批改 /etc/sysctl.conf kernel 配置:" | |
| split1 "# 16. 批改 /etc/sysctl.conf kernel 配置:" >>$logfile | |
| sed -i '/[^fs.|^vm.|^kernel.|^net.|^$]/Id' /etc/sysctl.conf | |
| memTotal=$(grep MemTotal /proc/meminfo | awk '{print $2}') | |
| MEM=$(expr $(grep MemTotal /proc/meminfo | awk '{print $2}') \* 1024) | |
| SHMALL=$(($MEM * 9 / 10 / $(getconf PAGE_SIZE))) | |
| SHMMAX=$(($MEM * 9 / 10)) # 这里配置为 90% RAM 大小 | |
| # shmmax(bytes) = shmmni(page size, default 4k) * shmall (page 的个数) | |
| if [$SHMALL -lt 2097152]; then ## 2097152*4k/1024/1024=8G | |
| SHMALL=2097152 | |
| fi | |
| SHMMAX=$((memTotal * 1024 - 1)) | |
| if ["$SHMMAX" -lt 4294967295]; then ## 4294967295k/1024/1024=4095MB | |
| SHMMAX=4294967295 | |
| fi | |
| echo "fs.file-max = 6815744 | |
| fs.aio-max-nr = 1048576 | |
| kernel.sem = 250 32000 100 128 | |
| kernel.shmmni = 4096 | |
| kernel.shmall = $SHMALL | |
| kernel.shmmax = $SHMMAX | |
| kernel.panic_on_oops = 1 | |
| net.core.rmem_default = 262144 | |
| net.core.rmem_max = 41943044 | |
| net.core.wmem_default = 262144 | |
| net.core.wmem_max = 4194304 | |
| net.ipv4.ip_local_port_range = 10000 65500 | |
| net.ipv4.conf.all.rp_filter = 2 | |
| net.ipv4.conf.default.rp_filter = 2 | |
| net.ipv6.conf.all.disable_ipv6 = 1 | |
| net.ipv6.conf.default.disable_ipv6 = 1 | |
| net.ipv4.tcp_max_tw_buckets = 10000 | |
| net.ipv4.tcp_tw_reuse = 1 | |
| net.ipv4.tcp_keepalive_time = 30 | |
| net.ipv4.tcp_keepalive_intvl = 10 | |
| net.ipv4.tcp_retries2 = 12 | |
| net.ipv4.ip_local_reserved_ports = 15400-15407,20050-20057 | |
| net.ipv4.tcp_rmem = 8192 250000 16777216 | |
| net.ipv4.tcp_wmem = 8192 250000 16777216 | |
| # vm.dirty_background_ratio = 5 | |
| # vm.dirty_ratio = 40 | |
| # vm.dirty_expire_centisecs = 500 | |
| # vm.dirty_writeback_centisecs = 100 | |
| # vm.min_free_kbytes= 1048576 | |
| vm.swappiness = 1" >>/etc/sysctl.conf | |
| sed -i '/^$/Id' /etc/sysctl.conf | |
| sysctl -p | |
| sysctl --system >>$logfile | |
| scp /etc/sysctl.conf $hostname2:/etc/ >>$logfile | |
| echo "sysctl -p;sysctl --system;exit"|ssh $hostname2 >>$logfile | |
| if [$? -ne 0]; then | |
| result_err "# $hostname2 批改 /etc/sysctl.conf kernel 配置, Failed" | |
| result_err "# $hostname2 批改 /etc/sysctl.conf kernel 配置, Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# $hostname2 批改 /etc/sysctl.conf kernel 配置, successful" | |
| result_ok "# $hostname2 批改 /etc/sysctl.conf kernel 配置, successful" >>$logfile | |
| fi | |
| # 17. 批改启动 runlevel | |
| split1 "# 17. 批改启动 runlevel=3:" | |
| split1 "# 17. 批改启动 runlevel=3:" >>$logfile | |
| systemctl set-default multi-user.target | |
| # systemctl get-default #查看默认启动形式是什么，如果显示 multi-user.target，阐明是默认命令行启动 | |
| # systemctl set-default graphical.target #设置开机默认图形桌面启动 | |
| # systemctl set-default multi-user.target #设置开机默认命令行启动 | |
| echo "systemctl set-default multi-user.target;exit"|ssh $hostname2 >>$logfile | |
| if [$? -ne 0]; then | |
| result_err "# $hostname2 批改启动 runlevel=3, Failed" | |
| result_err "# $hostname2 批改启动 runlevel=3, Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# $hostname2 批改启动 runlevel=3, successful" | |
| result_ok "# $hostname2 批改启动 runlevel=3, successful" >>$logfile | |
| fi | |
| # 18. 设置 ssh，避免登录过慢, 启用 X11 Forwing 转发 ( 默认拜访接收端 6000 端口 | |
| split1 "# 18. 设置 /etc/ssh/sshd_config，避免登录过慢, 启用 X11 Forwing 转发 (默认拜访接收端 6000 端口)" | |
| split1 "# 18. 设置 /etc/ssh/sshd_config，避免登录过慢, 启用 X11 Forwing 转发 (默认拜访接收端 6000 端口)" >>$logfile | |
| cp /etc/ssh/sshd_config /etc/ssh/sshd_config_$(date +"%Y%m%d_%H%M%S") && sed -i '/UseDNS no\|^AllowTcpForwarding yes\|X11UseLocalhost no/d' /etc/ssh/sshd_config | |
| sed -i '/#UseDNS yes/a\UseDNS no' /etc/ssh/sshd_config | |
| sed -i '/#AllowTcpForwarding yes/a\AllowTcpForwarding yes' /etc/ssh/sshd_config | |
| sed -i '/#X11UseLocalhost yes/a\X11UseLocalhost no' /etc/ssh/sshd_config | |
| egrep "UseDNS|Forwarding|X11" /etc/ssh/sshd_config >>$logfile | |
| systemctl restart sshd | |
| scp /etc/ssh/sshd_config $hostname2:/etc/ssh/ >>$logfile | |
| echo "systemctl restart sshd;exit"|ssh $hostname2 >>$logfile | |
| if [$? -ne 0]; then | |
| result_err "# $hostname2 设置 ssh，避免登录过慢, 启用 X11 Forwing 转发, Failed" | |
| result_err "# $hostname2 设置 ssh，避免登录过慢, 启用 X11 Forwing 转发, Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# $hostname2 设置 ssh，避免登录过慢, 启用 X11 Forwing 转发, successful" | |
| result_ok "# $hostname2 设置 ssh，避免登录过慢, 启用 X11 Forwing 转发, successful" >>$logfile | |
| fi | |
| # 19. 设置 sudoers，授予 oinstall 组 sudo ALL 权限 | |
| split1 "# 19. 设置 /etc/sudoers，授予 oinstall 组 sudo ALL 权限:" | |
| split1 "# 19. 设置 /etc/sudoers，授予 oinstall 组 sudo ALL 权限:" >>$logfile | |
| cp /etc/sudoers /etc/sudoers_$(date +"%Y%m%d_%H%M%S") && sed -i '/oinstall/d' /etc/sudoers && sed -i '/^%wheel/a\%oinstall ALL=(ALL) ALL' /etc/sudoers && grep oinstall /etc/sudoers | |
| grep oinstall /etc/sudoers >>$logfile | |
| scp /etc/sudoers $hostname2:/etc/ >>$logfile | |
| if [$? -ne 0]; then | |
| result_err "# $hostname2 设置 sudoers，授予 oinstall 组 sudo ALL 权限, Failed" | |
| result_err "# $hostname2 设置 sudoers，授予 oinstall 组 sudo ALL 权限, Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# $hostname2 设置 sudoers，授予 oinstall 组 sudo ALL 权限, successful" | |
| result_ok "# $hostname2 设置 sudoers，授予 oinstall 组 sudo ALL 权限, successful" >>$logfile | |
| fi | |
| # 20. cvu 装置 | |
| split1 "# 20. cvu 1 节点装置，并传送 2 节点装置:" | |
| split1 "# 20. cvu 1 节点装置，并传送 2 节点装置:" >>$logfile | |
| if [-f $GI_HOME/cv/rpm/cvuqdisk*.rpm]; then | |
| rpm -ivh $GI_HOME/cv/rpm/cvuqdisk*.rpm >>$logfile | |
| echo "# 2 节点装置" >>$logfile | |
| scp $GI_HOME/cv/rpm/cvuqdisk*.rpm $hostname2:/tmp/ >>$logfile | |
| ssh $hostname2 rpm -ivh /tmp/cvuqdisk*.rpm >>$logfile | |
| else | |
| result_err "# not found package cvuqdisk*.rpm" | |
| result_err "# not found package cvuqdisk*.rpm" >>$logfile | |
| exit 1 | |
| fi | |
| if [$? -ne 0]; then | |
| result_err "# cvu 1 节点装置，并传送 2 节点装置, Failed" | |
| result_err "# cvu 1 节点装置，并传送 2 节点装置, Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# cvu 1 节点装置，并传送 2 节点装置, successful" | |
| result_ok "# cvu 1 节点装置，并传送 2 节点装置, successful" >>$logfile | |
| fi | |
| # 21. asm 配置 | |
| # ASM 磁盘组调配 | |
| split1 "# 21. UDEV 配置磁盘,$hostname1:" | |
| split1 "# 21. UDEV 配置磁盘,$hostname1:" >>$logfile | |
| >/etc/udev/rules.d/99-oracle-asmdevices.rules | |
| for i in $asm_ocr_disks; do | |
| echo "KERNEL==\"${mapper_prefix}?\",SUBSYSTEM==\"block\", PROGRAM==\"/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=$mapper_dir/\$name\",RESULT==\"$(/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=$mapper_dir/${mapper_prefix}$i)\", SYMLINK+=\"asm_ocr_disk$i\",OWNER=\"grid\",ACTION==\"add|change\", GROUP=\"asmadmin\",MODE=\"0660\"" >>/etc/udev/rules.d/99-oracle-asmdevices.rules | |
| ocr_tmp=$(echo "$ocr_tmp""/dev/asm_ocr_disk$i,") | |
| done | |
| export ocr_fgs=$(echo $ocr_tmp | sed 's/,\//,,\//g') | |
| export ocr_diskgs=$(echo $ocr_tmp | sed 's/,$//') | |
| for i in $asm_fra_disks; do | |
| echo "KERNEL==\"${mapper_prefix}?\",SUBSYSTEM==\"block\", PROGRAM==\"/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=$mapper_dir/\$name\",RESULT==\"$(/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=$mapper_dir/${mapper_prefix}$i)\", SYMLINK+=\"asm_fra_disk$i\",OWNER=\"grid\",ACTION==\"add|change\", GROUP=\"asmadmin\",MODE=\"0660\"" >>/etc/udev/rules.d/99-oracle-asmdevices.rules | |
| fra_tmp=$(echo "$fra_tmp""/dev/asm_fra_disk$i,") | |
| done | |
| export fra_fgs=$(echo $fra_tmp | sed 's/,\//,,\//g') | |
| export fra_diskgs=$(echo $fra_tmp | sed 's/,$//') | |
| for i in $asm_data_disks; do | |
| echo "KERNEL==\"${mapper_prefix}?\",SUBSYSTEM==\"block\", PROGRAM==\"/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=$mapper_dir/\$name\",RESULT==\"$(/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=$mapper_dir/${mapper_prefix}$i)\", SYMLINK+=\"asm_data_disk$i\",OWNER=\"grid\",ACTION==\"add|change\", GROUP=\"asmadmin\",MODE=\"0660\"" >>/etc/udev/rules.d/99-oracle-asmdevices.rules | |
| data_tmp=$(echo "$data_tmp""/dev/asm_data_disk$i,") | |
| done | |
| export data_fgs=$(echo $data_tmp | sed 's/,\//,,\//g') | |
| export data_diskgs=$(echo $data_tmp | sed 's/,$//') | |
| systemctl restart systemd-udev-trigger.service >>$logfile | |
| udevadm control --reload-rules >>$logfile | |
| udevadm trigger --type=devices >>$logfile | |
| udevadm trigger --type=devices --action=change >>$logfile | |
| sleep 10 | |
| ls -l /dev/ | grep asm >>$logfile | |
| if [$(ssh $hostname1 ls /dev/asm* | wc -l) -lt 5 ]; then | |
| result_err "# $hostname1 UDEV 配置磁盘, Failed" | |
| result_err "# $hostname1 UDEV 配置磁盘, Failed" >>$logfile | |
| echo "$(ssh $hostname1 ls /dev/asm*)" | |
| echo "$(ssh $hostname1 ls /dev/asm*)" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# $hostname1 UDEV 配置磁盘, successful" | |
| result_ok "# $hostname1 UDEV 配置磁盘, successful" >>$logfile | |
| echo "$(ssh $hostname1 ls /dev/asm*)" | |
| echo "$(ssh $hostname1 ls /dev/asm*)" >>$logfile | |
| fi | |
| echo "# $hostname2 UDEV 配置磁盘" | |
| echo "# $hostname2 UDEV 配置磁盘" >>$logfile | |
| scp /etc/udev/rules.d/99-oracle-asmdevices.rules $hostname2:/etc/udev/rules.d/ >>$logfile | |
| echo "systemctl restart systemd-udev-trigger.service;udevadm control --reload-rules;udevadm trigger --type=devices;udevadm trigger --type=devices --action=change;sleep 10;exit"|ssh $hostname2 >>$logfile | |
| if [$(ssh $hostname2 ls /dev/asm* | wc -l) -lt 5 ]; then | |
| result_err "# $hostname2 UDEV 配置磁盘, Failed" | |
| echo "$(ssh $hostname2 ls /dev/asm*)" | |
| result_err "# $hostname2 UDEV 配置磁盘, Failed" >>$logfile | |
| echo "$(ssh $hostname2 ls /dev/asm*)" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# $hostname2 UDEV 配置磁盘, successful" | |
| echo "$(ssh $hostname2 ls /dev/asm*)" | |
| result_ok "# $hostname2 UDEV 配置磁盘, successful" >>$logfile | |
| echo "$(ssh $hostname2 ls /dev/asm*)" >>$logfile | |
| fi | |
| # 格式化磁盘 | |
| if [$need_format == "y"] || [$need_format == "Y"];then | |
| for i in $(ls -l /dev | grep grid | awk '{print $NF}'); do | |
| cnt=$(lsblk -b | grep -w $i | awk '{print $4/1024/1024}') | |
| echo -e "\n# 开始格式化 /dev/$i, 大小：${cnt}MB ..." | |
| echo "dd if=/dev/zero of=/dev/$i bs=1M count=$cnt" | |
| dd if=/dev/zero of=/dev/$i bs=1M count=$cnt | |
| echo "# 格式化 /dev/$i 实现" | |
| done | |
| if [-z $i];then | |
| result_err "# You need to format the disk, but did not execute it. Please check it." | |
| result_err "# You need to format the disk, but did not execute it. Please check it." >>$logfile | |
| exit 1 | |
| fi | |
| fi | |
| # 22. 预查看 | |
| split1 "# 22. grid 装置预查看 (仅节点 1 运行):" | |
| split1 "# 22. grid 装置预查看 (仅节点 1 运行):" >>$logfile | |
| if ["$(hostname)" == "$hostname1" ]; then | |
| echo '#!/usr/bin/expect -f' >/tmp/precheck.sh | |
| echo "spawn $GI_HOME/runcluvfy.sh stage -pre crsinst -n $hostname1,$hostname2 -fixup -verbose -method root | |
| expect {\"*assword:\" {send \"$rootpw\r\";exp_continue} | |
| \"*again:\" {send \"$rootpw\r\"} | |
| } | |
| expect eof" >>/tmp/precheck.sh | |
| chmod 777 /tmp/precheck.sh | |
| su - grid -c "expect /tmp/precheck.sh" >>$logfile | |
| if [$? -ne 0]; then | |
| result_err "# grid 装置预查看 (仅节点 1 运行), Failed" | |
| result_err "# grid 装置预查看 (仅节点 1 运行), Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# grid 装置预查看 (仅节点 1 运行), successful" | |
| result_ok "# grid 装置预查看 (仅节点 1 运行), successful" >>$logfile | |
| fi | |
| fi | |
| # 23. grid 软件装置 | |
| split1 "# 23. grid 软件装置 (仅节点 1 运行):" | |
| split1 "# 23. grid 软件装置 (仅节点 1 运行):" >>$logfile | |
| # $ sed -e 's/[\t]\+$//' gridsetup.rsp | egrep -v "^$|^#|=$" | |
| # oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v19.0.0 | |
| # INVENTORY_LOCATION=/u01/app/oraInventory | |
| # oracle.install.option=CRS_CONFIG | |
| # ORACLE_BASE=/u01/app/grid | |
| # oracle.install.asm.OSDBA=asmdba | |
| # oracle.install.asm.OSOPER=asmoper | |
| # oracle.install.asm.OSASM=asmadmin | |
| # oracle.install.crs.config.scanType=LOCAL_SCAN | |
| # oracle.install.crs.config.gpnp.scanName=Jeff-Test-SCAN | |
| # oracle.install.crs.config.gpnp.scanPort=1525 | |
| # oracle.install.crs.config.ClusterConfiguration=STANDALONE | |
| # oracle.install.crs.config.configureAsExtendedCluster=false | |
| # oracle.install.crs.config.clusterName=Jeff-Test | |
| # oracle.install.crs.config.gpnp.configureGNS=false | |
| # oracle.install.crs.config.autoConfigureClusterNodeVIP=false | |
| # oracle.install.crs.config.clusterNodes=Ora-Jeff-Test-Prod-RAC1:Jeff-Test-VIP1:HUB,Ora-Jeff-Test-Prod-RAC2:Jeff-Test-VIP2:HUB | |
| # oracle.install.crs.config.networkInterfaceList=Bond0:10.10.164.0:1,Bond1:11.11.11.0:5 | |
| # oracle.install.crs.configureGIMR=false | |
| # oracle.install.asm.configureGIMRDataDG=false | |
| # oracle.install.crs.config.storageOption=FLEX_ASM_STORAGE | |
| # oracle.install.asm.SYSASMPassword=Oracle_19C | |
| # oracle.install.crs.config.useIPMI=false | |
| # oracle.install.asm.storageOption=ASM | |
| # oracle.install.asm.diskGroup.name=OCR | |
| # oracle.install.asm.diskGroup.redundancy=NORMAL | |
| # oracle.install.asm.diskGroup.AUSize=4 | |
| # oracle.install.asm.diskGroup.disksWithFailureGroupNames=/dev/asm_ocr_diska,,/dev/asm_ocr_diskb,,/dev/asm_ocr_diskc, | |
| # oracle.install.asm.diskGroup.disks=/dev/asm_ocr_diska,/dev/asm_ocr_diskb,/dev/asm_ocr_diskc | |
| # oracle.install.asm.diskGroup.diskDiscoveryString=/dev/asm* | |
| # oracle.install.asm.monitorPassword=Oracle_19C | |
| # oracle.install.asm.gimrDG.AUSize=1 | |
| # oracle.install.asm.configureAFD=false | |
| # oracle.install.crs.configureRHPS=false | |
| # oracle.install.crs.config.ignoreDownNodes=false | |
| # oracle.install.config.managementOption=NONE | |
| # oracle.install.config.omsPort=0 | |
| # oracle.install.crs.rootconfig.executeRootScript=false | |
| if [-f ${GI_HOME}/gridSetup.sh ] && ["$(hostname)" == "$hostname1" ]; then | |
| cat >/tmp/gridsetup.rsp <<gridsetuprsp | |
| oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v19.0.0 | |
| INVENTORY_LOCATION=$ORA_INV | |
| oracle.install.option=CRS_CONFIG | |
| ORACLE_BASE=$GI_BASE | |
| oracle.install.asm.OSDBA=asmdba | |
| oracle.install.asm.OSOPER=asmoper | |
| oracle.install.asm.OSASM=asmadmin | |
| oracle.install.crs.config.scanType=LOCAL_SCAN | |
| oracle.install.crs.config.gpnp.scanName=$SCANNAME | |
| oracle.install.crs.config.gpnp.scanPort=$scanPort | |
| oracle.install.crs.config.ClusterConfiguration=STANDALONE | |
| oracle.install.crs.config.configureAsExtendedCluster=false | |
| oracle.install.crs.config.clusterName=$cluster_name | |
| oracle.install.crs.config.gpnp.configureGNS=false | |
| oracle.install.crs.config.autoConfigureClusterNodeVIP=false | |
| oracle.install.crs.config.clusterNodes=$hostname1:$VIP1NAME:HUB,$hostname2:$VIP2NAME:HUB | |
| oracle.install.crs.config.networkInterfaceList=$pub_netcard:$scan_subnet:1,$priv_netcard:$priv_subnet:5 | |
| oracle.install.crs.configureGIMR=false | |
| oracle.install.asm.configureGIMRDataDG=false | |
| oracle.install.crs.config.storageOption=FLEX_ASM_STORAGE | |
| oracle.install.asm.SYSASMPassword=$db_admin_pwd | |
| oracle.install.crs.config.sharedFileSystemStorage.ocrLocations= | |
| oracle.install.crs.config.useIPMI=false | |
| oracle.install.asm.storageOption=ASM | |
| oracle.install.asm.diskGroup.name=${asm_ocr_dir} | |
| oracle.install.asm.diskGroup.redundancy=NORMAL | |
| oracle.install.asm.diskGroup.AUSize=4 | |
| oracle.install.asm.diskGroup.disksWithFailureGroupNames=$ocr_fgs | |
| oracle.install.asm.diskGroup.disks=$ocr_diskgs | |
| oracle.install.asm.diskGroup.diskDiscoveryString=/dev/asm* | |
| oracle.install.asm.monitorPassword=$db_admin_pwd | |
| oracle.install.asm.gimrDG.AUSize=1 | |
| oracle.install.asm.configureAFD=false | |
| oracle.install.crs.configureRHPS=false | |
| oracle.install.crs.config.ignoreDownNodes=false | |
| oracle.install.config.managementOption=NONE | |
| oracle.install.config.omsPort=0 | |
| oracle.install.crs.rootconfig.executeRootScript=false | |
| oracle.install.crs.rootconfig.configMethod= | |
| gridsetuprsp | |
| chmod 777 /tmp/gridsetup.rsp | |
| # echo '#!/usr/bin/expect -f' >/tmp/grid_install.sh | |
| # echo "spawn su - grid -c \"${GI_HOME}/gridSetup.sh -silent -ignorePrereqFailure -responseFile /tmp/gridsetup.rsp -applyRU $RUs\" | |
| #expect {# \"*assword:\" {send \"$rootpw\r\"} | |
| #} | |
| #expect eof" >>/tmp/grid_install.sh | |
| # chmod 777 /tmp/grid_install.sh | |
| echo -e "# 开始应用 rsp 响应文件装置 grid 软件 \n 命令: ${GI_HOME}/gridSetup.sh -silent -ignorePrereqFailure -waitforcompletion -responseFile /tmp/gridsetup.rsp -applyRU $RUs\n 响应文件内容:\n$(cat /tmp/gridsetup.rsp)" | |
| echo -e "# 开始应用 rsp 响应文件装置 grid 软件 \n 命令: ${GI_HOME}/gridSetup.sh -silent -ignorePrereqFailure -waitforcompletion -responseFile /tmp/gridsetup.rsp -applyRU $RUs\n 响应文件内容:\n$(cat /tmp/gridsetup.rsp)" >>$logfile | |
| # expect /tmp/grid_install.sh >>$logfile | |
| su - grid -c "${GI_HOME}/gridSetup.sh -silent -ignorePrereqFailure -waitforcompletion -responseFile /tmp/gridsetup.rsp -applyRU $RUs" >>$logfile | |
| sleep 10 | |
| if [$(tail -20 $logfile | grep orainstRoot | wc -l) -lt 1 ];then | |
| result_err "# ${GI_HOME}/gridSetup.sh -silent Failed" | |
| result_err "# ${GI_HOME}/gridSetup.sh -silent Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# Grid 软件装置 ${GI_HOME}/gridSetup.sh -silent successful" | |
| result_ok "# Grid 软件装置 ${GI_HOME}/gridSetup.sh -silent successful" >>$logfile | |
| fi | |
| if [-f $ORA_INV/orainstRoot.sh] && [-f $GI_HOME/root.sh];then | |
| echo "# $ORA_INV/orainstRoot.sh;$GI_HOME/root.sh 执行 (节点 1 运行)" >>$logfile | |
| sh $ORA_INV/orainstRoot.sh >>$logfile | |
| sh $GI_HOME/root.sh >>$logfile | |
| if [$? -ne 0]; then | |
| result_err "# $ORA_INV/orainstRoot.sh;$GI_HOME/root.sh 执行 (节点 1 运行) Failed" | |
| result_err "# $ORA_INV/orainstRoot.sh;$GI_HOME/root.sh 执行 (节点 1 运行) Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# $ORA_INV/orainstRoot.sh;$GI_HOME/root.sh 执行 (节点 1 运行) successful" | |
| result_ok "# $ORA_INV/orainstRoot.sh;$GI_HOME/root.sh 执行 (节点 1 运行) successful" >>$logfile | |
| if ["$db_type" == "RAC"] && [-n $hostname2];then | |
| echo "# $ORA_INV/orainstRoot.sh;$GI_HOME/root.sh 开始执行 (ssh 节点 2 运行)" | |
| echo "# $ORA_INV/orainstRoot.sh;$GI_HOME/root.sh 开始执行 (ssh 节点 2 运行)" >>$logfile | |
| ssh $hostname2 $ORA_INV/orainstRoot.sh >>$logfile | |
| ssh $hostname2 $GI_HOME/root.sh >>$logfile | |
| if [$? -ne 0]; then | |
| result_err "# $ORA_INV/orainstRoot.sh;$GI_HOME/root.sh 执行 (节点 2 运行) Failed" | |
| result_err "# $ORA_INV/orainstRoot.sh;$GI_HOME/root.sh 执行 (节点 2 运行) Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# $ORA_INV/orainstRoot.sh;$GI_HOME/root.sh 执行 (节点 2 运行) successful" | |
| result_ok "# $ORA_INV/orainstRoot.sh;$GI_HOME/root.sh 执行 (节点 2 运行) successful" >>$logfile | |
| fi | |
| else | |
| result_err "# $ORA_INV/orainstRoot.sh;$GI_HOME/root.sh 节点 2 未运行" | |
| result_err "# $ORA_INV/orainstRoot.sh;$GI_HOME/root.sh 节点 2 未运行" >>$logfile | |
| exit | |
| fi | |
| fi | |
| else | |
| result_err "# $ORA_INV/orainstRoot.sh or $GI_HOME/root.sh file can not found" | |
| result_err "# $ORA_INV/orainstRoot.sh or $GI_HOME/root.sh file can not found" >>$logfile | |
| exit 1 | |
| fi | |
| if [$? -ne 0]; then | |
| result_err "# grid 软件装置 Failed" | |
| result_err "# grid 软件装置 Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# grid 软件装置 successful" | |
| result_ok "# grid 软件装置 successful" >>$logfile | |
| fi | |
| else | |
| result_err "# ${GI_HOME}/gridSetup.sh not found" | |
| result_err "# ${GI_HOME}/gridSetup.sh not found" >>$logfile | |
| exit 1 | |
| fi | |
| # As a root user, execute the following script(s): | |
| # 1. /u01/app/oraInventory/orainstRoot.sh --> $ORA_INV/orainstRoot.sh | |
| # 2. /u01/app/19.3.0/grid/root.sh --> $GI_HOME/root.sh | |
| # | |
| # Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes: | |
| # [Jeff-Test-RAC01, Jeff-Test-RAC02] | |
| # Execute /u01/app/19.3.0/grid/root.sh on the following nodes: | |
| # [Jeff-Test-RAC01, Jeff-Test-RAC02] | |
| # | |
| # Run the script on the local node first. After successful completion, you can start the script in parallel on all other nodes. | |
| # | |
| # Successfully Setup Software with warning(s). | |
| # As install user, execute the following command to complete the configuration. | |
| # /u01/app/19.3.0/grid/gridSetup.sh -executeConfigTools -responseFile /tmp/gridsetup.rsp [-silent] | |
| # 24. ASM 磁盘组增加 | |
| split1 "# 24. ASM 磁盘组增加 ${asm_fra_dir} \ ${asm_data_dir}(仅节点 1 运行):" | |
| split1 "# 24. ASM 磁盘组增加 ${asm_fra_dir} \ ${asm_data_dir}(仅节点 1 运行):" >>$logfile | |
| if [-n $fra_diskgs]; then | |
| echo -e "# 增加 ${asm_fra_dir} 执行命令:\nsu - grid -c \"asmca -silent -sysAsmPassword $db_admin_pwd -createDiskGroup -diskString '/dev/asm*' -diskGroupName ${asm_fra_dir} -diskList '$fra_diskgs' -redundancy EXTERNAL -au_size 4\""echo -e"# 增加 ${asm_fra_dir} 执行命令:\nsu - grid -c \"asmca -silent -sysAsmPassword $db_admin_pwd -createDiskGroup -diskString'/dev/asm*'-diskGroupName ${asm_fra_dir} -diskList'$fra_diskgs'-redundancy EXTERNAL -au_size 4\"" >>$logfile | |
| su - grid -c "asmca -silent -sysAsmPassword $db_admin_pwd -createDiskGroup -diskString'/dev/asm*'-diskGroupName ${asm_fra_dir} -diskList'$fra_diskgs'-redundancy EXTERNAL -au_size 4" >>$logfile | |
| if [$? -ne 0]; then | |
| result_err "# ASM 磁盘组增加 ${asm_fra_dir}, Failed" | |
| result_err "# ASM 磁盘组增加 ${asm_fra_dir}, Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# ASM 磁盘组增加 ${asm_fra_dir}, successful" | |
| result_ok "# ASM 磁盘组增加 ${asm_fra_dir}, successful" >>$logfile | |
| fi | |
| else | |
| echo "# No ${asm_fra_dir} Disk input, \$$fra_diskgs:$$fra_diskgs" | |
| fi | |
| if [-n $data_diskgs]; then | |
| echo -e "\n# 增加 ${asm_data_dir} 执行命令:\nsu - grid -c \"asmca -silent -sysAsmPassword $db_admin_pwd -createDiskGroup -diskString '/dev/asm*' -diskGroupName ${asm_data_dir} -diskList '$data_diskgs' -redundancy EXTERNAL -au_size 4\""echo -e"\n# 增加 ${asm_data_dir} 执行命令:\nsu - grid -c \"asmca -silent -sysAsmPassword $db_admin_pwd -createDiskGroup -diskString'/dev/asm*'-diskGroupName ${asm_data_dir} -diskList'$data_diskgs'-redundancy EXTERNAL -au_size 4\"" >>$logfile | |
| su - grid -c "asmca -silent -sysAsmPassword $db_admin_pwd -createDiskGroup -diskString'/dev/asm*'-diskGroupName ${asm_data_dir} -diskList'$data_diskgs'-redundancy EXTERNAL -au_size 4" >>$logfile | |
| if [$? -ne 0]; then | |
| result_err "# ASM 磁盘组增加 ${asm_data_dir}, Failed" | |
| result_err "# ASM 磁盘组增加 ${asm_data_dir}, Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# ASM 磁盘组增加 ${asm_data_dir}, successful" | |
| result_ok "# ASM 磁盘组增加 ${asm_data_dir}, successful" >>$logfile | |
| fi | |
| else | |
| echo "# No ${asm_data_dir} Disk input, \$data_diskgs:$data_diskgs" | |
| fi | |
| # 25. DB 软件装置 | |
| split1 "# 25. DB 软件装置 (仅节点 1 运行):" | |
| split1 "# 25. DB 软件装置 (仅节点 1 运行):" >>$logfile | |
| # $ sed -e 's/[\t]\+$//' db_install_manual.rsp | egrep -v "^$|^#|=$" | |
| # oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0 | |
| # oracle.install.option=INSTALL_DB_SWONLY | |
| # UNIX_GROUP_NAME=oinstall | |
| # INVENTORY_LOCATION=/u01/app/oraInventory | |
| # ORACLE_BASE=/u01/app/oracle | |
| # oracle.install.db.InstallEdition=EE | |
| # oracle.install.db.OSDBA_GROUP=dba | |
| # oracle.install.db.OSOPER_GROUP=oper | |
| # oracle.install.db.OSBACKUPDBA_GROUP=backupdba | |
| # oracle.install.db.OSDGDBA_GROUP=dgdba | |
| # oracle.install.db.OSKMDBA_GROUP=kmdba | |
| # oracle.install.db.OSRACDBA_GROUP=racdba | |
| # oracle.install.db.rootconfig.executeRootScript=false | |
| # oracle.install.db.CLUSTER_NODES=ora-Jeff-Test-prod-rac1,ora-Jeff-Test-prod-rac2 | |
| # oracle.install.db.config.starterdb.type=GENERAL_PURPOSE | |
| # oracle.install.db.ConfigureAsContainerDB=false | |
| # oracle.install.db.config.starterdb.memoryOption=false | |
| # oracle.install.db.config.starterdb.installExampleSchemas=false | |
| # oracle.install.db.config.starterdb.managementOption=DEFAULT | |
| # oracle.install.db.config.starterdb.omsPort=0 | |
| # oracle.install.db.config.starterdb.enableRecovery=false | |
| cat >/tmp/db_install.rsp<<dbinst | |
| oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0 | |
| oracle.install.option=INSTALL_DB_SWONLY | |
| UNIX_GROUP_NAME=oinstall | |
| INVENTORY_LOCATION=$ORA_INV | |
| ORACLE_HOME=$ORA_HOME | |
| ORACLE_BASE=$ORA_BASE | |
| oracle.install.db.InstallEdition=EE | |
| oracle.install.db.OSDBA_GROUP=dba | |
| oracle.install.db.OSOPER_GROUP=oper | |
| oracle.install.db.OSBACKUPDBA_GROUP=backupdba | |
| oracle.install.db.OSDGDBA_GROUP=dgdba | |
| oracle.install.db.OSKMDBA_GROUP=kmdba | |
| oracle.install.db.OSRACDBA_GROUP=racdba | |
| oracle.install.db.CLUSTER_NODES=$hostname1,$hostname2 | |
| oracle.install.db.config.starterdb.type=GENERAL_PURPOSE | |
| oracle.install.db.isRACOneInstall=false | |
| oracle.install.db.rac.serverpoolCardinality=0 | |
| oracle.install.db.ConfigureAsContainerDB=false | |
| # oracle.install.db.config.starterdb.memoryOption=false | |
| # oracle.install.db.config.starterdb.installExampleSchemas=false | |
| # oracle.install.db.config.starterdb.managementOption=DEFAULT | |
| # oracle.install.db.config.starterdb.omsPort=0 | |
| # oracle.install.db.config.starterdb.enableRecovery=false | |
| oracle.install.db.rootconfig.executeRootScript=false | |
| SECURITY_UPDATES_VIA_MYORACLESUPPORT=false | |
| DECLINE_SECURITY_UPDATES=true | |
| dbinst | |
| chmod 777 /tmp/db_install.rsp | |
| if [-f $ORA_HOME/runInstaller]; then | |
| echo -e "# 执行 DB 软件装置命令:\nsu - oracle -c \"$ORA_HOME/runInstaller -silent -force -noconfig -ignorePrereq -responseFile /tmp/db_install.rsp -applyRU $RUs\""echo -e"# 执行 DB 软件装置命令:\nsu - oracle -c \"$ORA_HOME/runInstaller -silent -force -noconfig -ignorePrereq -responseFile /tmp/db_install.rsp -applyRU $RUs\"" >>$logfile | |
| su - oracle -c "$ORA_HOME/runInstaller -silent -force -noconfig -ignorePrereq -responseFile /tmp/db_install.rsp -applyRU $RUs" >>$logfile | |
| sleep 10 | |
| if [$(tail -20 $logfile | grep root.sh | wc -l) -lt 1 ];then | |
| result_err "# $ORA_HOME/runInstaller -silent Failed" | |
| result_err "# $ORA_HOME/runInstaller -silent Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# $ORA_HOME/runInstaller -silent successful" | |
| result_ok "# $ORA_HOME/runInstaller -silent successful" >>$logfile | |
| fi | |
| echo "# root 执行脚本 $ORA_HOME/root.sh (节点 1 运行)" | |
| echo "# root 执行脚本 $ORA_HOME/root.sh (节点 1 运行)" >>$logfile | |
| $ORA_HOME/root.sh >>$logfile | |
| if [$? -ne 0]; then | |
| result_err "# root 执行脚本 $ORA_HOME/root.sh (节点 1 运行) Failed" | |
| result_err "# root 执行脚本 $ORA_HOME/root.sh (节点 1 运行) Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# root 执行脚本 $ORA_HOME/root.sh (节点 1 运行) successful" | |
| result_ok "# root 执行脚本 $ORA_HOME/root.sh (节点 1 运行) successful" >>$logfile | |
| if ["$db_type" == "RAC"] && [-n $hostname2]; then | |
| echo -e "\n# root 执行脚本 $ORA_HOME/root.sh (节点 2 运行)" | |
| echo -e "\n# root 执行脚本 $ORA_HOME/root.sh (节点 2 运行)" >>$logfile | |
| $ORA_HOME/root.sh >>$logfile | |
| fi | |
| fi | |
| if [$? -ne 0]; then | |
| result_err "# DB 软件装置 Failed" | |
| result_err "# DB 软件装置 Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# DB 软件装置 successful" | |
| result_ok "# DB 软件装置 successful" >>$logfile | |
| fi | |
| else | |
| result_err "# $ORA_HOME/runInstaller file not found" | |
| result_err "# $ORA_HOME/runInstaller file not found" >>$logfile | |
| exit 1 | |
| fi | |
| # 26. DBCA 创立数据库 | |
| split1 "# 26 DBCA 创立数据库 (仅节点 1 运行):" | |
| split1 "# 26 DBCA 创立数据库 (仅节点 1 运行):" >>$logfile | |
| # $ sed -e 's/[\t]\+$//' dbca_MANUAL.rsp | egrep -v "^$|^#|=$" | |
| # responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v12.2.0 | |
| # gdbName=JeffTest | |
| # sid=Jeff0 | |
| # databaseConfigType=RAC | |
| # policyManaged=false | |
| # createServerPool=false | |
| # force=false | |
| # createAsContainerDatabase=true | |
| # numberOfPDBs=1 | |
| # pdbName=Jeff_pdb | |
| # useLocalUndoForPDBs=true | |
| # nodelist=jeff-test-rac01,jeff-test-rac02 | |
| # templateName=/u01/app/oracle/product/19.3.0/db_1/assistants/dbca/templates/New_Database.dbt | |
| # emExpressPort=5500 | |
| # runCVUChecks=TRUE | |
| # omsPort=0 | |
| # dvConfiguration=false | |
| # olsConfiguration=false | |
| # datafileJarLocation={ORACLE_HOME}/assistants/dbca/templates/ | |
| # datafileDestination=+DATA/{DB_UNIQUE_NAME}/ | |
| # recoveryAreaDestination=+FRA | |
| # storageType=ASM | |
| # diskGroupName=+DATA/{DB_UNIQUE_NAME}/ | |
| # recoveryGroupName=+FRA | |
| # characterSet=AL32UTF8 | |
| # nationalCharacterSet=UTF8 | |
| # registerWithDirService=false | |
| # skipListenerRegistration=true | |
| # variables=ORACLE_BASE_HOME=/u01/app/oracle/product/19.3.0/db_1,DB_UNIQUE_NAME=JeffTest,ORACLE_BASE=/u01/app/oracle,PDB_NAME=,DB_NAME=Jeff,ORACLE_HOME=/u01/app/oracle/product/19.3.0/db_1,SID=Jeff0 | |
| # initParams=Jeff01.undo_tablespace=UNDOTBS1,Jeff02.undo_tablespace=UNDOTBS2,enable_pluggable_database=true,sga_target=1824MB,db_block_size=8192BYTES,cluster_database=true,standby_file_management=AUTO,family:dw_helper.instance_mode=read-only,log_archive_dest_1='LOCATION=+FRA',nls_language=AMERICAN,filesystemio_options=SETALL,dispatchers=(PROTOCOL=TCP) (SERVICE=Jeff0XDB),diagnostic_dest={ORACLE_BASE},remote_login_passwordfile=exclusive,db_create_file_dest=+DATA/{DB_UNIQUE_NAME}/,db_create_online_log_dest_2=+FRA,db_create_online_log_dest_1=+DATA,nls_date_format="YYYY/MM/DD HH24:MI:SS",parallel_force_local=TRUE,audit_file_dest={ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump,processes=5000,pga_aggregate_target=609MB,Jeff01.thread=1,Jeff02.thread=2,nls_territory=AMERICA,undo_retention=10800,session_cached_cursors=200,local_listener=-oraagent-dummy-,db_recovery_file_dest_size=18000MB,db_unique_name=JeffTest,optimizer_adaptive_plans=FALSE,open_cursors=1000,control_file_record_keep_time=31,log_archive_format=arch_%t_%s_%r.arc,compatible=19.0.0,sga_max_size=1000MB,db_name=Jeff,archive_lag_target=1800,result_cache_max_size=0MB,db_files=2000,enable_ddl_logging=TRUE,Jeff01.instance_number=1,Jeff02.instance_number=2,db_recovery_file_dest=+FRA,audit_trail=db | |
| # sampleSchema=false | |
| # memoryPercentage=40 | |
| # databaseType=MULTIPURPOSE | |
| # automaticMemoryManagement=false | |
| # totalMemory=0 | |
| cat >/tmp/dbca.rsp<<dbcarsp | |
| responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v12.2.0 | |
| gdbName=$DB_UNIQUE_NAME | |
| sid=$ORA_SID_PREFIX | |
| databaseConfigType=RAC | |
| RACOneNodeServiceName= | |
| policyManaged=false | |
| createServerPool=false | |
| force=false | |
| createAsContainerDatabase=true | |
| numberOfPDBs=1 | |
| pdbName=$PDB_SID | |
| useLocalUndoForPDBs=true | |
| pdbAdminPassword=$ORAPWD | |
| nodelist=$hostname1,$hostname2 | |
| templateName=$ORA_HOME/assistants/dbca/templates/New_Database.dbt | |
| sysPassword=$ORAPWD | |
| systemPassword=$ORAPWD | |
| serviceUserPassword=$ORAPWD | |
| emConfiguration= | |
| emExpressPort=5500 | |
| runCVUChecks=TRUE | |
| dbsnmpPassword=$ORAPWD | |
| omsPort=0 | |
| dvConfiguration=false | |
| olsConfiguration=false | |
| datafileJarLocation={ORACLE_HOME}/assistants/dbca/templates/ | |
| datafileDestination=+${asm_data_dir}/{DB_UNIQUE_NAME}/ | |
| recoveryAreaDestination=+${asm_fra_dir} | |
| storageType=ASM | |
| diskGroupName=+${asm_data_dir}/{DB_UNIQUE_NAME}/ | |
| asmsnmpPassword=$ORAPWD | |
| recoveryGroupName=+${asm_fra_dir} | |
| characterSet=AL32UTF8 | |
| nationalCharacterSet=UTF8 | |
| registerWithDirService=false | |
| skipListenerRegistration=true | |
| variables=ORACLE_BASE_HOME=$ORA_HOME,DB_UNIQUE_NAME=$DB_UNIQUE_NAME,ORACLE_BASE=$ORA_BASE,PDB_NAME=$PDB_SID,DB_NAME=$DB_NAME,ORACLE_HOME=$ORA_HOME,SID=$ORA_SID_PREFIX | |
| initParams=$ORA_SID1.undo_tablespace=UNDOTBS1,$ORA_SID2.undo_tablespace=UNDOTBS2,enable_pluggable_database=true,sga_target=$sgasize,db_block_size=8192BYTES,cluster_database=true,standby_file_management=AUTO,family:dw_helper.instance_mode=read-only,log_archive_dest_1='LOCATION=+${asm_fra_dir}',nls_language=AMERICAN,filesystemio_options=SETALL,dispatchers=(PROTOCOL=TCP) (SERVICE=${ORA_SID_PREFIX}XDB),diagnostic_dest={ORACLE_BASE},remote_login_passwordfile=exclusive,db_create_file_dest=+${asm_data_dir}/{DB_UNIQUE_NAME}/,db_create_online_log_dest_2=+${asm_fra_dir},db_create_online_log_dest_1=+${asm_data_dir},nls_date_format="YYYY/MM/DD HH24:MI:SS",parallel_force_local=TRUE,audit_file_dest={ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump,processes=$processes,pga_aggregate_target=$pgasize,$ORA_SID1.thread=1,$ORA_SID2.thread=2,nls_territory=AMERICA,undo_retention=10800,session_cached_cursors=200,local_listener=-oraagent-dummy-,db_recovery_file_dest_size=$recovery_size,db_unique_name=$DB_UNIQUE_NAME,optimizer_adaptive_plans=FALSE,open_cursors=1000,max_dump_file_size='1024m',control_file_record_keep_time=31,log_archive_format=arch_%t_%s_%r.arc,compatible=19.0.0,sga_max_size=$sga_max_size,db_name=$DB_NAME,archive_lag_target=1800,result_cache_max_size=0MB,db_files=2000,enable_ddl_logging=TRUE,$ORA_SID1.instance_number=1,$ORA_SID2.instance_number=2,db_recovery_file_dest=+${asm_fra_dir},audit_trail=db | |
| sampleSchema=false | |
| memoryPercentage=40 | |
| databaseType=MULTIPURPOSE | |
| automaticMemoryManagement=false | |
| totalMemory=0 | |
| dbcarsp | |
| chmod 777 /tmp/dbca.rsp | |
| if [$needcdb != "y"] && [$needcdb != "Y"];then | |
| echo "# Do not need CDB" | |
| sed -i 's/createAsContainerDatabase=true/createAsContainerDatabase=false/g' /tmp/dbca.rsp | |
| if [$needpdb != "y"] && [$needpdb != "Y"];then | |
| sed -i "s/numberOfPDBs=1/numberOfPDBs=0/g" /tmp/dbca.rsp | |
| sed -i "s/PDB_NAME=$PDB_SID,//g" /tmp/dbca.rsp | |
| sed -i "/PDB_NAME=$PDB_SID/d" /tmp/dbca.rsp | |
| fi | |
| fi | |
| cat /tmp/dbca.rsp >>$logfile | |
| echo "# 开始 DBCA 建库" | |
| echo "# 开始 DBCA 建库" >>$logfile | |
| su - oracle -c "dbca -silent -createDatabase -ignorePrereqFailure -responseFile /tmp/dbca.rsp -redoLogFileSize 200 -useOMF true -enableArchive true -emConfiguration NONE" | |
| if [$? -ne 0];then | |
| result_err "# DBCA 建库失败,Failed" | |
| result_err "# DBCA 建库失败,Failed" >>$logfile | |
| exit 1 | |
| else | |
| result_ok "# DBCA 建库胜利,successful" | |
| result_ok "# DBCA 建库胜利,successful" >>$logfile | |
| fi |
正文完
