一、所需软件
1. 虚拟机:virtualbox 5.1.26
2. 数据库：oracle 11.2.0.4
3. 操作系统：oracle linux 6.10
4. 终端仿真软件：SecureCRT
5. 跨平台集成软件：Xmanager Enterprise 4
6. 存储管理软件：openfiler 2.99.1
二、集群环境规划
2.1 IP 规划
|
Hostname |
Host alias |
Type |
IP Address |
Interface |
|
rac1（主机名） |
rac1 |
Public IP |
192.168.2.20 |
eth0 |
|
rac1-vip |
rac1-vip |
Virtual IP |
192.168.2.21 |
eth0:1 |
|
rac1-priv |
rac1-priv |
Private IP |
10.0.2.10 |
etch1 |
|
|
||||
|
rac2（主机名） |
rac2 |
Public IP |
192.168.2.30 |
eth0 |
|
rac2-vip |
rac2-vip |
Virtual IP |
192.168.2.31 |
eth0:1 |
|
rac2-priv |
rac2-priv |
Private IP |
10.0.2.11 |
etch1 |
|
|
||||
|
scan-cluster |
scan-cluster |
Scan IP |
192.168.2.50 |
eth0 |
|
|
||||
|
Openfiler(主机名) |
Openfiler |
|
192.168.2.100 |
eth0 |
|
|
|
|
192.168.2.101 |
eth1 |
2.2 目录规划
|
Grid Infrastructure |
Oracle Database |
|
HOME=/home/grid |
HOME=/home/oracle |
|
ORACLE_BASE=/u01/app/grid |
ORACLE_BASE=/u01/app/oracle |
|
ORACLE_HOME=/u01/app/11.2.0/grid |
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 |
2.3 用户与用户组规划
|
Group name |
Group ID |
Group info |
Oracle User |
Grid User |
|
oinstall |
1000 |
Inventory group |
Y |
Y |
|
dba |
1030 |
osdba group |
Y |
Y |
|
oper |
1031 |
osoper group |
Y |
|
|
asmadmin |
1020 |
osasm |
|
Y |
|
asmdba |
1021 |
osdba for asm |
Y |
Y |
|
asmoper |
1022 |
osoper for asm |
|
Y |
2.4 Oracle SID
Database SID |
racdb |
Node 1 Instance SID |
racdb1 |
Node 2 Instance SID |
racdb2 |
2.5存储规划
存储LUN(分区)规划原则（生产环境）
Ø 数据文件和归档日志文件底层属于不同的RAID组，属于不同DG(磁盘组)
Ø 在线日志文件同一组中不同成员分别存储在两个DG中；
Ø 控制文件不同成员分别存储在两个DG中；
Ø OCR和VOTEDISK存放在数据之外单独的ASM磁盘组
ASM磁盘划分好：
|
Rac节点 |
Lun_name |
ASM磁盘名称/alias |
Size |
ASM磁盘组名称 |
冗余类型 |
|
Rac1 |
|
asmocrvote1 |
2g |
SYSTEMDG |
high/normal |
|
|
asmocrvote2 |
2g |
|||
|
|
asmocrvote3 |
2g |
|||
|
|
asmr5datadisk1 |
200g |
DATADG1 |
external |
|
|
|
asmr5datadisk2 |
200g |
DATADG2 |
||
|
|
asmr5archdisk1 |
200g |
FRADG |
external |
|
|
|
|
|
|
|
|
|
Rac1 |
|
asmocrvote1 |
2g |
SYSTEMDG |
high/normal |
|
|
asmocrvote2 |
2g |
|||
|
|
asmocrvote3 |
2g |
|||
|
|
asmr5datadisk1 |
200g |
DATADG1 |
external |
|
|
|
asmr5datadisk2 |
200g |
DATADG2 |
||
|
|
asmr5archdisk1 |
200g |
FRADG |
external |
2.6系统整体拓扑图
