CRS-0215: Could not start resource 'ora..vip' during vipca in RAC 10g

-
VIPCA is fail during RAC 10g. 


crs_stat -t output shows VIP is offline and starting it explicitly 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.



Cause

By default, the server's default gateway is used as a ping target during the Oracle RAC 10g VIP status check action.
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 considerCRS-0215: Could not start resource 'ora.dbtest2.vip'.



Solution

10.1.0.4 and above introduced a parameter FAIL_WHEN_DEFAULTGW_NOT_FOUND in the $ORA_CRS_HOME/bin/racvip to address this problem.
The following steps will fix the VIP starting problem for above mentioned scenario.
- stop nodeapps
- As root, vi the script $ORA_CRS_HOME/bin/racgvip and change the value of variable FAIL_WHEN_DEFAULTGW_NOT_FOUND=0 .
- start nodeapps and you should see the resources ONLINE
You may proceed with netca and dbca to create a RAC database after this.



Please see Oracle Note:356535.1

Comments

  1. Unknown28 June 2012 at 07:13

    Thanks you so much......

    ReplyDelete
  2. prasad22 August 2012 at 12:55

    working....

    ReplyDelete
  3. Unknown17 October 2012 at 00:33

    hello
    After installed the crs_home if i fire the ./crs-stat -t means its showing linux1-vip and linux2-vip offline how to make online........... i badly need any one of advice here

    ReplyDelete
  4. Unknown24 December 2013 at 12:14

    sir,this reallyy awesomee
    thank u very much

    ReplyDelete
  5. Unknown24 December 2013 at 12:14

    keep posting

    ReplyDelete
  6. Ask Oracle DBA24 May 2018 at 12:07

    Thanks to all. I couldn't responded yours queries, Sorry for that one..

    ReplyDelete

Post a Comment

Popular posts from this blog

How to perform out-of place manual upgrade from 11.2.0.1 to 11.2.0.2

-
Solution : 11.2.0.2 patch set software is a full release. 11.2.0.2 OUI does not update existing 11.2.0.1 ORACLE_HOME files and performs a new installation. There are two method Out-of-Place (Oracle's recommended approach) In-Place But here, we need to understand what exactly this method is: In prior releases, how it worked   DB Upgrade 8i to 10g (Out-Of-Place) We install Oracle binaries for 10g at new location, then use DBUA or catupgrd.sql script to upgrade DB. This is Out-of-Place migration (i.e. created new oracle home, from inventory perspective). DB Upgrade 10.2.0.1 to 10.2.0.4 (In-Place) Here we won’t install 10.2.0.4 patchset in new home ( Oracle won’t let us do that, as it is a patch ), but select the existing home to upgrade. We also keep a backup of original 10.2.0.1, as we may have to fail back. As 11.2.0.2 is not a patch and full install .  It does not allow us to install binaries in existing 11.2.0.1 home (i.e. In-Place). But as I mentioned above, we can perform
Read more

CRS daemon not up after reboot node1 on two nodes RAC

-
Please check log crsctl.* in /tmp dir, Will see like below error. $ cat crsctl.2717 Failure -2 opening file handle for (c6t0d1)  --------->> Voting disk not access from node1 Failure 1 checking the CSS voting device. --------->> Voting disk not access from node1 ocssd1.log on node1- more  /u01/crs/oracle/product/10.1.0/crs/css/log/ocssd1.log 2008-09-09 12:06:43.683 [5] >TRACE:   clssgmClientConnectMsg: Connect from con(600000000080fca0), proc(6000000000b497b0)  pid() 2008-09-09 12:08:32.836 [5] >TRACE:   clssgmClientConnectMsg: Connect from con(6000000000810120), proc(6000000000b168e0)  pid() 2008-09-09 12:08:32.848 [5] >TRACE:   clsc_receive: (6000000000b3f590) Connection failed, transport error (507, 0, 0) 2008-09-09 12:08:32.848 [5] >TRACE:   clscreceive: (6000000000810120) Physical connection (6000000000b3f590) not active, rc 11 2008-09-09 12:08:32.848 [5] >TRACE:   clscreceive: (60000000008105a0) Physical connection (6000000000b3f590) not ac
Read more