Oracle Study之-AIX6.1构建Oracle 11gR2 RAC(1)

Oracle Study之-AIX6.1构建Oracle 11gR2 RAC(1)

环境：

操作系统： 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

System Model: IBM,7028-6C4Machine Serial Number: 1096B0DProcessor Type: PowerPC_POWER4Processor Implementation Mode: POWER 4Processor Version: PV_4_2Number Of Processors: 2Processor Clock Speed: 1453 MHzCPU Type: 64-bitKernel Type: 64-bitLPAR Info: 1 NULLMemory Size: 4096 MBGood Memory Size: 4096 MBPlatform Firmware level: 3R041029Firmware Version: IBM,RG041029_d79e00_rConsole Login: enableAuto Restart: trueFull Core: falseNX Crypto Acceleration: Not CapableNetwork 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

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

  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

en2: flags=5e084863,c0        inet 192.168.8.209 netmask 0xffffff00 broadcast 192.168.8.255en0: flags=5e084863,c0        inet 10.10.10.209 netmask 0xffffff00 broadcast 10.10.10.255

[root@aix210 /]#ifconfig -a

en2: flags=5e084863,c0        inet 192.168.8.210 netmask 0xffffff00 broadcast 192.168.8.255en0: flags=5e084863,c0        inet 10.10.10.210 netmask 0xffffff00 broadcast 10.10.10.255

[root@aix209 tmp]#cat /etc/hosts

192.168.8.209  aix209192.168.8.251  aix209-vip10.10.10.209   aix209-priv192.168.8.210   aix210192.168.8.252   aix210-vip10.10.10.210    aix210-priv192.168.8.253   rac_scan

-------- 本次构建不使用DNS Server，所以在hosts文件解析scan ip。

二、创建配置用户

[root@aix209 /]#cat mkuser.sh

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

配置用户：（分配权限、资源配置）

[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

oracle:        fsize = -1        data = -1        stack = -1        core = -1        rss = -1        nofiles = -1        threads = -1        nproc = -1grid:        fsize = -1        data = -1        stack = -1        core = -1        rss = -1        nofiles = -1        threads = -1        nproc = -1

配置用户profile：

grid用户：

[grid@aix210 ~]$cat .profileexport EDITOR=viexport ORACLE_SID=+ASM2export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=/u01/gridexport GRID_HOME=/u01/gridexport LD_LIBRARY_PATH=$ORACLE_HOME/libexport THREADS_FLAG=nativeexport PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/binumask 022

Oracle 用户:

[oracle@aix210 ~]$cat .profileORACLE_BASE=/u01/app/oracleORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1ORACLE_SID=prod2PATH=$PATH:$ORACLE_HOME/binexport ORACLE_BASE ORACLE_HOME ORACLE_SID PATH

三、创建文件系统及目录

[root@aix209 /]#cat mkdir.sh

mkdir -p /u01/app/oracle mkdir -p /u01/grid mkdir -p /u01/app/oraInventory chown -R oracle:oinstall /u01/app/oraclechown -R grid:oinstall /u01/grid chown -R grid:oinstall /u01/app/oraInventory chmod -R 775 /u01/

-----未完，待续...