Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

316

积分

0

好友

0

主题
1#
发表于 2012-2-20 16:46:05 | 查看: 7602| 回复: 6
crs_start ora.node01.vip
Attempting to start `ora.node01.vip` on member `node01`
Start of `ora.node01.vip` on member `node01` failed.
Attempting to start `ora.node01.vip` on member `node02`
Start of `ora.node01.vip` on member `node02` failed.
CRS-1006: No more members to consider

CRS-0215: Could not start resource 'ora.node01.vip'.

AIX 6.1   +  RAC 10.2.0.4

安装时还是好好的,重启后VIP就起不来了,原来是10.2.0.4的RACGVIP脚本不支持AIX 6.1 NETSTAT 的新列信息。

[ 本帖最后由 武汉-SSH 于 2012-2-20 20:33 编辑 ]
2#
发表于 2012-2-20 17:08:27
信息少了点吧,可参考[CRS-0215: Could not start resource 'ora..vip' [ID 356535.1]:

SymptomsThe command : crs_stat -t output shows VIP is offline and trying to start it gives error :
CRS-0215: Could not start resource 'ora.dbtest2.vip'.

Example: crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....st2.gsd application ONLINE ONLINE dbtest2
ora....st2.ons application ONLINE ONLINE dbtest2
ora....st2.vip application ONLINE OFFLINE

# ./srvctl start nodeapps -n dbtest2
dbtest2:ora.dbtest2.vip:Interface eri0 checked failed (host=dbtest2)
dbtest2:ora.dbtest2.vip:Failed to start VIP 10.11.11.198 (host=dbtest2)
dbtest2:ora.dbtest2.vip:Interface eri0 checked failed (host=dbtest2)
dbtest2:ora.dbtest2.vip:Failed to start VIP 10.11.11.198 (host=dbtest2)
CRS-1006: No more members to consider
CRS-0215: Could not start resource 'ora.dbtest2.vip'.
CRS-0210: Could not find resource ora.dbtest2.LISTENER_DBTEST2.lsnr.


To know what is the nodeapps configuration in particular for VIP,
issue the command: srvctl config nodeapps -n <nodename> -a -g -s -l
Example:
/u01/crs/bin/srvctl config nodeapps -n dbtest2 -a -g -s -l
VIP exists.: /dbtest2-vip/10.11.11.198/255.255.255.0/eri0
GSD exists.
ONS daemon exists.
Listener does not exist.


Further debug it by uncommenting the environment variable _USR_ORA_DEBUG=1 in the script $ORA_CRS_HOME/bin/racgvip
OR simply as root user, issue the command : crsctl debug log res "ora.dbtest2.vip:5"
You may turn off debugging with command : crsctl debug log res "ora.dbtest2.vip:0"
Start the VIP using srvctl start nodeapps again. This will create a log for VIP starting problem for 10.2 and above version
in directory $ORA_CRS_HOME/log/<nodename>/racg/*vip.log


Changes
  • Either the default gateway has got changed to someother IP -or-
  • It is on a different network from the client (the network where the VIP is configured on) -or-
  • It is not being used anymore.
CauseBy default, the server's default gateway is used as a ping target during the Oracle RAC 10g VIP status check action.
Upon a ping failure, Oracle will decide that the current interface where the VIP is running has failed, and will initiate
an interface / internode VIP failover.

In above case, we used just one node for CRS installation, so the VIP coudn't failover to other nodes and thus reported additional error like :
CRS-1006: No more members to consider
CRS-0215: Could not start resource 'ora.dbtest2.vip'.

Solution10.1.0.4 and above introduced a parameter FAIL_WHEN_DEFAULTGW_NOT_FOUND in the file
$ORA_CRS_HOME/bin/racvip to address this problem.

The following steps will fix the VIP starting problem for above mentioned scenario.

1- stop nodeapps
2- As root,
vi the script $ORA_CRS_HOME/bin/racgvip and change the value of
variable FAIL_WHEN_DEFAULTGW_NOT_FOUND=0 .
3- start nodeapps and you should see the resources ONLINE

You may proceed with netca and dbca to create a RAC database after this.

回复 只看该作者 道具 举报

3#
发表于 2012-2-20 18:51:42
http://www.dbaroad.me/archives/2010/03/aix_61_rac_install.html

[ 本帖最后由 武汉-SSH 于 2012-2-20 19:05 编辑 ]

回复 只看该作者 道具 举报

4#
发表于 2012-2-20 19:16:32
什么版本 什么操作系统都不说 , 什么日志都不发,  这种提问是不负责任的。

回复 只看该作者 道具 举报

5#
发表于 2012-2-20 20:32:09
Sorry,最近脑子比较秀逗。。。。。

这个已经解决了,还是把信息补上吧。

回复 只看该作者 道具 举报

6#
发表于 2012-2-20 20:54:39
ODM data:
  1. VIP Fails to Start on AIX 6.1 [ID 1056896.1]
  2. Applies to:
  3. Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 11.1.0.7   [Release: 10.2 to 11.1]
  4. IBM AIX on POWER Systems (64-bit)
  5. Symptoms

  6. If  Clusterware is shutdown on one RAC node the VIP on the other node/s also goes down after a few minutes. VIP on the running node/s cannot be restarted.

  7. The VIP log shows the following output when the failure occurs:
  8. Tue Nov 24 19:16:33 CET 2009 [ 630804 ] About to execute command:
  9. /usr/sbin/ping -S 10.10.9.205 -c 1 -w 1 192.168.1.1
  10. Tue Nov 24 19:16:34 CET 2009 [ 630804 ] IsIfAlive: RX packets checked if=en1
  11. failed


  12. Changes
  13. New installation of 10.2.0.4+ or 11.1 clusterware on AIX 6.1,
  14. - or -
  15. Upgrading AIX from 5.x to 6.1 with existing clusterware installation,
  16. - or -
  17. Applying AIX fix IZ41358, or a service pack which contains it, with existing clusterware installation.
  18. Cause
  19. The VIP resource does not came up because of IBM fix IZ41358 which changes the printing of ZoneID in netstat.

  20. IZ41358: ZONEID NEEDS TO PRINT "-" RATHER THAN A BLANK FOR NO VALUE. APPLIES
  21. TO AIX 6100-02

  22. After this fix it prints "-", before there was simply a space.

  23. The racgvip script, which starts the VIP, uses awk on netstat output to check if the interface is up. Adding a column means the awk output now returns the wrong field.  This causes the racgvip script to fail to recognize that the interface is up, and therefore it will not start the VIP.
  24. Solution
  25. This issue is fixed by unpublished bug 9157855 and is included in 10.2.0.4.4 CRS PSU, 10.2.0.5,  11.1.0.7.4 CRS PSU and 11.2.0.2

  26. References
  27. BUG:9157855 - DURING RESTART OR WHEN ONE OF THE TWO NODE CLUSTER IS DOWN, VIP RESOURCE FAILS
  28. PATCH:8705958 - TRACKING BUG FOR 10.2.0.4.2 PSU FOR CRS
  29. NOTE:9294403.8 - Bug 9294403 - 10.2.0.4.4 CRS Patch Set Update (CRS PSU)
  30. NOTE:9294495.8 - Bug 9294495 - 11.1.0.7.4 CRS Patch Set Update (CRS PSU)
复制代码

回复 只看该作者 道具 举报

7#
发表于 2012-2-20 20:57:01
这个其实 不是bug ,  主要原因是 10.2.0.4 比 AIX 6.1 要早出, 而racgvip 这个vip资源使用的脚本 要用到netstat 命令的输出, 而在AIX 6.1 中恰恰对netstat 命令做了一些输出格式上的修改, 导致ragvip脚本运行不正常。

建议在AIX 6.1 上 使用10.2.0.5 + 最新的 PSU

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-15 02:05 , Processed in 0.052375 second(s), 22 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569