linux,IBM安装oracle RAC详细步骤

Install oracle 10R2 RAC with HACMP 5.2 on IBM AIX 5.3 软件环境 AIX 5L 5.3 ML4 AIX补丁 HACMP 5.2 Oracle 10.2.0.1 Oracle补丁10.2.0.2 硬件环境 RS6000 2台 (每台主机有4个以太网网卡、2个光纤卡、一个串口) 光纤磁盘阵列DS4300 1台 1、 安装aix系统 扩充 / 2gb 扩充 /home 4gb 扩充 /usr 4gb 扩充 /var 4gb 扩充 /tmp 2gb 扩充 /opt 20gb 扩充 /var/adm/ras/platform 1gb /etc/hosts文件 192.168.0.101 rac1 192.168.0.102 rac2 192.168.0.103 rac1vip 192.168.0.104 rac2vip 10.10.10.101 rac1priv 10.10.10.102 rac2priv 2、 在rac1和rac2上，创建oinstall、dba、hagsuser组 /bin/mkgroup oinstall /bin/mkgroup dba /bin/mkgroup hagsuser 3、 在rac1和rac2上，创建oracle用户： # smitty user Add a User Type or select values in entry fields. Press Enter AFTER making all desired changes. * User NAME [oracle] User ID [500] Primary GROUP [oinstall] Group SET [dba,hagsuser] Soft FILE size [-1] Soft CPU time [-1] Soft DATA segment [-1] Soft STACK size [-1] 保证两台主机的组号要一致！ /etc/group oinstall:!:203: dba:!:204: hagsuser:!:205: # id oracle uid=500(oracle) gid=203(oinstall) groups=204(dba),205(hagsuser) 4、 配置系统配置参数 配置每用户的最大进程数、调整water mark smitty chgsys Maximum number of PROCESSES allowed per user [4096] HIGH water mark for pending write I/Os per file [33] LOW water mark for pending write I/Os per file [24] Stack Execution Disable (SED) Mode off 配置网络可调参数 修改文件/etc/rc.net，将如下几行加到文件的尾部： if [ -f /usr/sbin/no ] then /usr/sbin/no -p -o udp_sendspace=65536 /usr/sbin/no -p -o udp_recvspace=655360 /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=512 fi 修改异步I/O（须重启） smitty chgaio [Entry Fields] MINIMUM number of servers [30] # MAXIMUM number of servers [60] # maximum number of REQUESTS [4096] # server PRIORITY [39] # STATE to be configured at system restart available + State of fast path enable + # mkdev –l aio0 使异步I/O可用 调整syncd频率 修改文件/sbin/rc.boot #nohup /usr/sbin/syncd 60 > /dev/null 2>&1 & nohup /usr/sbin/syncd 10 > /dev/null 2>&1 & 5、 创建串口设备 smitty mktty 测试串口设备 cat </dev/tty0 cat /etc/hosts > /dev/tty0 6、 安装oracle、hacmp支持包 smitty installp 需要安装以下操作系统包： Bos.adt bos.cifs_fs Bos.clvm bos.compat bos.data Bos.perf rsct.basic rsct.compat.basic rsct.compat.clients rsct.core （在扩展盘上HACMP 5.2不需要，5.3需要） rsct.exp.cimrm 2.4.2.0 （以下包在AIX Toolbox for Linux Applications盘上，安装SSH的前提包） openssl-0.9.7g openssl-devel-0.9.7g openssl-doc-0.9.7g （以下包在扩展盘上） openssh.base openssh.license openssh.man.en_US 要将license改为接受！！！ （在网上download） xlC.aix50.rte:7.0.0.4 xlC.rte:7.0.0.1 7、 安装hacmp软件 smitty installp 8、 安装磁盘阵列，创建共享卷 准备磁盘阵列 # hostname rac1 # lspv hdisk0 0002e54aa58657e9 rootvg active hdisk1 0002657c5acf302b None hdisk2 0002657c4d26e7ba None hdisk3 0002657c5acf4bc3 None hdisk4 0002657c4cc04d52 None hdisk5 0002ee503cc8dcaa None # # hostname rac2 # lspv hdisk0 0002e5baa58258aa rootvg active hdisk1 0002657c5acf302b None hdisk2 0002657c4d26e7ba None hdisk3 0002657c5acf4bc3 None hdisk4 0002657c4cc04d52 None hdisk5 0002ee503cc8dcaa None 创建一个并行vg名字为oracle_vg # hostname rac1 # # smitty mkvg Add a Big Volume Group Type or select values in entry fields. Press Enter AFTER making all desired changes. [Entry Fields] VOLUME GROUP name [oracle_vg] Physical partition SIZE in megabytes 128 * PHYSICAL VOLUME names [hdisk5] Force the creation of a volume group? yes Activate volume group AUTOMATICALLY no at system restart? Volume Group MAJOR NUMBER [60] Create VG Concurrent Capable? enhanced concurrent # varyonvg oracle_vg 创建oracle使用的并行卷 mklv -y'dy_crs1024m' -w'n' -s'n' -r'n' oracle_vg 8 hdisk5 mklv -y'dy_vote1024m' -w'n' -s'n' -r'n' oracle_vg 8 hdisk5 mklv -y'dy_system_1024m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5 mklv -y'dy_pwdfile_100m' -w'n' -s'n' -r'n' oracle_vg 1 hdisk5 mklv -y'dy_sysaux_800m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5 mklv -y'dy_undo1_4096m' -w'n' -s'n' -r'n' oracle_vg 40 hdisk5 mklv -y'dy_undo2_4096m' -w'n' -s'n' -r'n' oracle_vg 40 hdisk5 mklv -y'dy_temp_4096m' -w'n' -s'n' -r'n' oracle_vg 40 hdisk5 mklv -y'dy_example_800m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5 mklv -y'dy_users_800m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5 mklv -y'dy_redo1_1_500m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5 mklv -y'dy_redo1_2_500m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5 mklv -y'dy_redo1_3_500m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5 mklv -y'dy_redo1_4_500m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5 mklv -y'dy_redo1_5_500m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5 mklv -y'dy_redo1_6_500m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5 mklv -y'dy_redo2_1_500m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5 mklv -y'dy_redo2_2_500m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5 mklv -y'dy_redo2_3_500m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5 mklv -y'dy_redo2_4_500m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5 mklv -y'dy_redo2_5_500m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5 mklv -y'dy_redo2_6_500m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5 mklv -y'dy_ctl1_110m' -w'n' -s'n' -r'n' oracle_vg 1 hdisk5 mklv -y'dy_ctl2_110m' -w'n' -s'n' -r'n' oracle_vg 1 hdisk5 mklv -y'dy_ctl3_110m' -w'n' -s'n' -r'n' oracle_vg 1 hdisk5 mklv -y'dy_spfile_110m' -w'n' -s'n' -r'n' oracle_vg 1 hdisk5 mklv -y'dy_recover4096m' -w'n' -s'n' -r'n' oracle_vg 40 hdisk5 在另外一台主机上import共享卷 # hostname rac2 # smitty vg Volume Groups Move cursor to desired item and press Enter. Import a Volume Group Import a Volume Group Type or select values in entry fields. Press Enter AFTER making all desired changes. [Entry Fields] VOLUME GROUP name [oracle_vg] * PHYSICAL VOLUME name