2.2 Oracle相关的配置
2.2.1创建用户在db01和db02上,创建oinstall、dba、hagsuser组
2.2.2在db01和db02上,创建oracle用户:
2.2.3安装oracle、hacmp支持包
2.2.4安装磁盘阵列,创建共享卷
准备磁盘阵列
# hostname
db01
# lspv
hdisk0 0002e54aa58657e9 rootvg active
hdisk1 0002657c5acf302b rootvg active
hdisk2 0002657c4d26e7ba None
hdisk3 0002657c5acf4bc3 None
hdisk4 0002657c4cc04d52 None
hdisk5 0002ee503cc8dcaa None
#
# hostname
db02
# lspv
hdisk0 0002e54aa58657e9 rootvg active
hdisk1 0002657c5acf302b rootvg active
hdisk2 0002657c4d26e7ba None
hdisk3 0002657c5acf4bc3 None
hdisk4 0002657c4cc04d52 None
hdisk5 0002ee503cc8dcaa None
?? 在其中一个节点,创建一个并行vg名字为datavg
# hostname
db01
#
# smitty mkvg
Add a Big Volume Group
Type or select values in entry fields.
Press Enter AFTER making all desired changes.
[Entry Fields]
VOLUME GROUP name [datavg] +
Physical partition SIZE in megabytes 512
* PHYSICAL VOLUME names [hdisk2,hdisk3] +
Force the creation of a volume group yes +
Activate volume group AUTOMATICALLY no +
at system restart?
Volume Group MAJOR NUMBER [60]
Create VG Concurrent Capable? enhanced concurrent +
PS:确认所有卷组必须以concurrent模式被激活,两个节点可以同时对磁盘进行操作.
# varyonvg datavg
创建oracle使用的并行卷
使用下面命令。或者将如下命令便写成一个脚本然后执行。后面的partition size的个数请参考自己系统的情况。
mklv -y'rac_crs1024m' -w'n' -s'n' -r'n' datavg 2 hdisk2
mklv -y'rac_vote1024m' -w'n' -s'n' -r'n' datavg 2 hdisk2
mklv -y'rac_system_1024m' -w'n' -s'n' -r'n' datavg 4 hdisk2
mklv -y'rac_pwdfile_100m' -w'n' -s'n' -r'n' datavg 1 hdisk2
mklv -y'rac_sysaux_800m' -w'n' -s'n' -r'n' datavg 4 hdisk2
mklv -y'rac_undo1_4096m' -w'n' -s'n' -r'n' datavg 16 hdisk2
mklv -y'rac_undo2_4096m' -w'n' -s'n' -r'n' datavg 16 hdisk2
mklv -y'rac_temp_4096m' -w'n' -s'n' -r'n' datavg 16 hdisk2
mklv -y'rac_users_800m' -w'n' -s'n' -r'n' datavg 4 hdisk2
mklv -y'rac_redo1_1_120m' -w'n' -s'n' -r'n' datavg 2 hdisk2
mklv -y'rac_redo1_2_120m' -w'n' -s'n' -r'n' datavg 2 hdisk2
mklv -y'rac_redo1_3_120m' -w'n' -s'n' -r'n' datavg 2 hdisk2
mklv -y'rac_redo2_1_120m' -w'n' -s'n' -r'n' datavg 2 hdisk2
mklv -y'rac_redo2_2_120m' -w'n' -s'n' -r'n' datavg 2 hdisk2
mklv -y'rac_redo2_3_120m' -w'n' -s'n' -r'n' datavg 2 hdisk2
mklv -y'rac_ctl1_100m' -w'n' -s'n' -r'n' datavg 1 hdisk2
mklv -y'rac_ctl2_100m' -w'n' -s'n' -r'n' datavg 1 hdisk2
mklv -y'rac_ctl3_100m' -w'n' -s'n' -r'n' datavg 1 hdisk2
mklv -y'rac_spfile_100m' -w'n' -s'n' -r'n' datavg 1 hdisk2
通过mklv命令创建完lv后,会在/dev/下生成两个文件,比如:
# mklv -y'rac_spfile_100m' -w'n' -s'n' -r'n' datavg 1 hdisk2
那么在/dev/下会生成两个文件
/dev/rac_spfile_100m
/dev/rrac_spfile_100m
前面多了一个r的文件就是我们要使用的character devices。
也就是我们通常所说的裸设备。
在另外一个节点上import共享卷
# hostname
db02
# smitty vg
Volume Groups
Move cursor to desired item and press Enter.
Import a Volume Group
Import a Volume Group
Type or select values in entry fields.
Press Enter AFTER making all desired changes.
[Entry Fields]
VOLUME GROUP name [datavg]
* PHYSICAL VOLUME name [hdisk2,hdisk3] +
Volume Group MAJOR NUMBER [60] +#
修改共享卷的属性(建议两台主机都要做)
# varyonvg datavg
# chown oracle:dba /dev/rrac_*
# varyoffvg datavg