Oracle11G RAC 安装 for CentOS

CentOS 6.6 ASM 11G RAC 安装OS: CentOS release 6.6 (final)DB: Oracle 11.2.0.4************************************************************************** 1.配置ip**************************************************************************注释：①每个节点都需要2个网卡第一个网卡为public ip 第二个为private ip②修改IP后使生效命令：service network restart③修改IP方法：服务端setup进入图形界面配置，也可修改ifcfg-eth0文件修改主机名：vi /etc/sysconfig/network修改rac01test主机名[root@ rac01test ~]# cat /etc/sysconfig/networkNETWORKING=yesNETWORKING_IPV6=noHOSTNAME=rac01test修改rac02test主机名[root@ rac02test ~]# cat /etc/sysconfig/networkNETWORKING=yesNETWORKING_IPV6=noHOSTNAME= rac02test使主机名生效[root@ rac01test ~] hostname rac01test[root@ rac02test ~] hostname rac02test配置NTP时间同步：rac01test:[root@ rac01test /] cd etc[root@ rac01test etc/] mv npt.conf npt.conf.bakrac02test:[root@ rac02test /]# cd /etc[root@ rac02test etc]# mv ntp.conf ntp.conf.bak************************************************************************** 2.关闭防火墙**************************************************************************[root@ rac01test /] vi /etc/selinux/configSELINUX=disabled ---修改成disabledSELINUXTYPE=targeted#setenforce 0注意：两个节点都要修改两节点关闭防火墙另一种方式：chkconfig --list|grep ipchkconfig ip6tables offchkconfig iptables offservice ip6tables stopservice iptables stop************************************************************************** 3.修改hosts文件**************************************************************************rac01test[root@rac01test/]# vi /etc/hosts192.168.26.180 rac01test192.168.26.181 rac02test192.168.26.182 rac01testvip192.168.26.183 rac02testvip192.168.26.184 scanip172.16.1.180 rac01testpriv172.16.1.181 rac02testprivrac02test[root@rac02test /]# vi /etc/hosts192.168.26.180 rac01test192.168.26.181 rac02test192.168.26.182 rac01testvip192.168.26.183 rac02testvip192.168.26.184 scanip172.16.1.180 rac01testpriv172.16.1.181 rac02testpriv************************************************************************** 4.配置yum**************************************************************************以下配置操作两个节点都要配置[root@rac01test etc]# cd /etc/yum.repos.d[***********************.d]#virhel-debuginfo.repo修改成以下配置[rhel-debuginfo]name=Red Hat Enterprise Linux $releasever - $basearch - Debugbaseurl=file:///mnt/Serverenabled=1gpgcheck=0[root@ rac01test yum.repos.d]# yum clean allLoaded plugins: rhnplugin, securityCleaning up Everything注意：以上挂载方式是，未联网用光盘里面的包；如果系统联网可以直接在外网yum挂载磁盘, 如果连接外网YUM就不需要挂载磁盘[root@ rac01test yum.repos.d]# mount /dev/hdc /mntmount: block device /dev/hdc is write-protected, mounting read-onlyCentOS 6.6 版本需要安装以下的系统包glibc-2.12-1.7.el6 (i686)glibc-2.12-1.7.el6 (x86_64)glibc-devel-2.12-1.7.el6 (x86_64)glibc-devel-2.12-1.7.el6.i686kshlibgcc-4.4.4-13.el6 (i686)libgcc-4.4.4-13.el6 (x86_64)libstdc++-4.4.4-13.el6 (x86_64)libstdc++-4.4.4-13.el6.i686libstdc++-devel-4.4.4-13.el6 (x86_64)libstdc++-devel-4.4.4-13.el6.i686libaio-0.3.107-10.el6 (x86_64)libaio-0.3.107-10.el6.i686libaio-devel-0.3.107-10.el6 (x86_64)libaio-devel-0.3.107-10.el6.i686make-3.81-19.el6sysstat-9.0.4-11.el6 (x86_64)unixODBC-2.2.14-11.el6 (x86_64) or laterunixODBC-2.2.14-11.el6.i686 or laterunixODBC-devel-2.2.14-11.el6 (x86_64) or laterunixODBC-devel-2.2.14-11.el6.i686 or later执行以下命令就可把需要的包装上：yum install -y binutils-* libXp* compat-libstdc++-33-* elfutils-libelf-* elfutils-libelf-devel-* gcc-* gcc-c++-* glibc-* glibc-common-* glibc-devel-* glibc-headers-* ksh-* libaio-* libgcc-* libstdc++-* make-* sysstat-* unixODBC-* unixODBC-devel-*s******************************************************************************* 5.创建oracle用户组*******************************************************************************rac01test:[root@rac01test /]# groupadd -g 501 oinstall[root@ rac01test /]# groupadd -g 502 dba[root@ rac01test /]# groupadd -g 503 asmadmin[root@ rac01test /]# groupadd -g 504 asmdba[root@ rac01test /]# groupadd -g 505 asmoper[root@ rac01test /]# useradd -u 501 -g oinstall -G asmadmin,asmdba,asmoper grid[root@ rac01test /]# useradd -u 502 -g oinstall -G dba,asmdba oracle[root@ rac01test /]# passwd oracle[root@ rac01test /]# passwd gridrac02test:[***********************.d]#cd/[root@ rac02test /]# groupadd -g 501 oinstall[root@ rac02test /]# groupadd -g 502 dba[root@ rac02test /]# groupadd -g 503 asmadmin[root@ rac02test /]# groupadd -g 504 asmdba[root@ rac02test /]# groupadd -g 505 asmoper[root@ rac02test /]# useradd -u 501 -g oinstall -G asmadmin,asmdba,asmoper grid[root@ rac02test /]# useradd -u 502 -g oinstall -G dba,asmdba oracle[root@ rac02test /]# passwd oracle[root@ rac02test /]# passwd grid******************************************************************************* 6.修改内核参数*******************************************************************************rac01test:[root@ rac01test /]# vi /etc/sysctl.conffs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 536870912kernel.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 = 1048576rac02test:[root@ rac01test /]# vi /etc/sysctl.conffs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 536870912kernel.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 -p 查看内核参数，以下是修改后的内核参数[root@ rac01test /]# sysctl -pnet.ipv4.ip_forward = 0net.ipv4.conf.default.rp_filter = 1net.ipv4.conf.default.accept_source_route = 0kernel.sysrq = 0kernel.core_uses_pid = 1net.ipv4.tcp_syncookies = 1kernel.msgmnb = 65536kernel.msgmax = 65536kernel.shmmax = 68719476736kernel.shmall = 4294967296fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 536870912kernel.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 = 1048576*******************************************************************************7.修改oracle 用户能用的进程最大数量******************************************************************************* 注意：记得rac01test和rac01test都要修改rac01test[root@ rac01test /]# vi /etc/security/limits.conforacle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536rac02test[root@ rac02test /]# vi /etc/security/limits.conforacle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 655368.新建oracle的安装目录注意：两个节点都要创建mkdir -p /u01/app/oraInventorychown -R grid:oinstall /u01/app/oraInventorychmod -R 775 /u01/app/oraInventorymkdir -p /u01/11.2.0/gridmkdir -p /u01/app/gridchown -R grid:oinstall /u01/app/gridchown -R grid:oinstall /u01/11.2.0/gridchmod -R 775 /u01/11.2.0/gridmkdir -p /u01/app/oraclemkdir /u01/app/oracle/cfgtoollogschown -R oracle:oinstall /u01/app/oraclechmod -R 775 /u01/app/oraclemkdir -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_1***************************************************************************** 9.创建分区***************************************************************************** 单节点执行即可[root@rac01test ~]# fdisk -lDisk /dev/sdb doesn't contain a valid partition table给/dev/sdb 磁盘分区[root@node1 ~]# fdisk /dev/sdbm 帮助菜单p 打印分区表n 创建分区p 创建主分区d 删除一个主分区e 创建扩展分区扩展分区不能直接使用不能建文件系统和映射裸设备通过逻辑分区使用w 保存退出q 不保存退出创建完成后刷新一下[root@ rac01test ~]partprobe[root@ rac02test ~]partprobe查看刚分区的磁盘，下面sdb1到sdb5是刚分区的[root@ rac01test ~]# fdisk -lDisk /dev/sda: 21.4 GB, 21474836480 bytes255 heads, 63 sectors/track, 2610 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytesDevice Boot Start End Blocks Id System/dev/sda1 * 1 131 1052226 83 Linux/dev/sda2 132 653 4192965 82 Linux swap / Solaris/dev/sda3 654 2610 15719602+ 83 LinuxDisk /dev/sdb: 21.4 GB, 21474836480 bytes255 heads, 63 sectors/track, 2610 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytesDevice Boot Start End Blocks Id System/dev/sdb1 1 244 1959898+ 83 Linux/dev/sdb2 245 488 1959930 83 Linux/dev/sdb3 489 732 1959930 83 Linux/dev/sdb4 733 976 1959930 5 Extended /dev/sdb5 733 976 1959898+ 83 Linux磁盘映射，注意sdb4是扩展分区，不能使用节点1[*********************]#vi/etc/udev/rules.d/60-raw.rulesACTION=="add", KERNEL=="sdb1", RUN+="/bin/raw /dev/raw/raw1 %N" ACTION=="add", KERNEL=="sdb2", RUN+="/bin/raw /dev/raw/raw2 %N" ACTION=="add", KERNEL=="sdb3", RUN+="/bin/raw /dev/raw/raw3 %N" ACTION=="add", KERNEL=="sdb5", RUN+="/bin/raw /dev/raw/raw5 %N" KERNEL=="raw*", OWNER="grid" GROUP="asmadmin", MODE="660"节点2[*********************]#vi/etc/udev/rules.d/60-raw.rulesACTION=="add", KERNEL=="sdb1", RUN+="/bin/raw /dev/raw/raw1 %N" ACTION=="add", KERNEL=="sdb2", RUN+="/bin/raw /dev/raw/raw2 %N" ACTION=="add", KERNEL=="sdb3", RUN+="/bin/raw /dev/raw/raw3 %N" ACTION=="add", KERNEL=="sdb5", RUN+="/bin/raw /dev/raw/raw5 %N" KERNEL=="raw*", OWNER="grid" GROUP="asmadmin", MODE="660"[root@ rac01test rules.d]# start_udevStarting udev: [ OK ][root@ rac02test ~]# start_udevStarting udev: [ OK ] 分别查看,可以看到5块盘[*********************]#raw-qa/dev/raw/raw1: bound to major 8, minor 17/dev/raw/raw2: bound to major 8, minor 18/dev/raw/raw3: bound to major 8, minor 19/dev/raw/raw4: bound to major 8, minor 20/dev/raw/raw5: bound to major 8, minor 21[root@ rac02test ~]# raw -qa/dev/raw/raw1: bound to major 8, minor 17/dev/raw/raw2: bound to major 8, minor 18/dev/raw/raw3: bound to major 8, minor 19/dev/raw/raw4: bound to major 8, minor 20/dev/raw/raw5: bound to major 8, minor 21***************************************************************************** 10.配置互信******************************************************************************* 互信oracle 用户和grid用户都要执行（只在一个节点执行即可）脚本在/soft/grid/sshsetup目录下,第一个脚本用grid用户执行，第二个脚本用oracle用户执行./sshUserSetup.sh -user grid -hosts " rac01test rac01test " -advanced -noPromptPassphrase./sshUserSetup.sh -user oracle -hosts "node3 node4" -advanced -noPromptPassphrase******************************************************************************* 11.检测互信*******************************************************************************请注意，当您使用ssh 第一次访问远程主机时，其RSA 密钥将是未知的，从而将提示您确认是否希望连接该主机。