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)执行setenforce 0关闭防火墙创建目录脚本#!/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创建数据库时禁用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 节点上运行以下命令：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