oracle11gr2 RAC For AIX安装.doc

Oracle 11gr2 rac for aix 安装手册目录第1章 安装准备21.1 操作系统环境配置21.1.1 系统补丁21.1.2 网络配置21.1.3 hosts文件21.1.4 修改网络可调参数21.1.5 配置异步I/O21.1.6 调整process大小31.1.7 设置ncargs参数31.1.8 VMM内存参数修改31.1.9 检查scan配置31.2 oracle环境配置41.2.1 创建组用户41.2.2 配置ssh(grid用户及oracle用户)51.2.3 配置.profile文件71.2.4 创建安装文件系统71.2.5 配置ASM磁盘组71.2.6 上传及解压文件8第2章 安装及配置GRID Infrastructure92.1 安装GRID9第3章 DB软件安装203.1 安装数据库软件20第4章 创建ASM磁盘组284.1 配置.profile文件284.2 创建磁盘组28第5章 创建数据库315.1 创建数据库TESTDB31第6章 管理维护426.1 CRS管理42第1章 安装准备1.1 操作系统环境配置1.1.1 系统补丁 1.1.2 网络配置1.1.3 hosts文件 loopback localhost # loopback (lo0) name/address77 aix17778 aix17875 aix175-vip76 aix176-vip77 aix177-pri78 aix178-pri1.1.4 修改网络可调参数checking：# /usr/sbin/no -a | fgrep ephemeraltcp_ephemeral_low = 32768tcp_ephemeral_high = 65535udp_ephemeral_low = 32768udp_ephemeral_high = 65535change：# /usr/sbin/no -p -o tcp_ephemeral_low=9000 -o tcp_ephemeral_high=65500# /usr/sbin/no -p -o udp_ephemeral_low=9000 -o udp_ephemeral_high=65500vi /etc/添加以下内容if -f /usr/sbin/no ; then/usr/sbin/no -p -o udp_sendspace=131072/usr/sbin/no -p -o udp_recvspace=1310720/usr/sbin/no -p -o tcp_sendspace=65536/usr/sbin/no -p -o tcp_recvspace=65536/usr/sbin/no -p -o rfc1323=1/usr/sbin/no -p -o sb_max=1310720/usr/sbin/no -r -o ipqmaxlen=512fi1.1.5 配置异步I/O# smitty chgaio# mkdev -l aio0 使异步I/O可用需要将maxreqs调整至oracle推荐的大小65536，6.1版本默认大小65536，则无需更改checking# lsattr -El aio0 -a maxreqschangesmitty chgaio将maximum nuber of requests调整至65536说明：aix 6.1# ioo -o aio_maxreqsaio_maxreqs = 655361.1.6 调整process大小checking:lsattr -El sys0 -a maxuprocchange:/usr/sbin/chdev -l sys0 -a maxuproc=163841.1.7 设置ncargs参数增加system block size。推荐增加ARG/ENV 空间分配至128,也就是128个4k的blockchecking:#lsattr -E -l sys0 -a ncargschange#/usr/sbin/chdev -l sys0 -a ncargs=128默认256，不做变更1.1.8 VMM内存参数修改 Checking:#vmo -L minperm% #vmo -L maxperm% #vmo -L maxclient% #vmo -L lru_file_repage #vmo -L strict_maxclient#vmo -L strict_maxpermChange: #vmo -p -o minperm%=3 #vmo -p -o maxperm%=90 #vmo -p -o maxclient%=90 #vmo -p -o lru_file_repage=0 #vmo -p -o strict_maxclient=1 #vmo -p -o strict_maxperm=01.1.9 检查scan配置#nslookup #nslookup 77#nslookup 78#nslookup 791.2 oracle环境配置1.2.1 创建组用户组：#mkgroup -A id=1000 adms=root oinstall#mkgroup -A id=1100 adms=root asmadmin#mkgroup -A id=1200 adms=root dba#mkgroup -A id=1300 adms=root asmdba#mkgroup -A id=1301 adms=root asmoper用户：#mkuser id=1100 pgrp=dba groups= oinstall,asmadmin,asmdba,asmoper home=/home/grid grid#mkuser id=1101 pgrp=dba groups=oinstall,asmdba home=/home/oracle oracle通过smitty chuser更改root及oracle用户属性#chuser capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE grid#chuser capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE oracle# lsuser -a capabilities grid gridcapabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE# lsuser -a capabilities grid oracle1.2.2 配置ssh(grid用户及oracle用户)gird用户：aix177生成密钥oracleaix177 $ ssh-keygen -t rsaoracleaix177 $ ssh-keygen -t dsaaix178生成密钥oracleaix178 $ ssh-keygen -t rsaoracleaix178 $ ssh-keygen -t dsaaix177生成认证文件oracleaix177 $ ssh aix177 cat /home/grid/.ssh/id_rsa.pub /.ssh/authorized_keysoracleaix177 $ ssh aix177 cat /home/grid/.ssh/id_dsa.pub /.ssh/authorized_keysoracleaix177 $ ssh aix178 cat /home/grid/.ssh/id_rsa.pub /.ssh/authorized_keysThe authenticity of host aix178 () cant be established.RSA key fingerprint is 40:5b:e9:d0:52:c5:3c:80:fe:81:d5:c6:08:28:7e:58.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added aix178, (RSA) to the list of known hosts.oracleaix177 $ ssh aix178 cat /home/grid/.ssh/id_dsa.pub /.ssh/authorized_keysaix178生成认证文件oracleaix178 $ ssh aix177 cat /home/grid/.ssh/id_rsa.pub /.ssh/authorized_keysoracleaix178 $ ssh aix177 cat /home/grid/.ssh/id_dsa.pub /.ssh/authorized_keysoracleaix177s password: oracleaix178 $ ssh aix178 cat /home/grid/.ssh/id_rsa.pub /.ssh/authorized_keys oracleaix178 $ ssh aix178 cat /home/grid/.ssh/id_dsa.pub /.ssh/authorized_keys有效性验证检查，不需要输入口令表明配置成功。oracleaix177 $ ssh aix177 date; ssh aix178 dateFri Dec 28 16:59:12 CST 2007Fri Dec 28 16:58:12 CST 2007 oracleaix178 $ ssh aix177 date; ssh aix178 dateFri Dec 28 16:59:24 CST 2007Fri Dec 28 16:58:24 CST 2007oracle用户aix177生成密钥oracleaix177 $ ssh-keygen -t rsaoracleaix177 $ ssh-keygen -t dsaaix178生成密钥oracleaix178 $ ssh-keygen -t rsaoracleaix178 $ ssh-keygen -t dsaaix177生成认证文件oracleaix177 $ ssh aix177 cat /home/oracle/.ssh/id_rsa.pub /.ssh/authorized_keysoracleaix177 $ ssh aix177 cat /home/oracle/.ssh/id_dsa.pub /.ssh/authorized_keysoracleaix177 $ ssh aix178 cat /home/oracle/.ssh/id_rsa.pub /.ssh/authorized_keysThe authenticity of host aix178 () cant be established.RSA key fingerprint is 40:5b:e9:d0:52:c5:3c:80:fe:81:d5:c6:08:28:7e:58.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added aix178, (RSA) to the list of known hosts.oracleaix177 $ ssh aix178 cat /home/oracle/.ssh/id_dsa.pub /.ssh/authorized_keysaix178生成认证文件oracleaix178 $ ssh aix177 cat /home/oracle/.ssh/id_rsa.pub /.ssh/authorized_keysoracleaix178 $ ssh aix177 cat /home/oracle/.ssh/id_dsa.pub /.ssh/authorized_keysoracleaix177s password: oracleaix178 $ ssh aix178 cat /home/oracle/.ssh/id_rsa.pub /.ssh/authorized_keys oracleaix178 $ ssh aix178 cat /home/oracle/.ssh/id_dsa.pub /.ssh/authorized_keys有效性验证检查，不需要输入口令表明配置成功。oracleaix177 $ ssh aix177 date; ssh aix178 dateFri Dec 28 16:59:12 CST 2007Fri Dec 28 16:58:12 CST 2007 oracleaix178 $ ssh aix177 date; ssh aix178 dateFri Dec 28 16:59:24 CST 2007Fri Dec 28 16:58:24 CST 20071.2.3 配置.profile文件说明：先不要设置ORACLE_HOME/ORACLE_BASE/ORACLE_SID gird用户#export ORACLE_BASE=/haclu/app/oracle #export ORACLE_HOME=/haclu/app/11.2.0/grid export AIXTHREAD_SCOPE=S export TEMP=/tmp export TMP=/tmp export TMPDIR=/tmp umask 022 oracle用户： #ORACLE_BASE=/ haclu/app/db#ORACLE_HOME=/ haclu/app/db/product/11.2.0/db_1 export AIXTHREAD_SCOPE=S export TEMP=/tmp export TMP=/tmp export TMPDIR=/tmp umask 0221.2.4 创建安装文件系统smitty jfs2 - /haclu 30G#mkdir -p /haclu/app/11.2.0/grid#chown -R grid:dba/haclu#mkdir -p /haclu/app/oracle#chown oracle:dba /haclu/app/oracle#chmod -R 775 /haclu1.2.5 配置ASM磁盘组配置用于ocr/vote设备及数据库存储的ASM磁盘组rootaix177:/# lspvhdisk0 00c7f6d4a99c322b rootvg activehdisk1 00c7f6d4a5edc04a rootvg activehdisk2 00c7f6d491dd6fd3 None hdisk3 00c7f6d491dd709d None hdisk4 00c7f6d491dd715d None hdisk5 00c7f6d491dd7244 None hdisk6 00c7f6d491dd734f None hdisk7 00c7f6d491dd743b None hdisk8 00c7f6d491dd76a0 None hdisk9 00c7f6d491dd7940 None hdisk10 00c7f6d491dd7a58 None hdisk11 00c7f6d491dd7c39 None hdisk12 00c7f6d491dd7d0d None hdisk13 00c7f6d491dd7de0 None hdisk14 00c7f6d491dd7f3f None hdisk15 00c7f6d491dd800a None hdisk16 00c7f6d491dd81c4 None hdisk17 00c7f6d491dd82a4 None hdisk18 00c7f6d491dd8461 None hdisk19 00c7f6d491021e69 None hdisk20 00c7f6d491021f41 None hdisk21 00c7f6d491022637 None 查看磁盘属性getconf DISK_SIZE /dev/rhdisk*lscfg -vl hdisk*修改磁盘策略及清除PVIDchdev -l hdisk* -a pv=clearchdev -l hdisk* -a reserve_policy=no_reserve修改磁盘属主及权限：chown grid:dba rhdisk*chmod 660 rhdisk*1.2.6 上传及解压文件aix.ppc64_11gR2_grid.zipaix.ppc64_11gR2_database_1of2.zipaix.ppc64_11gR2_database_2of2.zip第2章 安装及配置GRID Infrastructure2.1 安装GRID使用root用户执行：#./rootpre.sh安装前的检查cuv#./runcluvfy.sh stage -pre crsinst -n aix177,aix178 -r 11gR2 -verbose#su - grid$./runInstaller创建OCRVOTE磁盘组说明：实际情况是这里选择了External外部冗余按照提示执行上述脚本，并完成安装第3章 DB软件安装3.1 安装数据库软件由于的BUG，在选择集群安装无法找到第二个节点，需要使用grid用户分别在两台机器上执行以下命令：cd /haclu/app/11.2.0/grid/oui/bin节点1：./runInstaller -updateNodeList CLUSTER_NODES=aix177,aix178 ORACLE_HOME=/haclu/app/11.2.0/grid ORACLE_HOME_NAME=GI_11201 LOCAL_NODE=aix177 CRS=true节点2：./runInstaller -updateNodeList CLUSTER_NODES=aix177,aix178 ORACLE_HOME=/haclu/app/11.2.0/grid ORACLE_HOME_NAME=GI_11201 LOCAL_NODE=aix178 CRS=true$./runInstaller注：选定双节点注：以root用户执行相关脚本（两台服务器均做）第4章 创建ASM磁盘组4.1 配置.profile文件修改grid用户和oracle用户的.profilegird用户export ORACLE_BASE=/haclu/app/oracle export ORACLE_H