oracle 11gR2 RAC on AIX6.1 安装手册

时间：2026-01-22

安装的每个步骤都有截图

Oracle 11gR2 RAC on AIX6.1上安装

安装环境

操作系统：6100-06-03-1048 数据库：oracle 11gR2

操作系统需要打补丁：IZ88711SP2.101121.epkg.Z，解决oracle Bug:10259393

通过ftp://http://www.77cn.com.cn/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 -y'lv_oracle' -t'jfs2' -a'c' 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/asm chown -R grid:dba /oracle/grid chown -R oracle:dba /oracle/db chmod -R 755 /oracle

9,修改用户环境变量 grid

export ORACLE_BASE=/oracle/grid #需手工创建 export ORACLE_HOME=/oracle/asm #需手工创建 export ORACLE_SID=+ASM1 #节点2是+ASM2 export NLS_LANG=AMERICAN_AMERICA.UTF8

export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss" export PATH=.:${PATH}:$ORACLE_HOME/bin

export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin export PATH=${PATH}:$ORACLE_BASE/common/oracle/bin export

ORACLE_PATH=${PATH}:$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin export

LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/oracm/lib:/lib:/usr/lib:/usr/local/lib

安装的每个步骤都有截图

export

CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

oracle

export ORACLE_BASE=/oracle/db #需手工创建 export ORACLE_HOME=$ORACLE_BASE/product/11.2 export ORACLE_SID=ylqzdb1

export NLS_LANG=AMERICAN_AMERICA.zhs16gbk

export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss" export

PATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/bin:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin:$ORACLE_BASE/common/oracle/bin export

ORACLE_PATH=${PATH}:$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin export

LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/oracm/lib:/lib:/usr/lib:/usr/local/lib export

CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

10,ssh信任关系设置

ln -s /usr/bin/ksh /bin/bash mkdir -p /usr/local/bin

ln -s /usr/bin/ssh-keygen /usr/local/bin/ssh-keygen

11，设置磁盘属性

lsattr -El hdisk2 | grep reserve_ 如果上面查看的结果是reserve_policy

chdev -l hdisk2 -a reserve_policy=no_reserve chdev -l hdisk3 -a reserve_policy=no_reserve chdev -l hdisk4 -a reserve_policy=no_reserve 如果上面查看的结果是reserve_lock chdev -l hdisk4 -a reserve_lock=no

12，设置pv属主

chown grid:dba /dev/rhdisk2 chown grid:dba /dev/rhdisk3 chown grid:dba /dev/rhdisk4

安装的每个步骤都有截图

13，设置pv权限

chmod 660 /dev/rhdisk2 chmod 660 /dev/rhdisk3 chmod 660 /dev/rhdisk4

14，配置/etc/hosts

# *** Oracle Scan IP *** 10.20.117.242 db_scan

# *** Oracle Public IP*** 10.20.117.19 node1 10.20.117.20 node2

# *** Oracle Virtual IP *** 10.20.117.240 node1-vip 10.20.117.241 node2-vip

# *** Oracle Private IP *** 192.168.1.1 node1-priv 192.168.1.2 node2-priv

15,检查

prtconf |grep Memory lsps -a df -g /tmp oslevel -r