11G搭建的高可用性模型---RAC.docx

-安裝RAC準備/usr/sbin/groupadd -g 1000 oinstall/usr/sbin/groupadd -g 1020 asmadmin/usr/sbin/groupadd -g 1021 asmdba/usr/sbin/groupadd -g 1022 asmoper/usr/sbin/groupadd -g 1031 dba/usr/sbin/groupadd -g 1032 oper/usr/sbin/useradd -u 1100 -g oinstall -p grid -G asmadmin,asmdba grid/usr/sbin/useradd -u 1101 -g oinstall -p oracle -G asmdba,dba oraclepasswd oraclepasswd grid#!/bin/bashmkdir -p /u01/app/gridmkdir -p /u01/app/11.2.0/grid_homemkdir -p /u01/app/oracle/11.2.0/dbhome_1chown -R grid:oinstall /u01/app/gridchown -R grid:oinstall /u01/app/11.2.0/grid_homechown -R oracle:oinstall /u01/app/oraclechown root:oinstall /u01chown root:oinstall /u01/appchmod 775 -R /u01mv /etc/ntp.conf /etc/ntp.conf.bak編輯/etc/hosts#public ip0 rac11 rac2#private ip rac1-priv rac2-priv #virtual ip2 rac1-vip3 rac2-vip#scan-ip4 rac-scan編輯/etc/sysctl.conffs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576sysctl -pcat /proc/meminfo 查看巨頁內存配置編輯/etc/grub.conf在kernel xxx最后加入transparent_hugepage=never編輯/etc/security/limits.confgrid soft nproc 2047grid hard nproc 16384grid soft nofile 1024grid hard nofile 65536grid soft stack 10240grid hard stack 10240oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536oracle soft stack 10240oracle hard stack 10240* soft memlock * hard memlock 修改文件/etc/pam.d/loginsession required pam_limits.so編輯/etc/selinux/config，設置SELINUX=disabled(別誤改SELINUXTYPE)執(zhí)行setenforce 0關閉防火墻創(chuàng)建目錄腳本#!/bin/bash#create the oracle Inventory dirmkdir -p /u01/app/oraInventorychown -R grid:oinstall /u01/app/oraInventorychmod -R 775 /u01/app/oraInventory#creating the oracle grid infrastructure homemkdir -p /u01/11.2.0/gridchown -R grid:oinstall /u01/11.2.0/gridchmod -R 775 /u01/11.2.0/grid#creating the oracle base dirmkdir -p /u01/app/oraclemkdir -p /u01/app/oracle/cfgtoollogschown -R oracle:oinstall /u01/app/oraclechmod -R 775 /u01/app/oracle#creating the oracle RDBMS home dirmkdir -p /u01/app/oracle/product/11.2.0/db_1chown -R oracle:oinstall /u01/app/oracle/product/11.2.0/db_1chmod -R 775 /u01/app/oracle/product/11.2.0/db_1yum -y install binutils-2.*yum -y install compat-libcap1-1.*yum -y install compat-libstdc+-33-3.*yum -y install gcc-4.*yum -y install gcc-c+-4.*yum -y install glibc-2.*yum -y install glibc-common-2.*yum -y install glibc-devel-2.*yum -y install kshyum -y install libgcc-4.*yum -y install libstdc+-4.*yum -y install libstdc+-devel-4.*yum -y install libaio-0.3.107-10.*yum -y install libaio-devel-0.3.107-10.*yum -y install make-3.*yum -y install sysstat-9.*yum -y install unixODBC-2.*yum -y install unixODBC-devel-2.*安裝軟件的腳本#!/bin/bashyum -y install binutils-.2-5.11.el6 yum -y install compat-libcap1-1.10-1 yum -y install compat-libstdc+-33-3.2.3-69.el6 yum -y install compat-libstdc+-33-3.2.3-69.el6.i686yum -y install gcc-4.4.4-13.el6 yum -y install gcc-c+-4.4.4-13.el6 yum -y install glibc-2.12-1.7.el6 yum -y install glibc-2.12-1.7.el6 yum -y install glibc-devel-2.12-1.7.el6 yum -y install glibc-devel-2.12-1.7.el6.i686yum -y install kshyum -y install libgcc-4.4.4-13.el6 yum -y install libgcc-4.4.4-13.el6 yum -y install libstdc+-4.4.4-13.el6 yum -y install libstdc+-4.4.4-13.el6.i686yum -y install libstdc+-devel-4.4.4-13.el6 yum -y install libstdc+-devel-4.4.4-13.el6.i686yum -y install libaio-0.3.107-10.el6 yum -y install libaio-0.3.107-10.el6.i686yum -y install libaio-devel-0.3.107-10.el6 yum -y install libaio-devel-0.3.107-10.el6.i686yum -y install make-3.81-19.el6yum -y install sysstat-9.0.4-11.el6 (x86_64)rpm -ivh binutils-?.?.?.?.?-?.?.el6.x86_64.rpm rpm -ivh compat-libcap1-?.?-?.x86_64.rpmrpm -ivh compat-libstdc+-?-?.?.?-?.el6.*.rpm rpm -ivh libstdc+-?.?.?-?.el6.*.rpm rpm -ivh libstdc+-devel-?.?.?-?.el6.*.rpm rpm -ivh elfutils-libelf-?.?-?.el6.x86_64.rpm rpm -ivh elfutils-libelf-devel-?.?-?.el6.x86_64.rpm rpm -ivh ppl-?.?.?-?.el6.x86_64.rpm rpm -ivh mpfr-?.?.?-?.el6.x86_64.rpm rpm -ivh glibc-devel-*.el6.*.rpm glibc-headers-*.el6.*.rpm kernel-headers-*.el6.x86_64.rpm rpm -ivh cpp-?.?.?-?.el6.x86_64.rpm rpm -ivh gcc-?.?.?-?.el6.x86_64.rpm cloog-ppl-?.?.?-?.?.el6.x86_64.rpm rpm -ivh glibc-2*.el6.x86_64.rpm glibc-common-*.el6.x86_64.rpm rpm -ivh ksh-*.el6.x86_64.rpm rpm -ivh libaio-*.el6.*.rpm rpm -ivh libaio-devel-?.?.?-?.el6.*.rpm rpm -ivh libgcc-?.?.?-?.el6.*.rpm rpm -ivh sysstat-?.?.?-?.el6.x86_64.rpm rpm -ivh make-?.?-?.el6.x86_64.rpm rpm -ivh unixODBC-*.x86_64.rpm rpm -ivh unixODBC-devel-*.x86_64.rpm rpm -ivh gcc-c+-?.?.?-?.el6.x86_64.rpmrpm -ivh tuned-0*.el6.noarch.rpm chkconfig tuned ontuned-adm profile enterprise-storageudev設置權限，單路徑使用編輯/etc/udev/rules.d/99-oracle-asm.rules，其中ENVID_SERIAL項用scsi_id -g -u /dev/sd*查(RHEL 5用scsi_id -g -u -s /block/sd*)KERNEL=sd*, SUBSYSTEM=block, ENVDEVTYPE=disk, ENVID_SERIAL=36000c2958cff8005e3e8a702f31a1e23, NAME+=oracleasm/disk1, OWNER=grid, GROUP=asmadmin, MODE=0660powerpath使用KERNEL=emcpower*, OWNER=grid, GROUP=asmadmin, MODE=0660multipathd使用ENVDM_NAME=ocr?, OWNER:=grid, GROUP:=asmadmin, MODE:=660完成后運行/etc/init.d/udev-post reload編輯profileexport LANG=en_US.utf8export LANGUAGE=en_US.utf8export ORACLE_SID=+ASM1export ORACLE_BASE=/u01/app/gridexport ORACLE_HOME=/u01/app/11.2.0/grid_homeexport ORACLE_UNQNAME=+ASMPATH=$PATH:$ORACLE_HOME/binexport PATH創(chuàng)建數據庫時禁用AMM，手工指定sga_target和pga_aggregate_target設置僅使用巨頁內存ALTER SYSTEM SET use_large_pages=only SCOPE=SPFILE;硬件需求1、查看物理內存大小(至少需要1.5G):/root$ cat /proc/meminfo |grep MemTotalMemTotal: 1692472 kB 1.6G2、查看交換空間:/root$ cat /proc/meminfo |grep SwapTotalSwapTotal: 5237180 kB 4.9G3、查看空閑的空間:/root$ free total used free shared buffers cachedMem: 1692472 511248 1181224 0 50596 357704-/+ buffers/cache: 102948 1589524Swap: 5237180 0 52371804、查看系統架構:/root$ uname -mI6861|、2、Itpub用戶2015sea郵箱2933558433密碼：513085xueNTP服務要停用 NTP 服務，必須停止當前的 ntpd 服務，從初始化序列中禁用該服務，并刪除 ntp.conf 文件。要在 OracleEnterprise Linux 上完成這些步驟，以 root 用戶身份在兩個 Oracle RAC 節(jié)點上運行以下命令：rootracnode1 # /sbin/ service ntpd stoprootracnode1 # chkconfig ntpd offrootracnode1 # mv /etc/ntp.conf /etc/ntp.conf.original還要刪除以下文件：rootracnode1 # rm /var/run/ntpd.pid此文件保存了 NTP 后臺程序的 pid。源文檔 gridrac2 tmp$ rm -rf OraInstall2015-08-2*gridrac2 tmp$ rm -rf CVU_.0_grid/先把ohasd禁止rootrac2 # /u01/app/11.2.0/grid/root.shPerforming root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /u01/app/11.2.0/gridEnter the full pathname of the local bin directory: /usr/local/bin: The contents of dbhome have not changed. No need to overwrite.The contents of oraenv have not changed. No need to overwrite.The contents of coraenv have not changed. No need to overwrite.Creating /etc/oratab file.Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_paramsCreating trace directoryUser ignored Prerequisites during installationInstalling Trace File AnalyzerOLR initialization - successfulAdding Clusterware entries to upstartCRS-4402: The CSS daemon was