数据库实施部署
Oracle Linux6.5下安装Oracle11gr2 RAC
——WORD文档，下载后可编辑修改——
2018年版本
1
1 集群规划....................................................................................................................................... 4
1.1 硬件环境 ....................................................................................................................... 4 1.2 软件环境 ....................................................................................................................... 4 1.3 RAC拓朴 ........................................................................................................................ 4 1.4 IP规划 .......................................................................................................................... 4 1.5 存储规划 ....................................................................................................................... 5 2 安装实施....................................................................................................................................... 5
2.1 安装前准备 ....................................................................................................................... 5 2.2 主机环境准备 ................................................................................................................... 5
2.2.1 操作系统安装 ....................................................................................................... 5 2.2.2服务器内存要求 .................................................................................................... 6 2.3 网络配置 ........................................................................................................................... 6
2.3.1 配置IP .................................................................................................................. 6 2.3.2 配置主机名 ........................................................................................................... 7 2.3.3 配置/etc/hosts ................................................................................................... 7 2.4 安装依赖包 ....................................................................................................................... 7 2.5修改内核参数 .................................................................................................................... 9 2.6 修改oracle用户限制 ..................................................................................................... 9 2.7修改/etc/pam.d/login .................................................................................................. 10 2.8关闭防火墙 ...................................................................................................................... 10 2.9停用ntp服务 .................................................................................................................. 10 2.10更改安装所有者的ulimit设置 .................................................................................. 11 2.11添加用户及创建安装目录 ............................................................................................ 11 2.12 设置oracle用户环境变量 ......................................................................................... 12 2.13 设置grid用户环境变量 ............................................................................................. 12 2.14 所有节点执行，测试SSH联通性 ............................................................................... 13
2.14.1 配置SSH ............................................................................................................ 13 2.14.2 验证SSH ............................................................................................................ 13
3.共享存储配置 ............................................................................................................................. 13
3.1共享存储服务器配置 ...................................................................................................... 13 3.2共享存储客户端配置 ...................................................................................................... 13 4 两个节点ASM搭建 ..................................................................................................................... 14
4.1 安装ASM包 ..................................................................................................................... 14 4.2 配置ASM .......................................................................................................................... 14 4.3 共享磁盘分区 ................................................................................................................. 14 4.4创建ASM磁盘 .................................................................................................................. 15 4.4扫描磁盘 asm磁盘，检查有哪些 asm磁盘： ............................................................ 15 5安装Oracle grid集群件 .......................................................................................................... 15
5.1安装前检查 ...................................................................................................................... 15 5.2解压及安装 ...................................................................................................................... 15 5.3安装检查 .......................................................................................................................... 27 5.4卸载grid ......................................................................................................................... 27 6 配置ASM磁盘 ............................................................................................................................. 28 7 安装Oracle数据库软件 ........................................................................................................... 31 8 创建数据库实例 ......................................................................................................................... 37 9 数据库管理工作 ......................................................................................................................... 48
2
9.1RAC的启停 ........................................................................................................................ 48 9.2 RAC检查运行状况 .......................................................................................................... 48 9.3 测试验证 ......................................................................................................................... 49
3
1 集群规划
1.1 硬件环境
服务器：HP DL980 G7 256G内存 存储：HP 3PAR SS7400 1.2 软件环境
数据库：linux.x64_11gR2
集群件：linux.x64_11gR2_grid 操作系统：oracle linux 6.5 ASM包：
oracleasm-support-2.1.8-1.el6.x86_64.rpm oracleasmlib-2.0.12-1.el6.x86_64.rpm
oracleasm在操作系统oracle linux中已内置安装 1.3 RAC拓朴
1.4 IP规划
1.4.1 IP地址要求
每个节点一个public IP 每个节点一个public VIP 每个节点一个private IP
一个用于集群的SCAN名称和一到三个和public IP同网段的IP，本处用一个
IP,VIP和private IP写入/etc/hosts文件
4