oracle_11gR2_RAC_on_AIX6.1_安裝手册.doc

Oracle 11gR2 RAC on AIX6.1上安装 安装环境 操作系统：6100-06-03-1048 数据库：oracle 11gR2 操作系统需要打补丁：IZ88711SP2.101121.epkg.Z，解决oracle Bug通过/aix/efixes/iz88711/下载文件，并在aix操作系统下以root用户执行： emgr -e IZ88711SP2.101121.epkg.Z 如果没有打补丁，在安装database软件的时候会报错：Error in invoking target agent nmb nmo nmhs of makefile 环境配置 1、建立用户和组 mkgroup -A id=300 adms=root dba mkuser id=300 pgrp=dba oracle mkuser id=301 pgrp=dba grid mkgroup -A id=600 users=root,oracle,grid hagsuser 2,赋用户权限 chuser capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE grid chuser capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE oracle 3，修改用户shell vi /etc/security/limits root: fsize = -1 cpu = -1 data = -1 stack = -1 core = 2097151 rss = -1 nofiles = -1 fsize_hard = -1 cpu_hard = -1 data_hard = -1 stack_hard = -1 rss_hard = -1 nofiles_hard = -1 oracle: fsize = -1 cpu = -1 data = -1 stack = -1 core = 2097151 rss = -1 nofiles = -1 fsize_hard = -1 cpu_hard = -1 data_hard = -1 stack_hard = -1 rss_hard = -1 nofiles_hard = -1 grid: fsize = -1 cpu = -1 data = -1 stack = -1 core = 2097151 rss = -1 nofiles = -1 fsize_hard = -1 cpu_hard = -1 data_hard = -1 stack_hard = -1 rss_hard = -1 nofiles_hard = -1 4,修改AIO参数 ioo -o aio_maxreqs=65536 ioo -o aio_minservers=20 ioo -o aio_maxservers=80 5，调整虚拟内存参数 vmo -p -o minperm%=5 vmo -p -o maxperm%=90 vmo -p -o maxclient%=90 vmo -p -o lru_file_repage=0 6，调整用户进程参数 chdev -l sys0 -a maxuproc=16384 chdev -l sys0 -a ncargs=256 7，调整网络参数 lsattr -El sys0 -a pre520tune 输出如： pre520tune disable Pre-520 tuning compatibility mode True 说明是不兼容方式，这样就可以用下面的方式调整： no -r -o ipqmaxlen=512 no -p -o rfc1323=1 no -p -o sb_max=1500000 no -p -o tcp_recvspace=65536 no -p -o tcp_sendspace=65536 no -p -o udp_recvspace=1351680 no -p -o udp_sendspace=135168 8，建立文件系统及目录 /usr/sbin/mklv -ylv_oracle -