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

Rebuild Corrupt ASM disk

-
I want to share my experience when I was adding new node3 existing two node RAC node1 and node2 environment. Due to wrong disk mapping on node3, one ASM disk group has got corrupted. We was using external redundancy. Our existing RAC nodes were node1 and node2 during root.sh, adding node3 entry into OCR file, but the OCR disk (/dev/rhdisk5) on node 3 not pointing to the actual OCR disk (/dev/rhdisk5) on node 1&2. It was pointing to one asm disk (/dev/rhdisk3) which was part of ASMDB2 disk group on node1&2. ANALYSIS -------------- Check dd if=/dev/rhdisk5 bs=8192 count=1 |od –x   ------- on node3 it was showing different contents from node 1 and node 2 disk contents. So OCR on node 3 is not pointing to correct OCR disk on node 1&2. Solution: For ASM disk part: I identified all disk path of ASMDB2 disk group this were (/dev/rhdisk3, /dev/rhisk2 and /dev/rhdisk1). (By view v$asm_disk) Note: We should know all disk are using ASMDB2. Care should be taken at...
Read more

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 per...
Read more