环境：
操作系统： AIX 6100-09（SP3)
Cluster： HACMP6.1
集群软件： GI 11.2.0.1
数据库： Oracle 11.2.0.1
构建AIX平台下RAC 依据共享存储的使用方式可以分两种：
1、建立基于并发卷组（VG concurrent）的共享存储
2、建立基于ASM下的RAW的共享存储
由于本系统阵列（SUN T300）不支持并发存储，不具有reserve_policy或reserve_lock属性；所以在使用ASM做并发存储时，其中一个节点访问磁盘后会锁定磁盘，而另外的节点就不能再访问共享盘；所以本次环境是通过HACMP实现并发卷组的共享，然后再通过逻辑卷建立ASM DISKGOUP. 这样整个系统多了hacmp，增加了管理的复杂性。
系统架构：
本次系统架构为：AIX 6100-09(SP3)+HACMP6.1+ASM+Oracle GI + Oracle 11gR2
一、系统环境
[root@aix209 /]#oslevel -s
6100-09-03-1415
[root@aix209 /]#prtconf |more
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
System Model: IBM,
7028
-6C4
Machine Serial
Number
: 1096B0D
Processor Type: PowerPC_POWER4
Processor Implementation Mode: POWER
4
Processor Version: PV_4_2
Number
Of Processors:
2
Processor Clock Speed:
1453
MHz
CPU Type:
64
-bit
Kernel Type:
64
-bit
LPAR Info:
1
NULL
Memory Size:
4096
MB
Good Memory Size:
4096
MB
Platform Firmware level: 3R041029
Firmware Version: IBM,RG041029_d79e00_r
Console Login: enable
Auto Restart:
true
Full Core:
false
NX Crypto Acceleration: Not Capable
Network Information
Host Name: aix209
IP Address:
192.168.
8.209
Sub Netmask:
255.255.
255.0
Gateway:
Name Server:
Domain Name:
|
页面交换空间：（Oracle 11g需要页面交换空间最少3G）
[root@aix210 /]#lsps -a
Page Space Physical Volume Volume Group Size %Used Active Auto Type Chksum
paging00 hdisk0 rootvg 2048MB 0 yes yes lv 0
hd6 hdisk0 rootvg 2048MB 0 yes yes lv 0
[root@aix210 /]#lsps -s
Total Paging Space Percent Used
4096MB 0%
需要安装的软件包：
[root@aix210 soft]#lslpp -l |grep -i xlc
|
1
2
3
4
|
xlC.aix61.rte
12.1.
0.1
COMMITTED IBM XL C++ Runtime
for
AIX
6.1
xlC.cpp
9.0.
0.0
COMMITTED C
for
AIX Preprocessor
xlC.rte
12.1.
0.1
COMMITTED IBM XL C++ Runtime
for
AIX
xlC.sup.aix50.rte
9.0.
0.1
COMMITTED XL C/C++ Runtime
for
AIX
5.2
|
[root@aix210 soft]#lslpp -l |grep -i bos.perf
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
bos.perf.diag_tool
6.1
.
8.15
COMMITTED Performance Diagnostic Tool
bos.perf.fdpr
6.1
.
8.15
COMMITTED Feedback Directed Program
bos.perf.libperfstat
6.1
.
9.15
COMMITTED Performance Statistics Library
bos.perf.perfstat
6.1
.
9.15
COMMITTED Performance Statistics
bos.perf.pmaix
6.1
.
9.15
COMMITTED Performance Management
bos.perf.proctools
6.1
.
9.15
COMMITTED Proc Filesystem Tools
bos.perf.tools
6.1
.
9.15
COMMITTED Base Performance Tools
bos.perf.tune
6.1
.
9.15
COMMITTED Performance Tuning Support
bos.perf.diag_tool
6.1
.
8.15
COMMITTED Performance Diagnostic Tool
bos.perf.libperfstat
6.1
.
9.15
COMMITTED Performance Statistics Library
bos.perf.perfstat
6.1
.
9.0
COMMITTED Performance Statistics
bos.perf.pmaix
6.1
.
9.15
COMMITTED Performance Management
bos.perf.tools
6.1
.
9.15
COMMITTED Base Performance Tools
bos.perf.tune
6.1
.
9.15
COMMITTED Performance Tuning Support
|
网络环境：
[root@aix209 /]#ifconfig -a
|
1
2
3
4
|
en2: flags=5e084863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),PSEG,LARGESEND,CHAIN>
inet
192.168
.
8.209
netmask
0xffffff00
broadcast
192.168
.
8.255
en0: flags=5e084863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),PSEG,LARGESEND,CHAIN>
inet
10.10
.
10.209
netmask
0xffffff00
broadcast
10.10
.
10.255
|
[root@aix210 /]#ifconfig -a
|
1
2
3
4
|
en2: flags=
5e084863
,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),PSEG,LARGESEND,CHAIN>
inet
192.168.
8.210
netmask
0xffffff00
broadcast
192.168.
8.255
en0: flags=
5e084863
,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),PSEG,LARGESEND,CHAIN>
inet
10.10.
10.210
netmask
0xffffff00
broadcast
10.10.
10.255
|
[root@aix209 tmp]#cat /etc/hosts
|
1
2
3
4
5
6
7
|
192.168.
8.209
aix209
192.168.
8.251
aix209-vip
10.10.
10.209
aix209-priv
192.168.
8.210
aix210
192.168.
8.252
aix210-vip
10.10.
10.210
aix210-priv
192.168.
8.253
rac_scan
|
-------- 本次构建不使用DNS Server，所以在hosts文件解析scan ip。
二、创建配置用户
[root@aix209 /]#cat mkuser.sh
|
1
2
3
4
5
6
7
8
9
|
mkgroup -
'A'
id=
'1000'
adms=
'root'
oinstall
mkgroup -
'A'
id=
'1020'
adms=
'root'
asmadmin
mkgroup -
'A'
id=
'1021'
adms=
'root'
asmdba
mkgroup -
'A'
id=
'1022'
adms=
'root'
asmoper
mkgroup -
'A'
id=
'1031'
adms=
'root'
dba
mkgroup -
'A'
id=
'1032'
adms=
'root'
oper
mkuser id=
'1001'
pgrp=
'oinstall'
groups=
'dba,asmdba,asmadmin,oper'
home=
'/home/oracle'
oracle
mkuser id=
'1002'
pgrp=
'oinstall'
groups=
'asmadmin,asmdba,asmoper,oper,dba'
home=
'/home/grid'
grid
|
配置用户：（分配权限、资源配置）
|
1
2
|
[root@aix210 /]#/usr/bin/chuser capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE grid
[root@aix210 /]#/usr/bin/chuser capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE oracle
|
[root@aix209 /]#cat /etc/security/limits
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
oracle:
fsize = -
1
data = -
1
stack = -
1
core = -
1
rss = -
1
nofiles = -
1
threads = -
1
nproc = -
1
grid:
fsize = -
1
data = -
1
stack = -
1
core = -
1
rss = -
1
nofiles = -
1
threads = -
1
nproc = -
1
|
配置用户profile：
grid用户：
|
1
2
3
4
5
6
7
8
9
10
|
[grid
@aix210
~]$cat .profile
export EDITOR=vi
export ORACLE_SID=+ASM2
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/grid
export GRID_HOME=/u01/grid
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export THREADS_FLAG=
native
export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin
umask
022
|
Oracle 用户:
|
1
2
3
4
5
6
|
[oracle@aix210 ~]$cat .profile
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/
11.2.
0
/db_1
ORACLE_SID=prod2
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH
|
三、创建文件系统及目录
[root@aix209 /]#cat mkdir.sh
|
1
2
3
4
5
6
7
|
mkdir -p /u01/app/oracle
mkdir -p /u01/grid
mkdir -p /u01/app/oraInventory
chown -R oracle:oinstall /u01/app/oracle
chown -R grid:oinstall /u01/grid
chown -R grid:oinstall /u01/app/oraInventory
chmod -R
775
/u01/
|
-----未完，待续...
