一鍵RAC環境配置指令碼

wmsok發表於2016-05-09
指令碼
因為工作中經常要搭建RAC環境，所以編寫了一個一鍵RAC環境配置指令碼以簡化重複性的工作。下面的指令碼是在CentOS/RHEL 6的環境測試無問題。
目前ssh互信還未完成，指令碼也還在進一步修改中，以便能相容更多的系統版本，比如RHEL5,SOLARIS 10/11,AIX等環境，敬請關注！！！如有不妥之處，請不吝指教！！！

指令碼分三個檔案：
AutoRAC.sh        一鍵RAC主程式
AutoRAC.conf     RAC環境的配置檔案
Software.conf     RAC環境的安裝包配置檔案
------------------------------------------------------------------------------------------------------------------
AutoRAC.sh 內容如下：

點選(此處)摺疊或開啟

  1. #! /bin/bash
  2. node_num=$1
  3. base_config=./autorac.conf
  4. software_config=./software.conf

  6. if [ ! ${node_num} ];then
  7. echo "specify the node number"
  8. exit 0
  9. fi


  12. Get_Block()
  13. {
  14. block_name=$1
  15. config_file=$2
  16. begin_line=0
  17. end_line=0
  18. line_num=0
  19. while read line
  20. do
  21.         line_num=`expr ${line_num} + 1`
  22.         is_get=`echo $line | awk "/\[${block_name}]/{print 1;next}{print 0}"`
  23.         if [ ${is_get} -eq 1 ];then
  24.                 begin_line=${line_num}
  25.                 continue
  26.         fi

  28.         if [ ${begin_line} -ne 0 ];then
  29.                 is_get=`echo $line | awk "/\[.*]/{print 1;next}{print 0}"`
  30.                 if [ ${is_get} -eq 1 ];then
  31.                         end_line=`expr ${line_num} - 1`
  32.                         break
  33.                 fi
  34.         fi

  36. done < ${config_file}
  37. }


  40. IP_fun()
  41. {
  42. field_num=`expr $1 + 1`
  43. block_name=$2
  44. tmp_file=/tmp/autorac.tmp

  46. Get_Block ${block_name} ${base_config}

  48. sed -n "${begin_line},${end_line}p" ${base_config} | grep -v ^$ > ${tmp_file}

  50. is_ip=`echo ${block_name} | awk '/IP/{print 1;next}{print 0}'`

  52. if [ ${is_ip} -eq 1 ];then
  53.         IPADDR=`awk -F"[:,]" -v num=${field_num} '/IP-LIST/{print $num}' ${tmp_file}`
  54.         HOSTNAME=`awk -F"[:,]" -v num=${field_num} '/HOSTNAME/{print $num}' ${tmp_file}`
  55.         NETMASK=`awk -F"[:,]" '/NETMASK/{print $2}' ${tmp_file}`
  56.         GATEWAY=`awk -F"[:,]" '/GATEWAY/{print $2}' ${tmp_file}`
  57.         DNS1=`awk -F"[:,]" '/DNS1/{print $2}' ${tmp_file}`
  58.         DNS2=`awk -F"[:,]" '/DNS2/{print $2}' ${tmp_file}`


  61.         if [ "${block_name}" == "PUBLIC-IP" -o "${block_name}" == "PRIVATE-IP" ];then
  62.                 if [ "${block_name}" == "PUBLIC-IP" ];then
  63.                         network="ifcfg-eth0"
  64.                         sed -i "s/HOSTNAME=.*/HOSTNAME=${HOSTNAME}/" /etc/sysconfig/network
  65.                         echo "IPADDR:"${IPADDR}
  66.                         echo "HOSTNAME:"${HOSTNAME}
  67.                 else
  68.                         network="ifcfg-eth1"
  69.                 fi
  70.         
  71.          tmp_ipaddr_file=/tmp/autorac_ipaddr_file.tmp
  72.                  awk '/DEVICE/||/TYPE/||/HWADDR/||/NM_CONTROLLED/{print $1}' /etc/sysconfig/network-scripts/${network} >${tmp_ipaddr_file}
  73.                  echo "IPADDR="${IPADDR} >>${tmp_ipaddr_file}
  74.                  echo "NETMASK="${NETMASK} >>${tmp_ipaddr_file}
  75.                  echo "GATEWAY="${GATEWAY} >>${tmp_ipaddr_file}
  76.                  echo "DNS1="${DNS1} >>${tmp_ipaddr_file}
  77.                  echo "DNS2="${DNS2} >>${tmp_ipaddr_file}
  78.                  echo -e "ARPCHECK=no\nONBOOT=\"yes\"\nBOOTPROTO=static" >>${tmp_ipaddr_file}
  79.                  
  80.                  cat ${tmp_ipaddr_file} > /etc/sysconfig/network-scripts/${network}
  81.                  
  82.         fi

  84.         rac_node_name=/tmp/autorac_node.tmp
  85.         echo >${rac_node_name}
  86.         node_total=`awk -F"[:,]" '/IP-LIST/{print NF}' ${tmp_file}`
  87.         for i in `seq 2 ${node_total}`
  88.         do
  89.                 IPADDR=`awk -F"[:,]" -v num=${i} '/IP-LIST/{print $num}' ${tmp_file}`
  90.                 HOSTNAME_1=`awk -F"[:,]" -v num=${i} '/HOSTNAME/{print $num}' ${tmp_file}`
  91.         HOSTNAME=${HOSTNAME_1:-${HOSTNAME}}

  93.                   echo -e ${IPADDR} ${HOSTNAME} \#ORACLE_CONFIG>> /etc/hosts

  95.                 if [ "${block_name}" == "PUBLIC-IP" -o "${block_name}" == "PRIVATE-IP" ];then
  96.                         echo ${block_name}:${HOSTNAME} >> ${rac_node_name}
  97.                 fi
  98.         done
  99. fi

  101. #is_storage=`echo ${block_name} | awk '/STORAGE/{print 1;next}{print 0}'`

  103. }

  105. sed -i '/ORACLE_CONFIG/d' /etc/hosts

  107. IP_fun ${node_num} PUBLIC-IP
  108. IP_fun ${node_num} PRIVATE-IP
  109. IP_fun ${node_num} VIP
  110. IP_fun ${node_num} SCAN-IP

  112. #shutdown iptables
  113. service iptables stop
  114. chkconfig iptables off

  116. #shutdown fireware
  117. setenforce 0
  118. sed -i 's/SELINUX=.*/SELINUX=disable/g' /etc/selinux/config

  120. #disable ntp server
  121. service ntpd status | grep run && service ntpd stop
  122. chkconfig ntpd off
  123. if [ -e /etc/ntp.conf ];then
  124. mv /etc/ntp.conf /etc/ntp.conf.bak
  125. fi


  128. #install package

  130. Install_package_fun()
  131. {
  132. for i in `ls /etc/yum.repos.d/ | grep -v bak$`
  133. do
  134.         mv /etc/yum.repos.d/$i /etc/yum.repos.d/$i.bak
  135. done

  137. cat > /etc/yum.repos.d/CentOS-Media.repo <<EOF
  138. [c6-media]
  139. name=CentOS-\$releasever - Media
  140. baseurl=file:///media/
  141. gpgcheck=1
  142. enabled=1
  143. gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6
  144. EOF

  146. yum clean all

  148. os_type=`lsb_release -a | awk -F"[:\t]+" '/Distributor ID/{print $2}'`
  149. os_release=`lsb_release -a | awk -F"[:\t]+" '/Release/{printf("%d\n",$2)}'`
  150. if [ ${os_type} == "CentOS" -o ${os_type} == "Red" ];then
  151.         Get_Block "RHEL${os_release}" ${software_config}
  152.         sed -n "${begin_line},${end_line}p" ${software_config} | grep -v ^$ | awk -F'-[0-9].[0-9]' '! /\[/{print $1}' > ${tmp_file}
  153.         while read line
  154.         do
  155.                 yum install -y -q ${line}
  156.         done < ${tmp_file}
  157. fi
  158. }


  161. is_mount=`mount | grep iso9660|wc -l`

  163. if [ ${is_mount} -ge 1 ];then
  164.     echo -e "\033[31mCDROM HAS BEEN MOUNTTED\033[0m" && Install_package_fun
  165. else
  166.     mount /dev/cdrom /media/ 2>&1| grep mounting && echo -e "\033[31mCDROM IS MOUNTING\033[0m" && Install_package_fun || echo -e "\033[31mNO CDROM INSERTED\033[0m"
  167. fi




  172. #create user and group
  173. groupadd oinstall
  174. groupadd dba
  175. groupadd oper
  176. groupadd asmadmin
  177. groupadd asmdba
  178. groupadd asmoper
  179. useradd -g oinstall -G dba,asmdba,asmadmin,asmoper grid
  180. useradd -g oinstall -G dba,oper,asmdba,asmadmin oracle
  181. echo -n oracle | passwd --stdin grid
  182. echo -n oracle | passwd --stdin oracle

  184. #create directory
  185. mkdir -p /u01/app/11.2.0/grid
  186. mkdir -p /u01/app/grid
  187. mkdir -p /u01/app/oracle
  188. chown -R grid:oinstall /u01/app/11.2.0/grid
  189. chown -R grid:oinstall /u01/app/grid
  190. chown -R oracle:oinstall /u01/app/oracle
  191. chmod -R 775 /u01/

  193. #modify the bash_profile
  194. is_modified=`awk 'BEGIN{a=0}/ORACLE_CONFIG/{a+=1}END{print a}' /home/grid/.bash_profile`

  196. if [ ${is_modified} -eq 0 ];then
  197. cat>> /home/grid/.bash_profile<< EOF
  198. \#ORACLE_CONFIG
  199. export TMP=/tmp;
  200. export TMPDIR=\$TMP;
  201. export ORACLE_SID=+ASM1;
  202. export ORACLE_BASE=/u01/app/grid;
  203. export ORACLE_HOME=/u01/app/11.2.0/grid;
  204. export NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS";
  205. export PATH=\$ORACLE_HOME/BIN:\$PATH;
  206. export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;
  207. EOF
  208. fi




  213. is_modified=`awk 'BEGIN{a=0}/ORACLE_CONFIG/{a+=1}END{print a}' /home/oracle/.bash_profile`

  215. if [ ${is_modified} -eq 0 ];then
  216. cat>> /home/oracle/.bash_profile<< EOF
  217. \#ORACLE_CONFIG
  218. export TMP=/tmp;
  219. export TMPDIR=\$TMP;
  220. export ORACLE_BASE=/u01/app/oracle;
  221. export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1;
  222. export ORACLE_UNQNAME=prod;
  223. export ORACLE_SID=prod1;
  224. export ORACLE_TERM=xterm;
  225. export PATH=/usr/sbin:\$PATH;
  226. export PATH=\$ORACLE_HOME/bin:\$PATH;
  227. export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib;
  228. export CLASSPATH=\$ORACLE_HOME/JRE:\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib;
  229. export NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS";
  230. export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK";
  231. EOF
  232. fi

  234. #modify core source
  235. is_modified=`awk 'BEGIN{a=0}/ORACLE_CONFIG/{a+=1}END{print a}' /etc/sysctl.conf`

  237. if [ ${is_modified} -eq 0 ];then
  238. sed -i 's/^kernel.shmmax/#kernel.shmmax/g' /etc/sysctl.conf
  239. sed -i 's/^kernel.shmall/#kernel.shmall/g' /etc/sysctl.conf
  240. cat>> /etc/sysctl.conf<<EOF
  241. \#ORACLE_CONFIG
  242. fs.aio-max-nr = 1048576
  243. fs.file-max = 6815744
  244. kernel.shmall = 2097152
  245. kernel.shmmax = 1417529344
  246. kernel.shmmni = 4096
  247. kernel.sem = 250 32000 100 128
  248. net.ipv4.ip_local_port_range = 9000 65500
  249. net.core.rmem_default = 262144
  250. net.core.rmem_max = 4194304
  251. net.core.wmem_default = 262144
  252. net.core.wmem_max = 1048586
  253. EOF
  254. fi



  258. #limit the oracle user
  259. is_modified=`awk '/oracle/||/grid/{a+=1}END{print a}' /etc/security/limits.conf`
  260. if [ ${is_modified} -ne 10 ];then
  261.     cat>> /etc/security/limits.conf<<EOF
  262.     oracle soft nproc 2047
  263.     oracle hard nproc 16384
  264.     oracle soft nofile 1024
  265.     oracle hard nofile 65536
  266.     oracle soft stack 10240
  267.     grid soft nproc 2047
  268.     grid hard nproc 16384
  269.     grid soft nofile 1024
  270.     grid hard nofile 65536
  271.     grid soft stack 10240
  272.     EOF
  273. fi

  275. #modify the /etc/profile
  276. is_modified=`awk 'BEGIN{a=0}/ORACLE_CONFIG/{a+=1}END{print a}' /etc/profile`

  278. if [ ${is_modified} -eq 0 ];then
  279. cat >>/etc/profile<<EOF
  280. \#ORACLE_CONFIG
  281. if [ \$USER = "oracle" ]; then
  282.         if [ \$SHELL = "/bin/ksh" ]; then
  283.               ulimit -p 16384
  284.               ulimit -n 65536
  285.         else
  286.               ulimit -u 16384 -n 65536
  287.         fi
  288. fi
  289. alias grep='grep --color=auto'
  290. export PATH=\$PATH:/u01/app/11.2.0/grid/bin
  291. export DISPLAY=192.168.2.1:0.0
  292. EOF
  293. fi

  295. while [ ${exitcode:=0} -eq 0 ]
  296. do
  297. times=`expr ${times:=0} + 1`
  298. is_install_multipath=`rpm -qa | grep -E "device-mapper-[0-9]|multipath" |wc -l`
  299. if [ ${is_install_multipath} -ge 2 ];then
  300.     if [ ! -e /etc/multipath.conf ];then
  301.         cp /usr/share/doc/device-mapper-multipath-0.4.9/multipath.conf /etc/multipath.conf && service multipathd restart || echo -e "\033[31mMultipath ERROR\033[0m"
  302.     fi

  304.     is_modified=`awk 'BEGIN{a=0}/ORACLE_CONFIG/{a+=1}END{print a}' /etc/multipath.conf`
  305.     if [ ${is_modified} -eq 0 ];then
  306.         echo '#ORACLE_CONFIG' >> /etc/multipath.conf
  307.         awk -F'[ \t]+' 'BEGIN{print "multipaths '{'";a=0}NF==2&&/mpath/{a+=1;printf("\tmultipath '{'\n\t\twwid\t%s\n\t\talias\tlun%d\n\t'}'\n",$2,a)} \
  308.             END{print "'}'"}' /etc/multipath/bindings >> /etc/multipath.conf
  309.     fi
  310.     
  311.     service multipathd restart
  312.     sleep 5
  313.     if [ $? -ne 0 ];then
  314.         echo -e "\033[31mMultipath ERROR\033[0m"
  315.     else        
  316.         is_multipath=`multipath -ll | awk -F'[ \t]' '/lun/{print $3}'|wc -l`
  317.     fi
  318.     exitcode=1
  319. else
  320.     rm -rf /var/lib/yum/history/*.sqlite&&yum install -y -q *multipath*&& echo -e "\033[31mInstall device-mapper-* Complete\033[0m"
  321.     if [ ${times} -ge 3 ];then
  322.         echo -e "\033[31mInstall Package device-mpper-* ERROR\033[0m"
  323.         break
  324.     fi
  325. fi
  326. done

  328. if [ ${is_multipath:=0} -ge 1 ];then
  329.    sed -i '/^[^#]/d' /etc/udev/rules.d/60-raw.rules
  330.    for i in `multipath -ll | grep lun | sort| awk -F'[ \t]' '{print $2}'|sed -e 's/(//g' -e 's/)//g'`
  331.    do
  332.         num=`expr ${num:=0} + 1`
  333.         echo "KERNEL==\"sd*\", ACTION==\"add\", PROGRAM==\"/lib/udev/scsi_id --whitelisted --device=/dev/\$name\", \
  334.         RESULT==\"$i\", NAME=\"raw${num}\"" >> /etc/udev/rules.d/60-raw.rules
  335.    done
  336.    echo "NAME==\"raw[0-9]*\",OWNER=\"grid\", GROUP=\"asmadmin\", MODE=\"0660\"" >> /etc/udev/rules.d/60-raw.rules
  337.    start_udev
  338. else
  339.    echo -e "\033[31mNO STORAGE DEVICE BE FOUND\033[0m"
  340. fi


  343. #ssh
  344. ssh_keygen()
  345. {
  346. for user in oracle grid
  347. do
  348.         awk -F':' '/PUBLIC-IP/{print $2}' ${rac_node_name} | while read line
  349.         do
  350.                 node_name=${line}
  351.                 ssh root@${node_name} su - ${user} -c "
  352.                 rm -f ~/.ssh/id_rsa\r
  353.                 rm -f ~/.ssh/id_dsa\r
  354.                 rm -f ~/.ssh/authorized_keys\r
  355.                 ssh-keygen -t rsa -q -f ~/.ssh/id_rsa -N 099q4naefadfasfdadfAADF8W0309QERQSDQ97FGJH\r
  356.                 ssh-keygen -t dsa -q -f ~/.ssh/id_rsa -N 099q4naefadf0w323346ssd0ADF8WsdRQSDQ97FGJH\r"

  358.                 ssh root@${node_name} su - ${user} -c "cat ~/.ssh/*.pub" >> all_node_authorized_keys
  359.         done

  361.         awk -F: '/PUBLIC-IP/{print $2}' ${rac_node_name}| while read line
  362.         do
  363.                 node_name=${line}
  364.                 scp all_node_authorized_keys ${user}@${node_name}:~/.ssh/authorized_keys

  366.         done
  367. done


  370. for user in oracle grid
  371. do
  372.         awk -F':' '/PUBLIC-IP/{print $2}' ${rac_node_name} |while read line
  373.         do
  374.                 node_name=${line}
  375.                 awk -F':' '{print $2}' ${rac_node_name} | while read line
  376.                 do
  377.                         host_name=${line}
  378.                         ssh root@${node_name} su - ${user} -c "ssh ${host_name} date"
  379.                 done
  380.         done
  381. done
  382. }

  384. if [ ${node_num} -eq 1 ];then
  385.     ssh_keygen
  386. fi

配置檔案AutoRAC.conf:

點選(此處)摺疊或開啟

  1. [PUBLIC-IP]
  2. IP-LIST:192.168.2.101,192.168.2.102
  3. HOSTNAME-LIST:RAC1,RAC2
  4. NETMASK:255.255.255.0
  5. GATEWAY:192.168.2.1
  6. DNS1:202.96.128.166
  7. DNS2:202.96.128.86

  9. [PRIVATE-IP]
  10. IP-LIST:192.168.56.101,192.168.56.102
  11. HOSTNAME-LIST:RAC1-PRIV,RAC2-PRIV
  12. NETMASK:255.255.255.0
  13. GATEWAY:192.168.56.1

  15. [VIP]
  16. IP-LIST:192.168.2.10,192.168.2.20
  17. HOSTNAME-LIST:RAC1-VIP,RAC2-VIP

  19. [SCAN-IP]
  20. IP-LIST:192.168.2.91,192.168.2.92,192.168.2.93
  21. HOSTNAME-LIST:RAC-SCAN

  23. [STORAGE]
  24. OCR:OCR_VOTE,NORMAL,2G
  25. DATA:DATAS,NORMAL,20G


配置檔案Software.conf

點選(此處)摺疊或開啟

  1. [RHEL6]
  2. binutils-2.20.51.0.2-5.11.el6 (x86_64)
  3. compat-libcap1-1.10-1 (x86_64)
  4. compat-libstdc++-33-3.2.3-69.el6 (x86_64)
  5. compat-libstdc++-33-3.2.3-69.el6.i686
  6. gcc-4.4.4-13.el6 (x86_64)
  7. gcc-c++-4.4.4-13.el6 (x86_64)
  8. glibc-2.12-1.7.el6 (i686)
  9. glibc-2.12-1.7.el6 (x86_64)
  10. glibc-devel-2.12-1.7.el6 (x86_64)
  11. glibc-devel-2.12-1.7.el6.i686
  12. ksh
  13. libgcc-4.4.4-13.el6 (i686)
  14. libgcc-4.4.4-13.el6 (x86_64)
  15. libstdc++-4.4.4-13.el6 (x86_64)
  16. libstdc++-4.4.4-13.el6.i686
  17. libstdc++-devel-4.4.4-13.el6 (x86_64)
  18. libstdc++-devel-4.4.4-13.el6.i686
  19. libaio-0.3.107-10.el6 (x86_64)
  20. libaio-0.3.107-10.el6.i686
  21. libaio-devel-0.3.107-10.el6 (x86_64)
  22. libaio-devel-0.3.107-10.el6.i686
  23. make-3.81-19.el6
  24. sysstat-9.0.4-11.el6 (x86_64)

  26. [RHEL5]
  27. binutils-2.17.50.0.6
  28. compat-libstdc++-33-3.2.3
  29. compat-libstdc++-33-3.2.3 (32 bit)
  30. elfutils-libelf-0.125
  31. elfutils-libelf-devel-0.125
  32. gcc-4.1.2
  33. gcc-c++-4.1.2
  34. glibc-2.5-24
  35. glibc-2.5-24 (32 bit)
  36. glibc-common-2.5
  37. glibc-devel-2.5
  38. glibc-devel-2.5 (32 bit)
  39. glibc-headers-2.5
  40. ksh-20060214
  41. libaio-0.3.106
  42. libaio-0.3.106 (32 bit)
  43. libaio-devel-0.3.106
  44. libaio-devel-0.3.106 (32 bit)
  45. libgcc-4.1.2
  46. libgcc-4.1.2 (32 bit)
  47. libstdc++-4.1.2
  48. libstdc++-4.1.2 (32 bit)
  49. libstdc++-devel 4.1.2
  50. make-3.81
  51. sysstat-7.0.2



來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/25960404/viewspace-2096197/，如需轉載，請註明出處，否則將追究法律責任。

相關文章