CentOS6.6+Openfiler+Oracle 11.2.0.4+RAC+ASM安装文档
目录
一,系统准备工作 ............................................................................................................... 4 1.1,RAC架构规划 .......................................................................................................... 4 1.2,修改/etc/hosts文件 ................................................................................................ 4 1.3,安装所需要的软件包 .............................................................................................. 5 1.4,添加用户,组和目录 .............................................................................................. 5 1.5,配置用户环境变量 .................................................................................................. 7 1.6,配置内核参数 ........................................................................................................ 10 1.7,设置系统资源限制 ................................................................................................ 10 1.8,配置时间同步 ........................................................................................................ 12 1.9,关闭系统防火墙和selinux .................................................................................... 13 二,配置Openfiler存储系统 ............................................................................................ 14 2.1,存储规划 ................................................................................................................ 14 2.2,配置Openfiler ........................................................................................................ 14 2.3,在Oracle RAC节点上配置iSCSI卷 ...................................................................... 21 2.4,在Oracle RAC节点上配置multipath ................................................................... 22 2.5,在Oracle RAC节点上配置ASM ........................................................................... 29 三,安装集群软件部分 ..................................................................................................... 30 3.1,准备安装软件 ........................................................................................................ 30 3.2,安装前的环境检查 ................................................................................................ 31 3.3,安装过程 ................................................................................................................ 31 3.4,卸载grid ................................................................................................................. 41 四,数据库安装配置部分 ................................................................................................. 41 4.1,安装oracle11.2.0.4数据库软件 ........................................................................... 41 4.2,创建ASM磁盘组 .................................................................................................. 47 4.3,创建RAC数据库 ................................................................................................... 49 4.4,建立监听服务 ........................................................................................................ 59 4.5,安装后的验证与检查 ............................................................................................ 62 五,安装中遇到的问题及解决 ......................................................................................... 65 5.1,注意事项 ................................................................................................................ 65
5.2,节点一执行root.sh 成功、节点二执行root.sh失败 ......................................... 66
一,系统准备工作 1.1,RAC架构规划
服务器主机名 公共IP地址 虚拟IP地址 私有IP地址 Oracle rac sid 集群实例名称 SCAN IP 操作系统 存储 Oracle版本 racnode1 192.168.2.236 192.168.2.246 172.16.1.1 racdb1 racdb 192.168.2.238 CentOS6.6-x86_64 Openfiler Oracle 11.2.0.4 racnode2 192.168.2.237 192.168.2.247 172.16.1.2 racdb2 1.2,修改/etc/hosts文件
所有节点都要配置 [root@racnode1 ~]# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 #Public Network - (eth0) 192.168.2.236 racnode1 192.168.2.237 racnode2 #Private Interconnect - (eth1) 172.16.1.1 racnode1-priv 172.16.1.2 racnode2-priv #Public Virtual IP(VIP) - (eth0:1) 192.168.2.246 racnode1-vip 192.168.2.247 racnode2-vip #Single Client Access Name (SCAN) 192.168.2.238 rac-scan #Storage Network for Openfiler - (eth0) 192.168.2.233 openfiler
1.3,安装所需要的软件包
所有节点都要执行
Oracle Linux 6, Red Hat Enterprise Linux 6 The following packages (or later versions) must be installed: binutils-2.20.51.0.2-5.11.el6 (x86_64) compat-libcap1-1.10-1 (x86_64) compat-libstdc++-33-3.2.3-69.el6 (x86_64) compat-libstdc++-33-3.2.3-69.el6.i686 gcc-4.4.4-13.el6 (x86_64) gcc-c++-4.4.4-13.el6 (x86_64) 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.i686 ksh libgcc-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.i686 libstdc++-devel-4.4.4-13.el6 (x86_64) libstdc++-devel-4.4.4-13.el6.i686 libaio-0.3.107-10.el6 (x86_64) libaio-0.3.107-10.el6.i686 libaio-devel-0.3.107-10.el6 (x86_64) libaio-devel-0.3.107-10.el6.i686 make-3.81-19.el6 sysstat-9.0.4-11.el6 (x86_64) 配置好yum,使用yum安装
yum install binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel elfutils-libelf-devel-static gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers ksh libaio libaio-devel libgcc libgomp libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-develcompat-libstdc++-33.i686libaio.i686 libaio-devel.i686 libstdc++.i686 unixODBC.i686 unixODBC-devel.i686glibc-devel.i686glibc.i686 libgcc.i686 libstdc++-devel.i686 -y
1.4,添加用户,组和目录
1.4.1,RAC使用的用户与组的关系
描述 OS 组名 分配给该组Oracle 权限 Oracle 组名