AIX5.3 + HACMP5.3 install oracle9i1、安装AIX5.3 ,打PATCH到5304或53052、配置AIX网络,HOSTS文件如下:-----------------------------------------------------------------------127.0.0.1 loopback localhost # loopback (lo0) name/address192.168.6.121 orasvra192.168.6.122 orasvrb10.1.1.1 orasvra-priv10.1.1.2 orasvrb-priv-----------------------------------------------------------------------3、安装HACMP注意,安装HACMP的时候,建议不要安装VSD用的pssp rsct.basic.sp &pat.basic.sp和所有的VSD安装包4、配置HACMP,如下:-----------------------------------------------------------------------Cluster Name: ora_clusterCluster Connection Authentication Mode: StandardCluster Message Authentication Mode: NoneCluster Message Encryption: NoneUse Persistent Labels for Communication: NoThere are 2 node(s) and 2 network(s) definedNODE orasvra:Network net_diskhb_01orasvra_hb /dev/hdisk3Network net_ether_01orasvra 192.168.6.121orasvra-priv 10.1.1.1NODE orasvrb:Network net_diskhb_01orasvrb_hb /dev/hdisk3Network net_ether_01orasvrb-priv 10.1.1.2orasvrb 192.168.6.122Resource Group ora_resStartup Policy Online On All Available NodesFallover Policy Bring Offline (On Error Node Only)Fallback Policy Never FallbackParticipating Nodes orasvrb orasvra-----------------------------------------------------------------------个人观点:⏹上面网络配置中,心跳采用硬盘心跳,心跳测试:/usr/sbin/rsct/bin/dhb_read -p hdisk3 -r/usr/sbin/rsct/bin/dhb_read -p hdisk3 -t⏹ORACLE9i RAC不用配置服务IP⏹检查网络情况:/usr/es/sbin/cluster/utilities/cllsif -S5、用户管理:a)通过HACMP创建用户ORACLE、用户组DBA/hagsuserb)修改用户资源的限制,特别是文件的限制,把文件限制改为-16、配置ORACLE环境变量,如下:-----------------------------------------------------------------------export ORACLE_BASE=/oracleexport ORACLE_HOME=$ORACLE_BASE/product/9.2.0exportLD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:$ORA_CRS_HOME/lib:$ORA_CRS_ HOME/lib32export ORACLE_SID=RACDB1export NLS_LANG=AMERICAN_AMERICA.ZHS16GBKexportPATH=$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:/usr/bin:/etc:/usr/lbin:/usr/bin/X11:/u sr/local/binexport DBCA_RAW_CONFIG=dbca_raw_configexport PGSD_SUBSYS=grpsvcsexport AIXTHREAD_SCOPE=Sumask 022-----------------------------------------------------------------------注意:上面的环境变量COPY到AIX下的时候,必须注意转行符号,到COPY到写字板再到AIX下面。
7、相互安全认证:a)对于root用户,编辑文件/.rhosts,把信任主机写到上面。
b)对于oracle用户,编辑文件/home/oracle/.rhosts,把信任主机写到上面。
.rhosts文件内容如下:-----------------orasvrborasvraorasvra-privorasvrb-priv-----------------注意:.rhosts文件的权限不能是777,必须是6448、创建LV:-----------------------------------------------------------------------mklv -y 'system_512m ' -w'n' -s'n' -r'n' oradatavg 16mklv -y 'cwmlite_128m' -w'n' -s'n' -r'n' oradatavg 4mklv -y 'undotbs1_1024m' -w'n' -s'n' -r'n' oradatavg 32mklv -y 'undotbs2_1024m' -w'n' -s'n' -r'n' oradatavg 32mklv -y 'temp_1024m' -w'n' -s'n' -r'n' oradatavg 32mklv -y 'example_192m' -w'n' -s'n' -r'n' oradatavg 6mklv -y 'users_1024m' -w'n' -s'n' -r'n' oradatavg 32mklv -y 'redo1_1_64m' -w'n' -s'n' -r'n' oradatavg 2mklv -y 'redo2_1_64m' -w'n' -s'n' -r'n' oradatavg 2mklv -y 'redo1_2_64m' -w'n' -s'n' -r'n' oradatavg 2mklv -y 'redo2_2_64m' -w'n' -s'n' -r'n' oradatavg 2mklv -y 'control1_128m' -w'n' -s'n' -r'n' oradatavg 4mklv -y 'control2_128m' -w'n' -s'n' -r'n' oradatavg 4mklv -y 'control3_128m' -w'n' -s'n' -r'n' oradatavg 4mklv -y 'spfile_32m' -w'n' -s'n' -r'n' oradatavg 1mklv -y 'pwdfile_32m' -w'n' -s'n' -r'n' oradatavg 1mklv -y 'oemrepo_32m' -w'n' -s'n' -r'n' oradatavg 1mklv -y 'indx_72m' -w'n' -s'n' -r'n' oradatavg 3mklv -y 'tools_32m' -w'n' -s'n' -r'n' oradatavg 1mklv -y 'drsys_96m' -w'n' -s'n' -r'n' oradatavg 3-----------------------------------------------------------------------创建完后,注意设置LV的权限给ORACLE,权限为6649、安装ORACLE软件10、通过DBCA生成数据库创建脚本运行DBCA的时候,必须保证GSD已起来,不然没有办法创建数据库脚本。
注:通过命令gsdctl start启动GSD,如果GSD没有办法启动,检查一下文件/var/opt/oracle/srvConfig.loc 是否存在,不在的情况下,编辑文件,加入内容:srvconfig_loc=/dev/rsrvmconf_128m并通过命令:srvconfig –init完成初始化。