下载文档原格式
RAC(ASM)到单机OGG配置案例环境说明：源端DB：操作系统：AIX 7100-02-07-1524数据库：oracle_11.2.0.1.0 RACgoldengate：for_11g_ppc目标端DB：操作系统：windows 7数据库：oracle_11.2.0.1.0goldengate：for_11g_x86注意：本实验是模拟在不同平台同版本上面安装和配置OGG，并实现简单的DML复制，至于复杂的其他方面希望大家能自己多多实验。
作者：姓名：ZhangQYQQ：5056357配置步骤：1、检查源端和目标端正确的IP解析：源端：# cat /etc/hosts# 10.2.0.2 x25sample # x.25 name/address# 2000:1:1:1:209:6bff:feee:2b7f ipv6sample # ipv6 name/address 127.0.0.1 loopback localhost # loopback (lo0) name/address ::1 loopback localhost # IPv6 loopback (lo0)name/address172.16.16.101 zqdb192.169.79.11 zqdb172.16.16.165 oradg192.169.79.12 oradg172.16.16.166 gc1-scan.zqdb172.16.16.168 zqdb-vip172.16.16.169 oradg-vip目标端：C:\Windows\System32\drivers\etc\hosts无特殊配置2、设置LIBPATH，为了安装OGG所用的动态链接库。
如果没有配置这个路径的话，在安装OGG的过程中会报找不到动态链接库的错误，用户可以自己尝试一下。
源端：# su - oraclezqdb:/home/oracle>$vi .profile".profile" 25 lines, 756 charactersPATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.export PATHif [ -s "$MAIL" ] # This is at Shell startup. In normalthen echo "$MAILMSG" # operation, the Shell checksfi # periodically.OGG_HOME=/oracle/ogg/12.1.2ORACLE_BASE=/oracle/ora11gORACLE_HOME=/oracle/ora11g/product/11gORACLE_SID=ora11g1export ORACLE_BASE ORACLE_HOME ORACLE_SIDORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/dataNLS_LANG=AMERICAN_AMERICA.ZHS16GBKLD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/libexport ORA_NLS33 NLS_LANG LD_LIBRARY_PATHPATH=$PATH:$ORACLE_HOME/bin:$OGG_HOMEexport PATHLIBPATH=$ORACLE_HOME/lib32:$ORACLE_HOME/libexport LIBPATHexport DISPLAY=172.17.2.203:0.0export PS1="`hostname`":'$PWD>$'目标端：无特殊配置3、在源端创建专用的表空间、schema、并授权。
AIX下划裸设备给RAC（oracle集群）1.环境介绍两台IBM小型机P55A、系统为AIX5.3、分别装了数据库oracle，并作了RAC 集群，RAC用VG名叫jha_datavg。
2.需求分析现RAC已划裸设备全部使用完毕，需从jha_datavg里新划裸设备给RAC使用，并把jha_datavg的剩余未划得空间全部划完然后给RAC使用。
3.具体操作步骤3.1.在其中一台执行◆lsvg –o 查看系统里有哪些VG◆lsvg jha_datavg 查看此VG里详细信息为：64M/PP，客户需要划4G/裸设备，共剩余111G未划。
所以每个裸设备需划分64个PP。
◆lsvg –l jha_datavg 查看所包含的lv与裸设备。
◆mklv -t 'raw' -y lvjha_04g_01 jha_datavg 64 划分一个裸设备尝试◆lsvg –l jha_datavg 查看裸设备是否划分成功◆mklv -t 'raw' -y lvjha_04g_(02-25) jha_datavg 64 划分剩于的24个裸设备◆cd /dev chown oracle：dba rlvjha_04g_* 附于属主、属组◆ls -l 查看属主、属组是否修改成功3.2.在RAC的另一台执行◆lsvg –l jha_datavg 查看VG里裸设备划分是否已自动同步过来◆lsvg jha_datavg 查看VG里详细信息是否与另一台一致◆ls -l /dev/lvjha_04g_* 查看裸设备的划分情况◆chown oracle:dba /dev/rlvjha_04g_* 附于属主、属组◆ls -l 查看属主、属组是否修改成功4.总结RAC里划分裸设备成功，交由oracle工程师使用并查看是否成功。
Oracle 11g RAC for AIX安装步骤目录一、安操作系统检查3二、安装装备工作42.1.创建Grid Infrastructure和oracle用户和组42.2.创建Grid 集群如阿健和Oracle Database目录52.3.检查硬件条件52.4.IP地址分配52.5.调整操作系统参数62.6.配置ntp服务（服务端、客户端）82.7.配置SSH92.8.配置 SSH LoginGraceTime 参数102.9.配置GI用户环境102.10.配置ORACLE环境变量112.11.准备ASM磁盘11三、Grid Infrastructure安装过程153.1.检查root 用户umask为022153.2.检查grid 用户umask为022153.3.检查oracle 用户umask为022153.4./etc/hosts准备153.5.检查ifconfig值153.6.清理socket文件153.7.开始安装GI16四、安装Oracle Database 11gR2(不建库)29五、安装最新的OPatch33六、Oracle GI & RDBMS 安装PSU3补丁(18706472)34七、调整GI资源35八、调整ASM参数35九、安装ONE-OFF补丁35十、创建数据库36十一、加载one-off 补丁SQL 语句41十二、调整数据库参数41十三、调整11g 默认 profile42十四、Oracle11g RAC常用命令4214.1.数据库集群源状态查看4214.2.Oracle11g GI 启停命令4314.3.维护注意点43一、安操作系统检查1.检查软件条件二、安装装备工作2.1.创建Grid Infrastructure和oracle用户和组创建/oracle目录，大小为80G[2个节点]mkgroup -'A' id='1000' adms='root' oinstallmkgroup -'A' id='1100' adms='root' asmadminmkgroup -'A' id='1200' adms='root' dbamkgroup -'A' id='1300' adms='root' asmdbamkgroup -'A' id='1301' adms='root' asmopermkgroup -'A' id='1302' adms='root' operuseradd -u '1100' -g 'oinstall' -G 'asmadmin,asmdba,asmoper' -m griduseradd -u '1101' -g 'oinstall' -G 'dba,asmdba,oper' -m oraclepasswd gridpasswd oracle说明:并需要使用该用户重新登录一次。
aix6.1+grid+rac+oracle 11g安装配置手册系统架构摘要aix 6100-004+oracle grid 11gr2+oracle rac+oracle database hostname oradb1 oradb2IP address:10.1.1.71 oradb210.1.1.73 oradb2vip192.168.101.71 oradb2priv10.1.1.70 oradb1192.168.101.70 oradb1priv10.1.1.72 oradb1vip10.1.1.74 oracrs用户：root/rootgrid/gridoracle/oracle安装前准备工作/usr/sbin/lsattr -E -l sys0 -a realmem/usr/sbin/lsps -alsattr -El rhdisk3 -a size_mb编辑/etc/hostsvi /etc/hosts加入：10.1.1.71 oradb210.1.1.73 oradb2vip192.168.101.71 oradb2priv10.1.1.70 oradb1192.168.101.70 oradb1priv10.1.1.72 oradb1vip10.1.1.74 oracrs----安装SSH的软件包及配置在AIX Toolbox for Linux Applications盘上，安装SSH的前提包openssl-0.9.7gopenssl-devel-0.9.7gopenssl-doc-0.9.7g在扩展盘上openssh.baseopenssh.licenseopenssh.man.en_USFIXPACKIZ39665IZ29348IZ55160调整用户的SHELL Limit修改/etc/security/limits文件中root oracle用户相关部分如下：root:fsize = -1core = -1cpu = -1data = -1rss = -1stack = -1nofiles = -1oracle:fsize = -1core = -1cpu = -1data = -1rss = -1stack = -1nofiles = -1调整系统参数lsattr -E -l sys0 -a maxuproc/usr/sbin/chdev -l sys0 -a maxuproc=16384/usr/sbin/no -r -o ipqmaxlen=512/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=1301720创建oinstall、dbamkgroup -A id=1000 oinstallmkgroup -A id=1200 dbamkuser id=1100 pgrp=oinstall groups=dba home='/home/grid' gridmkuser id=1101 pgrp=oinstall groups=dba home='/home/oracle' oraclemkdir -p /oracle/gridchown -R grid:oinstall /oraclemkdir /oracle/appchown oracle:oinstall /oracle/appchmod -R 775 /oracle/passwd gridpasswd oraclelsuser -a capabilities gridchuser capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGA TE grid验证oracle用户# id oracleuid=500(oracle) gid=202(oinstall) groups=203(dba)保证各节点都一样，并设置密码passwd oracleGrid安装配置1.设置ASM设备/usr/sbin/chdev -l hdisk2 -a pv=clear/usr/sbin/chdev -l hdisk3 -a pv=clear/usr/sbin/chdev -l hdisk4 -a pv=clear/usr/sbin/chdev -l hdisk5 -a pv=clearchdev -l hdisk2 -a pv=yeschdev -l hdisk3 -a pv=yeschdev -l hdisk4 -a pv=yeschdev -l hdisk5 -a pv=yes准备asm磁盘chown grid:oinstall /dev/rhdisk3chmod 660 /dev/rhdisk3chdev -l hdisk3 -a reserve_policy=no_reserve2.用户配置文件vi .profilePATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.if [ -s "$MAIL" ] # This is at Shell startup. In normalthen echo "$MAILMSG" # operation, the Shell checksfi # periodically.export ORACLE_BASE=/oracle/appexport ORACLE_HOME=/oracle/gridumask 022PATH=$PATH:/oracle/grid/binexport PATHexport TEMP=/tmpexport TMPDIR=/tmp3.分别在两台主机上运行如下命令配置grid用户的ssh互信，注意只能一条条运行，不能一次全部复制运行mkdir ~/.sshchmod 700 ~/.ssh/usr/bin/ssh-keygen -t rsa/usr/bin/ssh-keygen -t dsa在oradb1上,一条条分别依次执行。
Oracle 10g RAC for AIX6.1硬件环境：2台IBM P520 服务器，2台光纤交换机，1台IBM DS4700磁盘阵列（1.2TB）软件环境： Oracle 10g R2 （需升级到10.2.0.4）， AIX6.11.IP规划:racdb1 公网：172.16.28.31VIP：172.16.28.33心跳: 192.168.100.1racdb2 公网: 172.16.28.32VIP: 172.16.28.34心跳：192.168.100.22.需要的软件包：bos.adt.libbos.adt.libmbos.perf.libperfstatbos.perf.perfstatbos.perf.proctoolsxlC.aix61.rte:9.0.0.1xlC.rte:9.0.0.1通过lslpp -l bos.adt.base 查看软件包是否已安装# lslpp -l bos.adt.baseFileset Level State Description---------------------------------------------------------------------------- Path: /usr/lib/objreposbos.adt.base 6.1.3.0 COMMITTED Base Application Development Toolkit需要的补丁:由于此次项目的系统是最新的AIX6.1，无法在网上确切查询到所需要的正确补丁，所以在安装过程中遇到很多问题，最终安装了p6613550_10203_AIX64-5L、p8705958_10204_AIX5L(CRS PSU补丁,解决升级后VIP起不来BUG)3.通过命令“# chfs -a size=30G /”调整文件系统，结果如下：# df -gFilesystem GB blocks Free %Used Iused %Iused Mounted on/dev/hd4 30.00 29.79 1% 13717 1% //dev/hd2 10.00 8.03 20% 45904 3% /usr/dev/hd9var 10.00 9.76 3% 7296 1% /var/dev/hd3 8.00 7.67 5% 608 1% /tmp/dev/fwdump 5.00 5.00 1% 4 1% /var/adm/ras/platform /dev/hd1 30.00 11.28 63% 53931 2% /home/dev/hd11admin 2.00 2.00 1% 5 1% /admin/proc - - - - - /proc/dev/hd10opt 10.00 9.54 5% 9610 1% /opt/dev/livedump 5.00 5.00 1% 4 1% /var/adm/ras/livedump /dev/lv00 0.25 0.24 4% 18 1% /var/adm/csd/dev/fslv00 0.25 0.25 1% 8 1% /audit4.在2个节点上分别建立oinstall、dba、hagsuser组，Oracle用户，并保持组ID和用户ID相同# smitty group# smitty user：Primary GROUP 为“oinstall”，Group SET 为“dba”和“hagsuser”改为“-1”（无限制）5.编辑/etc/hosts文件，添加以下内容：172.16.28.31 racdb1192.168.100.1 racdb1-priv172.16.28.33 racdb1-vip172.16.28.32 racdb2192.168.100.2 racdb2-priv172.16.28.34 racdb2-vip6.配置系统参数，配置每用户的最大进程数，调整water mark# smitty chgsys7.存储划分asm 400G hdisk4vote 2G hdisk5ocr 2G hdisk6arch 200G hdisk7# lspvhdisk0 00cbc154bde9ce42 rootvg active hdisk1 00cbc1a4cb987b44 rootvg active hdisk2 none Nonehdisk3 none Nonehdisk4 none Nonehdisk5 none Nonehdisk6 none Nonehdisk7 none None# cd /dev# chown root:oinstall hdisk6# chown oracle:oinstall hdisk4 hdisk5# chmod 664 hdisk4 hdisk5 hdisk6# chown root:oinstall rhdisk6# chown oracle:oinstall rhdisk4 rhdisk5# chmod 664 rhdisk4 rhdisk5 rhdisk68.配置.rhosts文件，用于节点间的通信认证和加密# cd /home/oracle# mkdir .rhosts# vi .rhostsracdb1 oracleracdb2 oracleracdb1-priv oracleracdb2-priv oracleracdb1-vip oracleracdb2-vip oracle9.配置NTP服务，用于2个节点的时间同步用date命令调整时间至1000秒以内，如果2个节点时间相差多于1000秒，NTP服务会失败如date 0508013030 表示 5月8日1点30分30秒racdb1# vi /etc/ntp.confbroadcastclientserver 127.127.1.0 (添加)driftfile /etc/ntp.drifttracefile /etc/ntp.trace# startsrc -s xntpdracdb2# vi/etc/ntp.confbroadcastclientserver 172.16.28.31 (添加)driftfile /etc/ntp.drifttracefile /etc/ntp.trace# startsrc -s xntpd10.配置环境变量# cd /home/oracle# vi .profileORACLE_BASE=/home/oracleexport ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/10.2.0.1/racdbexport ORACLE_HOMEORACLE_CRS_HOME=$ORACLE_BASE/product/10.2.0.1/crsexport ORACLE_CRS_HOMEORACLE_SID=rac1export ORACLE_SIDORACLE_TERM=xtermexport ORACLE_TERMNLS_LANG=AMERICAN_AMERICA.ZHS16GBKexport NLS_LANGLD_LIBRARY_PATH=$ORACLE_CRS_HOME/lib:$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/l ibexport LD_LIBRARY_PATHPATH=$PATH:$ORACLE_HOME/bin:$ORACLE_CRS_HOME/bin:/usr/bin:/etc:/usr/sbin:/usr/uc b:$HOME/bin:/usr/bin/X11:/sbin:.export PATH11.打补丁p6718715_10203_AIX64-5L.zip，然后以root用户执行补丁6718715里面的rootpre.sh文件；再用oracle用户执行CRS安装程序./runInstaller点击Next点击Next选择CRS安装的目录/home/oracle/product/10.2.0.1/crs，点击Nextoracle进行系统参数检查无问题，点击Next添加Cluster中两个节点及相关的公网、私网、VIP网络名称，点击Next选择ocr文件的位置为/dev/hdisk6，点击Next选择voting disk的位置为/dev/hdisk5，点击Next执行安装至完成。
AIX 7.1 Oracle 11g RAC ASM如何查看rootvg镜像组成# bootlist -o -m normalhdisk0 blv=hd5 pathid=0hdisk0 blv=hd5 pathid=1hdisk1 blv=hd5 pathid=0hdisk1 blv=hd5 pathid=1cd0如何查看cpu核数？# lsdev -Cc processorproc0 Available 00-00 Processorproc4 Available 00-04 Processorproc8 Available 00-08 Processorproc12 Available 00-12 Processorproc16 Available 00-16 Processorproc20 Available 00-20 Processorproc24 Available 00-24 Processorproc28 Available 00-28 Processorproc32 Available 00-32 Processorproc36 Available 00-36 Processorproc40 Available 00-40 Processorproc44 Available 00-44 Processorproc48 Available 00-48 Processorproc52 Available 00-52 Processorproc56 Available 00-56 Processorproc60 Available 00-60 Processor# bindprocessor -qThe available processors are: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63## prtconf|grep ProcessorsNumber Of Processors: 16#如何查看WWN号？# lsdev -Cc adapter -S a | grep fcsfcs0 Available 04-00 8Gb PCI Express Dual Port FC Adapter (df1000f114108a03)fcs1 Available 04-01 8Gb PCI Express Dual Port FC Adapter (df1000f114108a03)fcs2 Available 05-00 8Gb PCI Express Dual Port FC Adapter (df1000f114108a03)fcs3 Available 05-01 8Gb PCI Express Dual Port FC Adapter (df1000f114108a03)# lscfg -vpl fcs0fcs0 U78AA.001.WZSKJYT-P1-C2-T1 8Gb PCI Express Dual Port FC Adapter (df1000f114108a03)Part Number.................00E0806Serial Number...............1A4080061CManufacturer................001AEC Level.................... D77161Customer Card ID Number.....577DFRU Number..................00E0806Device Specific.(ZM) (3)Network Address.............10000090FA67C1CAROS Level and ID............027820B7Device Specific.(Z0) (31004549)Device Specific.(Z1) (00000000)Device Specific.(Z2) (00000000)Device Specific.(Z3) (09030909)Device Specific.(Z4)........FF781150Device Specific.(Z5)........027820B7Device Specific.(Z6)........077320B7Device Specific.(Z7)........0B7C20B7Device Specific.(Z8)........20000120FA67C1CADevice Specific.(Z9)2.02X7Device Specific.(ZA)........U2D2.02X7Device Specific.(ZB)........U3K2.02X7Device Specific.(ZC) (00000000)PLATFORM SPECIFICName: fibre-channelModel: 00E0806Node: fibre-channel@0Device Type: fcp# lscfg -vpl fcs1fcs1 U78AA.001.WZSKJYT-P1-C2-T2 8Gb PCI Express Dual Port FC Adapter (df1000f114108a03)Part Number.................00E0806Serial Number...............1A4080061CManufacturer................001AEC Level.................... D77161Customer Card ID Number.....577DFRU Number..................00E0806Device Specific.(ZM) (3)Network Address.............10000090FA67C1CBROS Level and ID............027820B7Device Specific.(Z0) (31004549)Device Specific.(Z1) (00000000)Device Specific.(Z2) (00000000)Device Specific.(Z3) (09030909)Device Specific.(Z4)........FF781150Device Specific.(Z5)........027820B7Device Specific.(Z6)........077320B7Device Specific.(Z7)........0B7C20B7Device Specific.(Z8)........20000120FA67C1CBDevice Specific.(Z9)2.02X7Device Specific.(ZA)........U2D2.02X7Device Specific.(ZB)........U3K2.02X7Device Specific.(ZC) (00000000)PLATFORM SPECIFICName: fibre-channelModel: 00E0806Node: fibre-channel@0,1Device Type: fcp#查看内存大小：# lsattr -El mem0ent_mem_cap I/O memory entitlement in Kbytes Falsegoodsize 63232 Amount of usable physical memory in Mbytes Falsemem_exp_factor Memory expansion factor Falsesize 63232 Total amount of physical memory in Mbytes Falsevar_mem_weight Variable memory capacity weight False#lsdev -Cc memoryselect GROUP_NUMBER,DISK_NUMBER,TOTAL_MB,FREE_MB,path from V$ASM_DISK;GROUP_NUMBER DISK_NUMBER TOTAL_MB FREE_MB PATH------------ ----------- ---------- ---------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------1 0 112640 108634 /dev/rhdiskpower11 1 153600 148149 /dev/rhdiskpower101 2 163840 158019 /dev/rhdiskpower111 3 174080 167900 /dev/rhdiskpower121 4 184320 177772 /dev/rhdiskpower131 5 194560 187652 /dev/rhdiskpower141 6 204800 197531 /dev/rhdiskpower151 7 225280 217274 /dev/rhdiskpower161 8 235520 227154 /dev/rhdiskpower171 9 143360 138261 /dev/rhdiskpower21 10 215040 207395 /dev/rhdiskpower32 0 5120 4724 /dev/rhdiskpower51 11 102400 98761 /dev/rhdiskpower71 12 122880 118515 /dev/rhdiskpower81 13 133120 128382 /dev/rhdiskpower9选定了17 行powermt display dev=all# powermt display dev=all# powermt display dev=allPseudo name=hdiskpower0VNX ID=FCN00141200036 [IBM POWER740]Logical device ID=600601607BF038007138E28678FEE311 [CRS2]state=alive; policy=CLAROpt; queued-IOs=0Owner: default=SP A, current=SP A Array failover mode: 4============================================================================== --------------- Host --------------- - Stor - -- I/O Path -- -- Stats ---### HW Path I/O Paths Interf. Mode State Q-IOs Errors==============================================================================0 fscsi0 hdisk4 SP A1 active alive 0 01 fscsi2 hdisk28 SP B1 active alive 0 0Pseudo name=hdiskpower1VNX ID=FCN00141200036 [IBM POWER740]Logical device ID=600601607BF03800EA9BE11779FEE311 [DATA2]state=alive; policy=CLAROpt; queued-IOs=0Owner: default=SP A, current=SP A Array failover mode: 4==============================================================================--------------- Host --------------- - Stor - -- I/O Path -- -- Stats ---### HW Path I/O Paths Interf. Mode State Q-IOs Errors==============================================================================0 fscsi0 hdisk5 SP A1 active alive 0 01 fscsi2 hdisk29 SP B1 active alive 0 0Pseudo name=hdiskpower2VNX ID=FCN00141200036 [IBM POWER740]Logical device ID=600601607BF0380008A51F3079FEE311 [DATA5]state=alive; policy=CLAROpt; queued-IOs=0Owner: default=SP A, current=SP A Array failover mode: 4============================================================================== --------------- Host --------------- - Stor - -- I/O Path -- -- Stats ---### HW Path I/O Paths Interf. Mode State Q-IOs Errors==============================================================================0 fscsi0 hdisk6 SP A1 active alive 0 01 fscsi2 hdisk30 SP B1 active alive 0 0Pseudo name=hdiskpower3VNX ID=FCN00141200036 [IBM POWER740]Logical device ID=600601607BF0380080A25E6779FEE311 [DATA12]state=alive; policy=CLAROpt; queued-IOs=0Owner: default=SP A, current=SP A Array failover mode: 4============================================================================== --------------- Host --------------- - Stor - -- I/O Path -- -- Stats ---### HW Path I/O Paths Interf. Mode State Q-IOs Errors==============================================================================0 fscsi0 hdisk7 SP A1 active alive 0 01 fscsi2 hdisk31 SP B1 active alive 0 0Pseudo name=hdiskpower4VNX ID=FCN00141200036 [IBM POWER740]Logical device ID=600601607BF03800FA516CC278FEE311 [ARCH2]state=alive; policy=CLAROpt; queued-IOs=0Owner: default=SP A, current=SP A Array failover mode: 4============================================================================== --------------- Host --------------- - Stor - -- I/O Path -- -- Stats ---### HW Path I/O Paths Interf. Mode State Q-IOs Errors==============================================================================0 fscsi0 hdisk8 SP A1 active alive 0 01 fscsi2 hdisk32 SP B1 active alive 0 0Pseudo name=hdiskpower5VNX ID=FCN00141200036 [IBM POWER740]Logical device ID=600601607BF038007038E28678FEE311 [CRS1]state=alive; policy=CLAROpt; queued-IOs=0Owner: default=SP A, current=SP A Array failover mode: 4============================================================================== --------------- Host --------------- - Stor - -- I/O Path -- -- Stats ---### HW Path I/O Paths Interf. Mode State Q-IOs Errors==============================================================================0 fscsi0 hdisk9 SP A1 active alive 0 01 fscsi2 hdisk33 SP B1 active alive 0 0Pseudo name=hdiskpower6VNX ID=FCN00141200036 [IBM POWER740]Logical device ID=600601607BF038007238E28678FEE311 [CRS3]state=alive; policy=CLAROpt; queued-IOs=0Owner: default=SP A, current=SP A Array failover mode: 4============================================================================== --------------- Host --------------- - Stor - -- I/O Path -- -- Stats ---### HW Path I/O Paths Interf. Mode State Q-IOs Errors==============================================================================0 fscsi0 hdisk10 SP A1 active alive 0 01 fscsi2 hdisk34 SP B1 active alive 0 0Pseudo name=hdiskpower7VNX ID=FCN00141200036 [IBM POWER740]Logical device ID=600601607BF038004A0E320E79FEE311 [DATA1]state=alive; policy=CLAROpt; queued-IOs=0Owner: default=SP A, current=SP A Array failover mode: 4============================================================================== --------------- Host --------------- - Stor - -- I/O Path -- -- Stats ---### HW Path I/O Paths Interf. Mode State Q-IOs Errors==============================================================================0 fscsi0 hdisk11 SP A1 active alive 0 01 fscsi2 hdisk35 SP B1 active alive 0 0Pseudo name=hdiskpower8VNX ID=FCN00141200036 [IBM POWER740]Logical device ID=600601607BF03800A64A6E2079FEE311 [DATA3]state=alive; policy=CLAROpt; queued-IOs=0Owner: default=SP A, current=SP A Array failover mode: 4============================================================================== --------------- Host --------------- - Stor - -- I/O Path -- -- Stats ---### HW Path I/O Paths Interf. Mode State Q-IOs Errors==============================================================================0 fscsi0 hdisk12 SP A1 active alive 0 01 fscsi2 hdisk36 SP B1 active alive 0 0Pseudo name=hdiskpower9VNX ID=FCN00141200036 [IBM POWER740]Logical device ID=600601607BF03800F601412879FEE311 [DA TA4]state=alive; policy=CLAROpt; queued-IOs=0Owner: default=SP A, current=SP A Array failover mode: 4============================================================================== --------------- Host --------------- - Stor - -- I/O Path -- -- Stats ---### HW Path I/O Paths Interf. Mode State Q-IOs Errors==============================================================================0 fscsi0 hdisk13 SP A1 active alive 0 01 fscsi2 hdisk37 SP B1 active alive 0 0Pseudo name=hdiskpower10VNX ID=FCN00141200036 [IBM POWER740]Logical device ID=600601607BF038004C99743979FEE311 [DATA6]state=alive; policy=CLAROpt; queued-IOs=0Owner: default=SP A, current=SP A Array failover mode: 4============================================================================== --------------- Host --------------- - Stor - -- I/O Path -- -- Stats ---### HW Path I/O Paths Interf. Mode State Q-IOs Errors==============================================================================0 fscsi0 hdisk14 SP A1 active alive 0 01 fscsi2 hdisk38 SP B1 active alive 0 0Pseudo name=hdiskpower11VNX ID=FCN00141200036 [IBM POWER740]Logical device ID=600601607BF03800228CE84279FEE311 [DATA7]state=alive; policy=CLAROpt; queued-IOs=0Owner: default=SP A, current=SP A Array failover mode: 4============================================================================== --------------- Host --------------- - Stor - -- I/O Path -- -- Stats ---### HW Path I/O Paths Interf. Mode State Q-IOs Errors==============================================================================0 fscsi0 hdisk15 SP A1 active alive 0 01 fscsi2 hdisk39 SP B1 active alive 0 0Pseudo name=hdiskpower12VNX ID=FCN00141200036 [IBM POWER740]Logical device ID=600601607BF0380024FE984B79FEE311 [DATA8]state=alive; policy=CLAROpt; queued-IOs=0Owner: default=SP A, current=SP A Array failover mode: 4============================================================================== --------------- Host --------------- - Stor - -- I/O Path -- -- Stats ---### HW Path I/O Paths Interf. Mode State Q-IOs Errors==============================================================================0 fscsi0 hdisk16 SP A1 active alive 0 01 fscsi2 hdisk40 SP B1 active alive 0 0Pseudo name=hdiskpower13VNX ID=FCN00141200036 [IBM POWER740]Logical device ID=600601607BF038001A53695379FEE311 [DATA9]state=alive; policy=CLAROpt; queued-IOs=0Owner: default=SP A, current=SP A Array failover mode: 4============================================================================== --------------- Host --------------- - Stor - -- I/O Path -- -- Stats ---### HW Path I/O Paths Interf. Mode State Q-IOs Errors==============================================================================0 fscsi0 hdisk17 SP A1 active alive 0 01 fscsi2 hdisk41 SP B1 active alive 0 0Pseudo name=hdiskpower14VNX ID=FCN00141200036 [IBM POWER740]Logical device ID=600601607BF038003C27765A79FEE311 [DATA10]state=alive; policy=CLAROpt; queued-IOs=0Owner: default=SP A, current=SP A Array failover mode: 4============================================================================== --------------- Host --------------- - Stor - -- I/O Path -- -- Stats ---### HW Path I/O Paths Interf. Mode State Q-IOs Errors==============================================================================0 fscsi0 hdisk18 SP A1 active alive 0 01 fscsi2 hdisk42 SP B1 active alive 0 0Pseudo name=hdiskpower15VNX ID=FCN00141200036 [IBM POWER740]Logical device ID=600601607BF03800F203C96079FEE311 [DATA11]state=alive; policy=CLAROpt; queued-IOs=0Owner: default=SP A, current=SP A Array failover mode: 4============================================================================== --------------- Host --------------- - Stor - -- I/O Path -- -- Stats ---### HW Path I/O Paths Interf. Mode State Q-IOs Errors==============================================================================0 fscsi0 hdisk19 SP A1 active alive 0 01 fscsi2 hdisk43 SP B1 active alive 0 0Pseudo name=hdiskpower16VNX ID=FCN00141200036 [IBM POWER740]Logical device ID=600601607BF0380010784C6E79FEE311 [DATA13]state=alive; policy=CLAROpt; queued-IOs=0Owner: default=SP A, current=SP A Array failover mode: 4============================================================================== --------------- Host --------------- - Stor - -- I/O Path -- -- Stats ---### HW Path I/O Paths Interf. Mode State Q-IOs Errors==============================================================================0 fscsi0 hdisk20 SP A1 active alive 0 01 fscsi2 hdisk44 SP B1 active alive 0 0Pseudo name=hdiskpower17VNX ID=FCN00141200036 [IBM POWER740]Logical device ID=600601607BF038006A15A77679FEE311 [DATA14]state=alive; policy=CLAROpt; queued-IOs=0Owner: default=SP A, current=SP A Array failover mode: 4============================================================================== --------------- Host --------------- - Stor - -- I/O Path -- -- Stats ---### HW Path I/O Paths Interf. Mode State Q-IOs Errors==============================================================================0 fscsi0 hdisk21 SP A1 active alive 0 01 fscsi2 hdisk45 SP B1 active alive 0 0Pseudo name=hdiskpower19VNX ID=FCN00141200036 [IBM POWER740]Logical device ID=6006016090B03800484C45D6C5FEE311 [ARCH1]state=alive; policy=CLAROpt; queued-IOs=0Owner: default=SP A, current=SP A Array failover mode: 4============================================================================== --------------- Host --------------- - Stor - -- I/O Path -- -- Stats ---### HW Path I/O Paths Interf. Mode State Q-IOs Errors==============================================================================0 fscsi0 hdisk3 SP A1 active alive 0 01 fscsi2 hdisk27 SP B1 active alive 0 0Pseudo name=hdiskpower20VNX ID=FCN00141200036 [IBM POWER740]Logical device ID=6006016090B0380076D3B562F300E411 [Backup1]state=alive; policy=CLAROpt; queued-IOs=0Owner: default=SP A, current=SP A Array failover mode: 4============================================================================== --------------- Host --------------- - Stor - -- I/O Path -- -- Stats ---### HW Path I/O Paths Interf. Mode State Q-IOs Errors==============================================================================0 fscsi0 hdisk46 SP A1 active alive 0 01 fscsi2 hdisk48 SP B1 active alive 0 0Pseudo name=hdiskpower21VNX ID=FCN00141200036 [IBM POWER740]Logical device ID=6006016090B038002EC8566FF300E411 [Backup2]state=alive; policy=CLAROpt; queued-IOs=0Owner: default=SP A, current=SP A Array failover mode: 4============================================================================== --------------- Host --------------- - Stor - -- I/O Path -- -- Stats ---### HW Path I/O Paths Interf. Mode State Q-IOs Errors==============================================================================0 fscsi0 hdisk47 SP A1 active alive 0 01 fscsi2 hdisk49 SP B1 active alive 0 0#crs1 hdiskpower5crs2 hdiskpower0crs3 hdiskpower6data1 hdiskpower7data2 hdiskpower1data3 hdiskpower8data4 hdiskpower9data5 hdiskpower2data6 hdiskpower10data7 hdiskpower11data8 hdiskpower12data9 hdiskpower13data10 hdiskpower14data11 hdiskpower15data12 hdiskpower3data13 hdiskpower16data14 hdiskpower17arch1 hdiskpower19arch2 hdiskpower4backup1 hdiskpower20backup2 hdiskpower21lsattr -E -l hdiskpower0rmdev -dl hdiskpower19chdev -l hdiskpower0 -a pv=yes chdev -l hdiskpower1 -a pv=yes chdev -l hdiskpower2 -a pv=yes chdev -l hdiskpower3 -a pv=yes chdev -l hdiskpower4 -a pv=yes chdev -l hdiskpower5 -a pv=yes chdev -l hdiskpower6 -a pv=yes chdev -l hdiskpower7 -a pv=yes chdev -l hdiskpower8 -a pv=yes chdev -l hdiskpower9 -a pv=yes chdev -l hdiskpower10 -a pv=yeschdev -l hdiskpower11 -a pv=yeschdev -l hdiskpower12 -a pv=yeschdev -l hdiskpower13 -a pv=yeschdev -l hdiskpower14 -a pv=yeschdev -l hdiskpower15 -a pv=yeschdev -l hdiskpower16 -a pv=yeschdev -l hdiskpower17 -a pv=yeschdev -l hdiskpower19 -a pv=yeschdev -l hdiskpower20 -a pv=yeschdev -l hdiskpower21 -a pv=yeschdev -l hdiskpower19 -a pv=yeschdev -l hdiskpower19 -a pv=clearchdev -l hdiskpower0 -a reserve_policy=no_reserve chdev -l hdiskpower1 -a reserve_policy=no_reserve chdev -l hdiskpower2 -a reserve_policy=no_reserve chdev -l hdiskpower3 -a reserve_policy=no_reserve chdev -l hdiskpower4 -a reserve_policy=no_reserve chdev -l hdiskpower5 -a reserve_policy=no_reserve chdev -l hdiskpower6 -a reserve_policy=no_reserve chdev -l hdiskpower7 -a reserve_policy=no_reserve chdev -l hdiskpower8 -a reserve_policy=no_reserve chdev -l hdiskpower9 -a reserve_policy=no_reserve chdev -l hdiskpower10 -a reserve_policy=no_reserve chdev -l hdiskpower11 -a reserve_policy=no_reserve chdev -l hdiskpower12 -a reserve_policy=no_reserve chdev -l hdiskpower13 -a reserve_policy=no_reserve chdev -l hdiskpower14 -a reserve_policy=no_reserve chdev -l hdiskpower15 -a reserve_policy=no_reserve chdev -l hdiskpower16 -a reserve_policy=no_reserve chdev -l hdiskpower17 -a reserve_policy=no_reserve chdev -l hdiskpower19 -a reserve_policy=no_reserve chdev -l hdiskpower20 -a reserve_policy=no_reserve chdev -l hdiskpower21 -a reserve_policy=no_reservechown grid:asmadmin /dev/rhdiskpower0chown grid:asmadmin /dev/rhdiskpower1chown grid:asmadmin /dev/rhdiskpower2chown grid:asmadmin /dev/rhdiskpower3chown grid:asmadmin /dev/rhdiskpower5chown grid:asmadmin /dev/rhdiskpower6chown grid:asmadmin /dev/rhdiskpower7chown grid:asmadmin /dev/rhdiskpower8chown grid:asmadmin /dev/rhdiskpower9chown grid:asmadmin /dev/rhdiskpower10chown grid:asmadmin /dev/rhdiskpower11chown grid:asmadmin /dev/rhdiskpower12chown grid:asmadmin /dev/rhdiskpower13chown grid:asmadmin /dev/rhdiskpower14chown grid:asmadmin /dev/rhdiskpower15chown grid:asmadmin /dev/rhdiskpower16chown grid:asmadmin /dev/rhdiskpower17chmod 660 /dev/rhdiskpower0chmod 660 /dev/rhdiskpower1chmod 660 /dev/rhdiskpower2chmod 660 /dev/rhdiskpower3chmod 660 /dev/rhdiskpower5chmod 660 /dev/rhdiskpower6chmod 660 /dev/rhdiskpower7chmod 660 /dev/rhdiskpower8chmod 660 /dev/rhdiskpower9chmod 660 /dev/rhdiskpower10chmod 660 /dev/rhdiskpower11chmod 660 /dev/rhdiskpower12chmod 660 /dev/rhdiskpower13chmod 660 /dev/rhdiskpower14chmod 660 /dev/rhdiskpower15chmod 660 /dev/rhdiskpower16chmod 660 /dev/rhdiskpower17chdev -l hdiskpower5 -a reserve_policy=no_reserve/usr/sbin/lsattr -E -l hdiskpower5# /usr/sbin/lsattr -E -l hdiskpower5PR_key_value none Reserve Key. Trueclr_q no Clear Queue (RS/6000) Truelocation Location Truelun_id 0x6000000000000 LUN ID Falselun_reset_spt yes FC Forced Open LUN Truemax_coalesce 0x100000 Maximum coalesce size Truemax_retries 5 Maximum Retries Truemax_transfer 0x100000 Maximum transfer size Truepvid 00f933f9c497fa560000000000000000 Physical volume identifier False pvid_takeover yes Takeover PVIDs from hdisks Trueq_err yes Use QERR bit Trueq_type simple Queue TYPE Falsequeue_depth 32 Queue DEPTH Truereassign_to 120 REASSIGN time out value Truereserve_policy no_reserve Reserve Policy used to reserve device on open. True reset_delay 2 Reset Delay Truerw_timeout 30 READ/WRITE time out Truescsi_id 0x10600 SCSI ID Falsestart_timeout 60 START unit time out Trueww_name 0x500601693ee0648b World Wide Name Falsereserve_policy no_reservelsattr -E -l /dev/rhdiskpower0lsattr -E -l /dev/rhdisk3查看：lsattr -E -l rhdiskpower0|grep reservelsattr -El sys0 -a realmem# lsattr -El sys0 -a realmemrealmem 64749568 Amount of usable physical memory in Kbytes False# lsps -aPage Space Physical V olume V olume Group Size %Used Active Auto Type Chksumhd6 hdisk0 rootvg 65536MB 0 yes yes lv 0### lsvg rootvgVOLUME GROUP: rootvg VG IDENTIFIER: 00f933f900004c0000000146e2225531 VG STA TE: active PP SIZE: 512 megabyte(s)VG PERMISSION: read/write TOTAL PPs: 1116 (571392 megabytes)MAX LVs: 256 FREE PPs: 808 (413696 megabytes)LVs: 13 USED PPs: 308 (157696 megabytes)OPEN LVs: 12 QUORUM: 1 (Disabled)TOTAL PVs: 2 VG DESCRIPTORS: 3STALE PVs: 0 STALE PPs: 0ACTIVE PVs: 2 AUTO ON: yesMAX PPs per VG: 32512MAX PPs per PV: 1016 MAX PVs: 32LTG size (Dynamic): 1024 kilobyte(s) AUTO SYNC: noHOT SPARE: no BB POLICY: relocatablePV RESTRICTION: none INFINITE RETRY: noDISK BLOCK SIZE: 512# lsvg -l rootvgrootvg:LV NAME TYPE LPs PPs PVs LV STA TE MOUNT POINThd5 boot 1 2 2 closed/syncd N/Ahd6 paging 128 256 2 open/syncd N/Ahd8 jfs2log 1 2 2 open/syncd N/Ahd4 jfs2 2 4 2 open/syncd /hd2 jfs2 6 12 2 open/syncd /usrhd9var jfs2 1 2 2 open/syncd /varhd3 jfs2 4 8 2 open/syncd /tmphd1 jfs2 1 2 2 open/syncd /homehd10opt jfs2 1 2 2 open/syncd /opthd11admin jfs2 1 2 2 open/syncd /adminfwdump jfs2 3 6 2 open/syncd /var/adm/ras/platform lg_dumplv sysdump 8 8 1 open/syncd N/Alivedump jfs2 1 2 2 open/syncd /var/adm/ras/livedump #chps -s 32 hdisk0chfs -a size=30G /tmpchfs -a size=10G /homechfs -a size=5G /chfs -a size=+10G /u01mklv -t jfs2 -y u01lv rootvg 200crfs -v jfs2 -d /dev/u01lv -m /u01mount /u01lsattr -El /dev/hdiskpower0lsattr -El /dev/rhdiskpower0ioo -o aio_maxreqsvmo -p -o minperm%=3vmo -p -o maxperm%=90vmo -p -o maxclient%=90vmo -p -o lru_file_repage=0vmo -p -o strict_maxclient=1vmo -p -o strict_maxperm=0lru_file_repagevmo -p -o lru_file_repage=0vi + /etc/security/limitsfsize = -1core = 2097151cpu = -1data = -1rss = -1stack = -1nofiles = -1no -r -o ipqmaxlen=521no -p -o rfc1323=1no -p -o sb_max=1500000no -p -o tcp_recvspace=65536no -p -o tcp_sendspace=65536no -p -o udp_recvspace=1351680no -p -o udp_sendspace=13516/usr/sbin/no -r -o ipqmaxlen=512/usr/sbin/no -po rfc1323=1/usr/sbin/no -po sb_max=131072/usr/sbin/no -po tcp_recvspace=65536/usr/sbin/no -po tcp_sendspace=65536/usr/sbin/no -po udp_recvspace=65530/usr/sbin/no -po udp_sendspace=65536#public ip192.168.100.103 sqwsjdb01192.168.100.104 sqwsjdb02#Private ip10.10.10.1 sqwsjdb01-priv10.10.10.2 sqwsjdb02-priv#Virtual ip192.168.100.101 sqwsjdb01-vip192.168.100.102 sqwsjdb02-vip#Scan ip192.168.100.100 rac-scanlsdev -Cc adapter查看ssh服务状态# lssrc -s sshdSubsystem Group PID Statussshd ssh 3866742 active停止和启动ssh 服务# stopsrc -s sshd# startsrc -s sshd建议通过console连接，不然停止ssh后网络连接就断开连不上了。
Oracle Database 12c RAC for AIX 7.1一、安装说明服务器：IBM Power 750（两台）共享存储：华为DS6800OS：AIX 7.1.3ORACLE：12.1.0.1.0网络（hosts文件解析）：二、环境检查查看内存：# lsattr-E -l sys0 -a realmem系统架构：# getconf HARDWARE_BITMODE（或# bootinfo -K或# getconf KERNAL_BITMODE//输出64才可以查看Swap空间：# lsps -a，使用chps -s增加目录大小：# df -g（默认的不太大，最好扩展一下smitty chfs）检查软件包：# lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstatbos.perf.perfstat bos.perf.proctools rsct.basic.rte pat.clients.rte xlC.aix61.rte.11.1.0.4 xlC.rte.11.1.0.4（最后两个有版本要求）相关补丁：# instfix -i -k "IV16737IV21116 IV21235 IV28925 IV34869 IV35057 IV39136 IV41415 IV45072 IV45073"由于系统版本7.1.3，安装系统时已包括相关补丁集，安装过程中会有相关WARNING，忽略即可安装12c必须的其它软件包：ssh——建立信任关系、安装过程scp都需要的sshbash——如没有此包，安装GRID时会报INS-06001 Failed toperform operation due to internal driver errorunzip——AIX默认不支持.zip解压1.安装ssh相关包，一般系统盘中就有，smitty installp或mkdir dvdmount -v cdrfs -o ro /dev/cd0 /mnt/dvdcd /mnt/dvd/usr/sys/inst.immagesinstallp -ac -Y -d . openssh.base openssl.base openssl.man.en_US openssh..man.en_US①在/etc/security/login.cfg文件中，将usw下auth_type的默认值std_auth改为pam_auth②/etc/pam.conf中添加sshd auth required pam_aixsshd account required pam_aixsshd password required pam_aixsshd session required pam_aix③将/etc/ssh/sshd_config中#LoginGraceTime 2m改为 LoginGraceTime 0④重启sshstopsrc -s sshdstartsrc-s sshd2.bash需要网上下载（ftp:///gnu/bash/ 据说版本没有限制）后，上传到服务器，使用root用户执行：# rpm -ivh bash-4.2-1.aix6.ppc.rpm在/etc/security/login.cfg的usw:下添加/usr/bin/bash（此操作不知道是不是有效）3. 同样下载unzip_aix.Z文件，上传到服务器，解压uncompress unzip_aix（这里使用刻盘上传时会把.Z改为.z，解压前要改回来，否则报错）chmod 751 unzip将文件cp到/usr/bin# cp -v /u01/unzip_aix /usr/bin/unzip三、系统参数查看异步io：# ioo-a |grep aio_maxreqs（此版本为131070，不用修改）虚拟内存参数：# vmo –aF 与下面值不一致时，修改为下面值（调整后重启生效）：vmo -p -o minperm%=3vmo -p -o maxperm%=90vmo -p -omaxclient%=90vmo -p -olru_file_repage=0vmo -p -ostrict_maxclient=1vmo -p -o strict_maxperm=0系统分配的块大小（建议值128-1024）：chdev-l sys0 -a ncargs=1024用户允许的最大进程数：chdev–l sys0 –a maxuproc=16384网络参数：no -a | more查看兼容性：lsattr –E –l sys0 –a pre520tune1.如返回结果是pre520tuneenable Pre-520 tuning compatibity mode True，在/etc/添加如下：if [ -f /usr/sbin/no ] ; then/usr/sbin/no -o udp_sendspace=65536/usr/sbin/no -o udp_recvspace=655360/usr/sbin/no -o tcp_sendspace=65536/usr/sbin/no -o tcp_recvspace=65536/usr/sbin/no -o rfc1323=1/usr/sbin/no -o sb_max=4194304/usr/sbin/no -o ipqmaxlen=512fi2.如返回结果是pre520tunedisable Pre-520 tuning compatibity mode True，执行下面命令no -r -o ipqmaxlen=512 //此参数要求重启系统生效no -p -o rfc1323=1no -p -o sb_max=4194304no -p -o tcp_recvspace=65536no -p -o tcp_sendspace=65536no -p -o udp_recvspace=655360no -p -o udp_sendspace=65536其它网络参数：no -p -o tcp_ephemeral_low=9000-o tcp_ephemeral_high=65535no -p -o udp_ephemeral_low=9000-o udp_ephemeral_high=65535关闭NTPmv -v /etc/ntp.conf /etc/ntp.conf.bakstopsrc -s xntpd修改用户限制，将/etc/security/limits文件中部分内容如下：default:fsize = -1core = -1cpu = -1data = -1rss = -1stack = -1nofiles = -1四、添加IP解析、创建用户等信息在/etc/hosts添加解析地址（使用hosts解析IP）192.168.10.1 nc180p001192.168.10.2 nc180p002192.168.10.3 nc180p001-vip192.168.10.4 nc180p002-vip10.10.10.1 nc180p001-pri10.10.10.2 nc180p002-pri192.168.10.5 racscan创建组mkgroup -'A' id='1000' adms='root' oinstallmkgroup -'A' id=' 1001' adms='root' dbamkgroup -'A' id='1002' adms='root' opermkgroup -'A' id='1003' adms='root' asmadminmkgroup -'A' id='1004' adms='root' asmopermkgroup -'A' id='1005' adms='root' asmdba创建用户mkuser id='1000' pgrp='oinstall'groups='dba,asmdba,oper,asmadmin,asmdba’home='/home/grid' –s /usr/bin/bash gridmkuser id='1001' pgrp='oinstall'groups='dba,oper,asmadmin,asmdba,asmoper' home='/home/oracle' –s /usr/bin/bash oracle修改密码echo oracle | passwd --stdin oracleecho oracle | passwd --stdin grid添加用户能力lsuser -a capabilities gridchusercapabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE grid lsuser -a capabilities oraclechusercapabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE oracle信任关系（可选）1.生成密钥对（两个节点，两个用户oracle,grid）ssh-keygen -t rsassh-keygen -t dsa2.配置信任关系（一个节点）cat .ssh/id_rsa.pub>>.ssh/authorized_keyscat .ssh/id_dsa.pub>>.ssh/authorized_keysssh nc180p002 cat .ssh/id_rsa.pub>>.ssh/authorized_keysssh nc180p002 cat .ssh/id_dsa.pub>>.ssh/authorized_keysscp .ssh/authorized_keysnc180p002:~/.ssh3.验证信任关系（两个节点，两个用户）ssh nc180p002 datessh nc180p002-pri datessh nc180p001 datessh nc180p001-pri date创建目录设置权限mkdir -p /u01/app/11.2.0/gridmkdir -p /u01/app/oraclechown -R grid:oinstall /u01chown oracle:oinstall /u01/app/oraclechmod -R 775 /u01/共享存储生成PV：chdev -l hdiskn -a pv=yes设置共享文件系统的权限供grid和oracle用户使用1.改变用于数据库存储的PV的属主chown grid:asmadmin /dev/rhdisk[2-12]2.改变用于数据库存储的PV的权限chmod 660 /dev/rhdisk[2-12]3.检测和设置保持策略lsattr -E -l hdisk[2-12] | grep reserve_设置保持策略:chdev -l hdisk[2-12] -areserve_policy=no_reserve (如果是reserve_policy)chdev -l hdisk[2-12] -areserve_lock=no (如果是reserve_lock)添加环境变量节点1上Oracle用户，在~/.bash_profile文件umask 022export EDITOR=viexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export ORACLE_SID=ora11g1exportPATH=.:${PATH}:$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin exportLD_LIBRARY_PATH=$ORACLE_HOME/lib:${LD_LIBRARY_PATH}export NLS_LANG=AMERICAN_AMERICA.UTF8 #此变量最好安装完再加上节点2上Oracle用户，在~/. bash_profile文件添加：umask 022export EDITOR=viexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export ORACLE_SID=ora11g2export PATH=.:${PATH}:$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin exportLD_LIBRARY_PATH=$ORACLE_HOME/lib:${LD_LIBRARY_PATH}export NLS_LANG=AMERICAN_AMERICA.UTF8#此变量最好安装完再加上节点1上Grid用户，在~/. bash_profile文件添加：umask 022export EDITOR=viexport ORACLE_BASE=/u01/app/gridexport GRID_HOME=/u01/app/11.2.0/gridexport ORACLE_SID=+ASM1exportPATH=.:${PATH}:$ORACLE_HOME/bin:/usr/bin:/bin::/usr/local/binexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:${LD_LIBRARY_PATH}节点2上Grid用户，在~/. bash_profile文件添加umask 022export EDITOR=viexport ORACLE_BASE=/u01/app/gridexport GRID_HOME=/u01/app/11.2.0/gridexport ORACLE_SID=+ASM2export PATH=.:${PATH}:$ORACLE_HOME/bin:/usr/bin:/bin:/usr/local/binexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:${LD_LIBRARY_PATH}五、安装GI1.解压grid两个安装包cd /u01unzip aix.ppc64_12c_grid_1of2.zipunzip aix.ppc64_12c_grid_2of2.zip2.解压目录属主改为grid用户cd /u01chmod -R grid:oinstsall grid/3.进入解压目录执行使用root用户rootpre.sh，将此文件传到第二个节点同样使用root 执行cd /u01/grid./rootpre.sh4.grid用户进入解压目录验证su - gridcd /u01/grid./runcluvfy.shstage -pre crsinst -n nc180p001,nc180p002 -fixup -verbose5.开始安装：$ ./runInstaller输入Y，回车继续进入图形界面。
AIX安装规范(AIX 5L、AIX 6L)2014.051AIX系统安装设置 (3)1.1准备工作 (3)1.2BOS安装 (3)1.3AIX操作系统配置 (8)2HACMP安装设置 (20)2.1安装HACMP软件 (20)2.2HACMP配置规划（在两个节点上分别部署） (23)2.3HACMP配置（在一个节点上部署） (30)2.4HACMP启停和测试 (41)3HACMP-RAC安装设置 (43)3.1安装HACMP软件 (43)3.2HACMP-RAC配置规划（在两个节点上分别部署） (46)3.3HACMP-RAC配置（在一个节点上部署） (52)4部署ORACLE所需AIX的参数设置 (61)4.1ORACLE10G RAC (61)4.2ORACLE11G RAC (77)1 AIX 系统安装设置1.1 准备工作为了保证操作系统安装工作的正常进行，在安装之前需要做以下准备工作： 1. 检查随系统部件附带的文档、软件是否齐全。
2. 确保硬件、包括所有的外接设备的安装都已完成，如：图形终端、键盘、鼠标、光驱、硬盘、磁带机等硬件设备。
3. 检测所有硬件的电源是否符合要求(包括图形终端、主机)，并连接正确。
在做完安装前必要的准备工作之后，正式开始安装操作系统，首先通过操作系统安装光盘启动系统。
1.2 BOS 安装1.2.1 设置CDROM 启动通过光盘进行操作系统的安装，首先需要设置系统从CDROM 启动，可通过SMS （System Management Services ）实现，步骤如下：1. 给主机系统加电，等主机面板的LED 显示，就可以按下机器上的白色按钮，启动机器。
2. 将AIX 5L 安装光盘的CD1或AIX 6L3. 当LED 字符后四位显示“E1F1”时，按F1’键，进入“System Management Services ”功能菜单。
1.2.2 安装BOS在开始正式安装操作系统之前，需要对控制台、安装方式、安装时的语言环境等参数进行设置，其具体步骤如下：3.安装BOS需要根据不同的需求来选择不同的安装方式、安装硬盘、语言环境、软件以及是否使用64bit的内核、是否使用jfs2文件系统等，选择“2”，来完成进一选择“1”，进入修改安装硬盘页面Change Method of InstallationType the number of the installation method and press Enter.>>> 1 New and Complete OverwriteOverwrites EVERYTHING on the disk selected for installation.Warning: Only use this method if the disk is totally empty or if thereis nothing on the disk you want to preserve.2 Preservation InstallPreserves SOME of the existing data on the disk selected forInstallation. Warning: This method overwrites the usr (/usr),Variable (/var), temporary (/tmp), and root (/) file systems, Otherproduct (applications) files and configuration data will be destroyed.88 Help ?99 Previous Menu>>> Choice [2]:1此页面为选择系统安装到哪一块或几块硬盘上，输入“1”选择hdisk0，此时在hdisk0前会出现“>>>”表示系统将安装至该硬盘。
root用户的安装演示5（1）建立安装点（Create Mount Points） 5（2）为DBA建立UNIX组（Create UNIX Groups for Database Administrators） 6（3）为ORACLE软件安装者建立UNIX账号（Create UNIX Account to Own Oracle Software） 6（4）建立本地bin目录（Create a Local bin Directory）7（5）建立oratab文件（Create the oratab File）7oracle用户的安装演示7（1）设置文件建立许可（Set Permissions for File Creation）8（2）设置环境变量（Set Environment Variables）8（3）更新当前任务的环境变量（Update the Environment for Current Session）11安装单独的ORACLE产品11Server，Cartridges and Options 11ORACLE PARALLEL SERVER版本的选项-预安装步骤。
11root用户安装步骤12安装13启动安装程序13Mount产品安装用的光盘13运行安装程序14安装提示15安装行动选择15软件资源管理17数据库建立提示17Database Creation Prompts 18Installing Documentation 21How to Install Documentation 21Verifying the Installer Session 22ORACLE_TERM=vt100;export ORACLE_TERM 23UNIX环境1。
安装点（Mount Points）至少4个安装点（mount points），所有安装点都在相同的级别目录结构上，一个安装点用于安装软件，三个用于OFA兼容的数据库2。
