aix hacmp oracle 双机集群实施步骤,AIX+HACMP+Oracle双机集群项目

4、Oracle安装及配置(两台服务器上均需进行)

(1)oracle安装环境检查

1)mem>1G

#lsattr -El mem0

3、swap>mem*1.2

#lsps -a

4、/tmp>400M

#df -k(df -m或df -g都可)

5、Hard Disk Space: 4G(安装所需空间)+3G(安装源文件)

#df -k

(2)AIX扩展软件包及补丁需求

#lslpp -l bos.adt.lib

#lslpp -l bos.adt.libm

#lslpp -l bos.perf.libbperfstat

#lslpp -l bos.perf.libperfstat

#lslpp -l bos.perf.proctools

#instfix -ik IY58143

#instfix -ik IY59386

#instfix -ik IY60930

#instfix -ik IY66513

#instfix -ik IY70159

#instfix -ik IY68989

(3)其他参数限制

#smit system --change/show characteristics of OS

关键点：

Maximum number of PROCESSES allowed per user设为2048

#smit aio --change/show characteristics of AIO

关键点：

STATE to be configured at system restart设为avaliable(更改异步IO(在oracle中必须打开(AIX6默认打开))

(4)增加用户和组

#smit group --add group --oinstall/dba

#smit user --add user --oracle

#passwd oracle

关键点：

User Name设为oracle

Primary Group设为dba,haguser

Soft file size,soft cpu time,soft data segment,soft stack size和soft core file size均设为-1。软限：(-1表示没有限制)

(5)修改环境变量

#vi /home/oracle/.profile

Umask 022

Export ORACLE_SID=ora101(B801设置)

Export ORACLE_SID=ora102(B802设置)

Export ORACLE_BASE=/oracle

Export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1

Export ORACLE_TERM=xterm

Export ORA_NLS33=$ORACLE_HOME/nls/data

Export LS_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib:.

Export NLS_LANG=American_america.zhs16gbk

Export SHLIB_PATH=$ORACLE_HOME/lib:.:$PATH:/usr/local/bin:/usr/ccs/bin

Export CLASSPATH=$ORACLE_HOME/jlib:.

Export LIBPATH=$ORACLE_HOME/JDK/JRE/BIN:$ORACLE_HOME/jdk/jre/bin/classic:$ORACLE_HOME/lib32

Export DISPLAY=192.168.100.101:0.0 (B801设置)

Export DISPLAY=192.168.100.102:0.0 (B802设置)

#vi /home/oracle/.pprofile

DTSOURCEPROFILE=true

(6)创建oracle文件系统及处理oracle安装文件

#mklv -y lv_oracle rootvg 8G

#smit fs

#mount /oracle

#chown -R oracle:oinstall /oracle

#chmod -R 775 /oracle

#su - oracle

$cd /oracle

$gunzip 10gr2_aix5l64_database.cpio.gz

$cpio -icdmv < 10gr2_5l64_database.cpio

(7)以oracle用户重新登录并开始安装oracle

$su - root

#/oracle/Disk1/rootpre/rootpre.sh(完毕后关闭当前窗口)(系统环境检查脚本，也可能)

$cd /oracle/Disk1

$./runInstaller

(8)建立裸设备并创 建实例(可仅在主机上，完成后import到备机即可)

B801#varyonvg datavg801

B801#varyonvg datavg802

B801#mklv -y lv_ora1_spfile datavg801 1

B801#mklv -y lv_ora1_ctrl01 datavg801 1

B801#mklv -y lv_ora1_ctrl02 datavg801 1

B801#mklv -y lv_ora1_ctrl03 datavg801 1

B801#mklv -y lv_ora1_redo01 datavg801 1

B801#mklv -y lv_ora1_redo02 datavg801 1

B801#mklv -y lv_ora1_redo03 datavg801 1

B801#mklv -y lv_ora1_system datavg801 10

B801#mklv -y lv_ora1_sysaux datavg801 10

B801#mklv -y lv_ora1_undo01 datavg801 10

B801#mklv -y lv_ora1_temp01datavg801 10

B801#mklv -y lv_ora1_user01 datavg801 20

B801#mklv -y lv_ora2_spfile datavg801 1

B801#mklv -y lv_ora2_ctrl01 datavg801 1

B801#mklv -y lv_ora2_ctrl02 datavg801 1

B801#mklv -y lv_ora2_ctrl03 datavg801 1

B801#mklv -y lv_ora2_redo01 datavg801 1

B801#mklv -y lv_ora2_redo02 datavg801 1

B801#mklv -y lv_ora2_redo03 datavg801 1

B801#mklv -y lv_ora2_system datavg802 10

B801#mklv -y lv_ora2_sysaux datavg802 10

B801#mklv -y lv_ora2_undo01 datavg802 10

B801#mklv -y lv_ora2_temp01 datavg802 10

B801#mklv -y lv_ora2_user01 datavg802 20

B801#hown oracle /dev/*lv*

B801#varyoffvg datavg801

B801#varyoffvg datavg802

B802#importvg -y datavg801 hdisk?

B802#importvg -y datavg802 hdisk?

B802#chown oracle /dev/*lv*

B802#smitty chvg

Datavg801和datavg802在B802上经importvg后，属性恢复为默认设置，应重新定义两数据VG的active automativally属性为NO