发布时间 : 星期四 文章ORACLE 12C R2 RAC集群部署搭建更新完毕开始阅读dbd5656d53d380eb6294dd88d0d233d4b04e3f6f
ORACLE 12C R2 RAC集群部署搭建
目录
1、ORACLE 12.2软硬件要求 ............................................................................................. 3
1.1 硬件最低配置要求 ................................................................................................ 3 1.2 ORACLE 12.2认证的OS软件版本 ........................................................................... 3 2、整体规划部分 .................................................................................................................. 3
2.1 IP地址规划 ............................................................................................................ 4 2.2 操作系统本地磁盘分区规划 ................................................................................. 4 2.3 共享存储与ASM磁盘组规划 ................................................................................. 4 3、操作系统配置部分 .......................................................................................................... 5
3.1 配置hosts文件 ................................................................................................... 5 3.2 安装RPM包 ........................................................................................................... 5 3.3创建用户组 ............................................................................................................. 6 3.4 创建文件目录及权限配置 ..................................................................................... 7 3.5 配置环境变量 ....................................................................................................... 7 3.6 安装cvuqdisk ...................................................................................................... 8 4、修改操作系统配置 .......................................................................................................... 9
4.1 开启nscd ............................................................................................................. 9 4.2 关闭防火墙 ........................................................................................................... 9 4.3 禁用selinux ........................................................................................................ 9 4.4 关闭TransparentHugePages ................................................................................ 9
4.5 配置/etc/security/limits.conf ...................................................................... 10 4.6 配置/etc/sysctl.conf ...................................................................................... 10 4.7 配置/etc/pam.d/login ...................................................................................... 11 4.8 配置DNS ............................................................................................................. 11 4.9 修改时间同步方式 .............................................................................................. 11 4.10 修改nsswitch.conf ......................................................................................... 12 4.10 配置NOZEROCONF ............................................................................................... 12 4.11 配置互信 .......................................................................................................... 12 5、ASM磁盘配置部分 ....................................................................................................... 13
5.1 UDEV配置asm磁盘(两个节点都执行) .............................................................. 13 5.2 验证asm disk生成 ............................................................................................ 13 5.2 修改磁盘属性 ..................................................................................................... 14 6、grid软件安装 ................................................................................................................ 14
6.1 检测安装环境 ..................................................................................................... 14 6.2 安装GI(Grid Infrastructure) ..................................................................... 16 7 、asmca创建其它asmdiskgroup .................................................................................. 26 8、database软件安装 ....................................................................................................... 27 9、创建CDB ...................................................................................................................... 32 10、创建PDB .................................................................................................................... 37
10.1 以命令方式创建PDB ......................................................................................... 37 10.2 查看创建成功的PDB ......................................................................................... 38
1、ORACLE 12.2软硬件要求 1.1 硬件最低配置要求 序号 1 2
1.2 ORACLE 12.2认证的OS软件版本 序号
组件
Oracle Linux 7 with the Unbreakable Enterprise kernel: 3.8.13-35.3.1.el7uek.x86_64 or later
Oracle Linux 7 with the Red Hat Compatible kernel: 3.10.0-123.el7.x86_64 or later
Oracle Linux 6.4 with the Unbreakable Enterprise kernel 2: 2.6.39-200.24.1.el6uek.x86_64 or later
Oracle Linux 6 with the Red Hat Compatible kernel: 2.6.32-358.el6.x86_64 or later
Red Hat Enterprise Linux 7: 3.10.0-123.el7.x86_64 or later Red Hat Enterprise Linux 6: 2.6.32-358.el6.x86_64 or later SUSE Linux Enterprise Server 12: 3.12.28-4-default or later SUSE Linux Enterprise Server 11 SP2: 3.0.13-0.27 or later 组件
Oracle Grid Infrastructure installations Oracle Database installations
内存需求 4GB以上
最小1GB,建议2GB以上
1
2
3
4
5 6 7 8
2、整体规划部分
2.1 IP地址规划 序号 1 2 3 4 5 7 8 9 10 11 12 13
2.2 操作系统本地磁盘分区规划 序号 1 2 3 4
2.3 共享存储与ASM磁盘组规划 序号
磁盘名称
Asm磁盘名称
磁盘组名称
大小
用途
分区名称 /boot / swap /dba
大小 200MB
用途说明 引导分区
所属 GNS Node1 Node1
rac1
Node1 Node1 Node2 Node2
rac2
Node2 Node2 scan scan scan
Private1 Private2 scan1 scan2 scan3
10.1.1.193 10.1.1.194 192.168.1.195 192.168.1.196 192.168.1.197
Private1 Private2 public vip
10.1.1.191 10.1.1.192 192.168.1.193 192.168.1.194
主机名称
用途 GNS public vip
IP地址 192.168.1.190 192.168.1.191 192.168.1.192
12288MB(12G) 根分区 6144MB 44850MB
最少4.7303GB以上 oracle安装目录