oracle11gR2RACon_AIX6.1手册.docVIP

Oracle 11gR2 RAC on AIX6.1上安装 安装环境 操作系统：6100-06-03-1048 数据库：oracle 11gR2 环境配置 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 -tjfs2 -ac rootvg 40 /usr/sbin/crfs -v jfs2 -d lv_oracle -m /oracle -A yes -p rw mount /oracle chown -R oracle.dba /oracle mkdir -p /oracle/grid mkdir -p /oracle/asm mkdir -p /oracle/db chown -R grid:dba /oracle chown -R grid:dba /oracle/