AIX_6.1下RAC安装问题小结.docx

AIX 6.1下RAC安装问题小结AIX 6.1, RAC 分享到： 新浪微博 腾讯微博 QQ空间 QQ好友 更多 0 最近在AIX 6.1上安装了一套RAC，实施得不多，遇到不少问题，记录一下：OS版本：HOST_NAM_1:/#oslevel -s6100-04-02-1007HA版本：HOST_NAM_1:/#lslpp -l cluster.*Fileset LevelState Description-Path:/usr/lib/objreposcluster.adt.es.client.include5.5.0.0COMMITTEDES Client Include Filescluster.adt.es.client.samples.clinfo5.5.0.0COMMITTEDES Client CLINFO Samplescluster.adt.es.client.samples.clstat5.5.0.1COMMITTEDES Client Clstat Samples# RSH 报错#rsh HOST_NAM_2 datershd: 0826-813Permissionisdenied.相关文件配置：#cat .rhostsHOST_NAM_1 rootHOST_NAM_2 rootHOST_NAM_1 oracleHOST_NAM_2 oracle#cat /etc/hosts.equivHOST_NAM_1 rootHOST_NAM_2 rootHOST_NAM_1 oracleHOST_NAM_2 oracle其中HOST_NAM_1、HOST_NAM_2是HOSTNAME。这里主要是/etc/hosts文件中，HOSTNAME不能当作别名，或者，”.rhosts”、”hosts.equiv”里不要配别名，应该是跟解析有关。原HOSTS配置：175.16.1.11 HOST_NAM_1_boot1HOST_NAM_1175.16.1.12 HOST_NAM_2_boot1HOST_NAM_2192.168.10.17 HOST_NAM_1_boot2192.168.10.18 HOST_NAM_2_boot2192.168.10.16 HOST_NAM_2_vip192.168.10.15 HOST_NAM_1_vip改为：175.16.1.11 HOST_NAM_1_boot1175.16.1.12 HOST_NAM_2_boot1192.168.10.17 HOST_NAM_1HOST_NAM_1_boot2192.168.10.18 HOST_NAM_2HOST_NAM_2_boot2192.168.10.16 HOST_NAM_2_vip192.168.10.15 HOST_NAM_1_vip# rootpre.sh报错这个安装前在文档中有到看到，作为注意事项记录一下：The Oracle 10gR2 OUI and configuration assistant programs do not recognize AIX 6 V6.1 as a supported release.执行rootpre.sh时会报：Configuring Asynchronous I/O.Asynchronous I/Oisnotinstalledonthis system.You will needtoinstall it,andeither configure it yourselfusingsmit aioorrerun the Oracle root installation procedure.Configuring POSIX Asynchronous I/O.Posix Asynchronous I/Oisnotinstalledonthis system.You will needtoinstall it,andeither configure it yourselfusingsmit aioorrerun the Oracle root installation procedure.解决方法：下载6718715补丁，执行里面的rootpre.sh参考文档：282036.1# VIPCA 报错VIPCA时，VIP起不来，日志报错信息：Interface en4 checked failed(host=HOST_NAM_1)Invalid parameters,orfailedtobring up VIP(host=HOST_NAM_1)原因：VIP绑定的是小机集成的网卡Logical Host Ethernet Port (lp-hea)The entstat output for LHEA is different from a regular adapter解决方法：修改racgvip脚本，找到$ENTSTAT -d $_IF这行，修改为：$ENTSTAT-d $_IF|$GREP-iEq.*lan.*state.*:.*operational.*|.*link.*status.*:.*up.*|.*port.*operational.*state.*:.*up.*|.*driver.*flags.*:.*up.*参考文档：959746.1# ONS 起不来日志报错信息：Failedtoget IPforlocalhost(0)Failedtoget IPforlocalhost(0)Failedtoget IPforlocalhost(0)onsctl: ons failedtostart解决方法：原hosts文件中找不到localhost：127.0.0.1 loopback改为：127.0.0.1 loopback localhost# CRS 升级10.2.0.4报错升级完成后执行root102.sh，报：# ./root102.shError : Pleasechangethe CRS_ORACLE_USER id oracletohave the following OS capabilities :解决方法：#chuser capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE,CAP_NUMA_ATTACH oracle#lsuser -f oracle | grep capabilitiescapabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE,CAP_NUMA_ATTACH这个报错之前遇到过，升级的文档中，也有提到。# CRS 升级10.2.0.4后，VIP起不来这次的有点难搞，日志中没有太多的信息，只有一行：Invalid parameters,orfailedtobring up VIP(host=HOST_NAM_1)后来使用crsctl对VIP进行debug，收集更多的信息：#crsctl debug log res ora.host_nam_2.vip:5SetResource Debug Module: ora.host_nam_2.vipLevel:5#srvctl start nodeapps -n host_nam_2CRS-0233: Resourceorrelatives are currently involvedwithanother operation.host_nam_2ra.host_nam_2.vip:Thu Mar2513:57:25GMT+08:002010360824Checking interface existancehost_nam_2ra.host_nam_2.vip:Thu Mar2513:57:25GMT+08:002010360824Calling getifbyiphost_nam_2ra.host_nam_2.vip:Thu Mar2513:57:25GMT+08:002010360824getifbyip:startedfor192.168.10.16host_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:26GMT+08:002010360824getifbyip: checkingiffailoverishappening()host_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:26GMT+08:002010360824getifbyip: failoverisnothappening()host_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:26GMT+08:002010360824Completed getifbyiphost_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:26GMT+08:002010360824ping_vip 192.168.10.16 startedhost_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:26GMT+08:002010360824Abouttoexecute :/usr/sbin/ping-c1-w1192.168.10.16host_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:27GMT+08:002010360824ping_vip: 192.168.10.16isnotpingable,_count=1host_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:27GMT+08:002010360824Completedwithinitial interface testhost_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:27GMT+08:002010360824Broadcast=192.168.10.255host_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:27GMT+08:002010360824Interface testshost_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:27GMT+08:002010360824checkIf: startforif=en4host_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:27GMT+08:002010360824IsIfAlive: startforif=en4host_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:27GMT+08:002010360824defaultgw:startedhost_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:27GMT+08:002010360824defaultgw:completedwith192.168.10.254host_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:27GMT+08:002010360824Abouttoexecute command:/usr/sbin/ping-S 192.168.10.18-c1-w1192.168.10.254host_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:28GMT+08:002010360824Abouttoexecute command:/usr/sbin/ping-S 192.168.10.18-c1-w1192.168.10.254host_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:29GMT+08:002010360824IsIfAlive: RX packets checkedif=en4 failedhost_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:29GMT+08:002010360824Interface en4 checked failed(host=HOST_NAM_2)host_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:29GMT+08:002010360824IsIfAlive: endforif=en4host_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:29GMT+08:002010360824checkIf: endforif=en4host_nam_2:ora.host_nam_2.vip:Invalid parameters,orfailedtobring up VIP(host=HOST_NAM_2)host_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:30GMT+08:002010307376Checking interface existancehost_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:30GMT+08:002010307376Calling getifbyiphost_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:30GMT+08:002010307376getifbyip:startedfor192.168.10.16host_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:30GMT+08:002010307376getifbyip: checkingiffailoverishappening()host_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:30GMT+08:002010307376getifbyip: failoverisnothappening()host_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:30GMT+08:002010307376Completed getifbyiphost_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:30GMT+08:002010307376ping_vip 192.168.10.16 startedhost_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:30GMT+08:002010307376Abouttoexecute :/usr/sbin/ping-c1-w1192.168.10.16host_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:31GMT+08:002010307376ping_vip: 192.168.10.16isnotpingable,_count=1host_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:31GMT+08:002010307376Completedwithinitial interface testhost_nam_2:ora.host_nam_2.vip:Thu Mar2513:57:31GMT+08:002010307376Broadcast=192.168.10.255CRS-1006: No more memberstoconsiderCRS-0215: Couldnotstart resourceora.host_nam_2.vip.CRS-0210: Couldnotfind resource ora.host_nam_2.LISTENER_HOST_NAM_2.lsnr.这才搜索到了相关信息：Bug8413088: VIP CANNOT STARTONAIX6.1BECAUSE NETSTAT HAS A NEWCOLUMN.Bug9157855: DURING RESTARTORWHEN ONE OF THE TWO NODE CLUSTERISDOWN,VIP RESOURCE FAILS这个问题，在打完CRS PSU后，也同样有可能存在，可以通过修改racvip脚本来解决：10.2.0.4：_O1=$NETSTAT -n -I $_IF | $AWK if (/$_IF/) print$5; exit_O2=$NETSTAT -n -I $_IF | $AWK if (/$_IF/) print$5; exit打完PSU后：_O1=$NETSTAT -n -I $_IF -p tcp | $GREP -iE .*packets received$ | $AWK print$1; exit_O2=$NETSTAT -n -I $_IF -p tcp | $GREP -iE .*packets received$ | $AWK print$1; exit最终改为：_O1=$NETSTAT -n -I $_IF -p ip | $GREP -iE .*packets received$ | $AWK print$1; exit_O2=$NETSTAT -n -I $_IF -p ip | $GREP -iE .*packets received$ | $AWK print$1; exit这个问题很杯具，花了很多时间，安装前，阅读相关文档时，我就注意到了这个BUG，两次VIP起不来，我都拿去对比，看看是不是这个BUG。结果还是没发现，一直到debug出来。# RDBMS升10204时，报java进程没停Oracle Universal Installer has detected thatthere are processes runninginthecurrently selected Oracle Home.Thefollowing processes needtobe shutdownbefore continuing:java刚开始时，还有CRS的进程，停掉CRS后，还有一个java始终过不去，用fuser查使用$ORACLE_HOME目录进程，全kill，把ps -ef | grep java 出来的进程，除了安装的进程外都杀了，还是不行。最后在Metalink上找到了解决方法，升级前：cd/usr/sbin/mv fuser fuser.origtouch/usr/sbin/fuserchmod+x/usr/sbin/fuser升级完成后，再改回来：cd/usr/sbin/cp fuser.orig fuser这招很阴啊。参考文档：975597.1# 数据库打完PSU补丁后，启CRS报错在CRS、database都升级、打补丁完成后，启CRS、VIP等资源时，报错：HOST_NAM_1:/#crsctl start crsexec(): 0509-036 Cannotloadprogram/app/oracle/product/10204/db_1/bin/crsctl.bin because of the following errors:0509-150Dependent module libhasgen10.a(shr_hasgen10.o)couldnotbe loaded.0509-022 Cannotloadmodule libhasgen10.a(shr_hasgen10.o).0509-026 System error: A fileordirectoryinth