This discussion is archived
7 Replies Latest reply: Oct 23, 2013 1:28 AM by JohnWatson RSS

RAC

Rajasekaran_DBA Newbie
Currently Being Moderated

Hi Gurus,

I need help for the below issue. i  installed Rac 10g . After few day i tried starting the server, previously  while starting the server itself all the nodeapps and database come up as it has an entry in the  cd /etc/inittab

 

# Run xdm in runlevel 5

x:5:respawn:/etc/X11/prefdm -nodaemon

h1:35:respawn:/etc/init.d/init.evmd run >/dev/null 2>&1 </dev/null

h2:35:respawn:/etc/init.d/init.cssd fatal >/dev/null 2>&1 </dev/null

h3:35:respawn:/etc/init.d/init.crsd run >/dev/null 2>&1 </dev/null

 

 

But now if i check the ./crs_stat -t -v it show the nodeapps ons and gsd as online and vip as offline . please help me to resolve the problem .

 

 

[oracle@RAC1 bin]$ ./crs_stat -t -v

Name           Type           R/RA   F/FT   Target    State     Host

----------------------------------------------------------------------

ora....C1.inst application    0/5    0/0    ONLINE    OFFLINE

ora....C2.inst application    0/5    0/0    ONLINE    OFFLINE

ora.RAC.db     application    0/1    0/1    ONLINE    OFFLINE

ora....SM1.asm application    0/5    0/0    ONLINE    OFFLINE

ora....C1.lsnr application    0/5    0/0    ONLINE    OFFLINE

ora.rac1.gsd   application    0/5    0/0    ONLINE    ONLINE    rac1

ora.rac1.ons   application    0/3    0/0    ONLINE    ONLINE    rac1

ora.rac1.vip   application    0/0    0/0    ONLINE    OFFLINE

ora....SM2.asm application    0/5    0/0    ONLINE    OFFLINE

ora....C2.lsnr application    0/5    0/0    ONLINE    OFFLINE

ora.rac2.gsd   application    0/5    0/0    ONLINE    ONLINE    rac2

ora.rac2.ons   application    0/3    0/0    ONLINE    ONLINE    rac2

ora.rac2.vip   application    0/0    0/0    ONLINE    OFFLINE

[oracle@RAC1 bin]$  ./srvctl start nodeapps -n rac1

rac1:ora.rac1.vip:checkIf: Default gateway is not defined (host=RAC1.sai.com)

rac1:ora.rac1.vip:Interface eth0 checked failed (host=RAC1.sai.com)

rac1:ora.rac1.vip:Invalid parameters, or failed to bring up VIP (host=RAC1.sai.com)

rac1:ora.rac1.vip:checkIf: Default gateway is not defined (host=RAC1.sai.com)

rac1:ora.rac1.vip:Interface eth0 checked failed (host=RAC1.sai.com)

rac1:ora.rac1.vip:Invalid parameters, or failed to bring up VIP (host=RAC1.sai.com)

CRS-1006: No more members to consider

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

rac1:ora.rac1.vip:checkIf: Default gateway is not defined (host=RAC1.sai.com)

rac1:ora.rac1.vip:Interface eth0 checked failed (host=RAC1.sai.com)

rac1:ora.rac1.vip:Invalid parameters, or failed to bring up VIP (host=RAC1.sai.com)

rac1:ora.rac1.vip:checkIf: Default gateway is not defined (host=RAC1.sai.com)

rac1:ora.rac1.vip:Interface eth0 checked failed (host=RAC1.sai.com)

rac1:ora.rac1.vip:Invalid parameters, or failed to bring up VIP (host=RAC1.sai.com)

CRS-0215: Could not start resource 'ora.rac1.LISTENER_RAC1.lsnr'.

 

 

regards,

Raja

  • 1. Re: RAC
    gottikere Explorer
    Currently Being Moderated

    Hi ,

     

    can you give the output of below command:

     

    #./crsctl stat res -t -init

    #./crs_stat -t|grep OFFLINE

     

    Thanks,

    http://gssdba.wordpress.com

  • 2. Re: RAC
    Rajasekaran_DBA Newbie
    Currently Being Moderated

    Hi Gotikere,

     

    Thanks for your reply

    Sorry i tried the below steps to remove and add the nodeapps but the vips is not getting removed

     

    node1 : rac1

    [root@RAC1 bin]# ./srvctl remove  nodeapps -n rac1

    Please confirm that you intend to remove the node-level applications on node rac1 (y/[n]) y

    PRKO-2112 : Some or all node applications are not removed successfully on node: rac1

     

    [root@RAC2 bin]# ./crsctl stat res -t -init

    Unknown parameter: stat

     

     

    #./crs_stat -t|grep OFFLINE

     

    [root@RAC1 bin]# ./crs_stat -t|grep OFFLINE

    ora....C1.inst application    ONLINE    OFFLINE

    ora....C2.inst application    ONLINE    OFFLINE

    ora.RAC.db     application    ONLINE    OFFLINE

    ora....SM1.asm application    ONLINE    OFFLINE

    ora....C1.lsnr application    ONLINE    OFFLINE

    ora.rac1.vip   application    ONLINE    OFFLINE

    ora....SM2.asm application    ONLINE    OFFLINE

    ora....C2.lsnr application    ONLINE    OFFLINE

    ora.rac2.vip   application    ONLINE    OFFLINE

     

     

    Regards,

    Raja

  • 3. Re: RAC
    gottikere Explorer
    Currently Being Moderated

    Hi,

     

    We have a bug in 10g which will prevent the fail back of VIP in case if the VIP is failed to other node.

     

    If you have oracle 10.2.0.2 or lesser version than you have to apply a bug fix patch. Raise an SR with oracle they will get you the details of the bug.

     

    This issues was fixed in 10.2.0.3 or higher version. I AM NOT 100% SURE WITH FIXED VERSION OF 10g

     

    Thanks,

    http://gssdba.wordpress.com

  • 4. Re: RAC
    Anar Godjaev Expert
    Currently Being Moderated

    Hi,

     

    Please check below link in Oracle support id : Database Service Not Starting With Errors: CRS-1006, CRS-215 (Doc ID 752366.1)

     

    Maybe this can help you.

     

    Thank you

  • 5. Re: RAC
    Rajasekaran_DBA Newbie
    Currently Being Moderated

    Hi  Gottikere/AnarGodjaev

     

    Thanks for your reply

     

    kindly advice me that how to apply this bug fix,i don't have meta link access to create SR

    i have created this rac setup for learning purpose

    I have a patch set p5337014_10203_LINUX.zip is this enough if i apply. please suggest me .

     

    Regards,

    Raja

  • 6. Re: RAC
    gottikere Explorer
    Currently Being Moderated

    Hi ,

     

    Please fallow the readme doc which will be present in .zip file.

     

    Apply the above patch may fix the issue. Give a try.

     

    Thanks,

    http://gssdba.wordpress.com

  • 7. Re: RAC
    JohnWatson Guru
    Currently Being Moderated

    Rajasekaran_DBA wrote:

     

    Hi  Gottikere/AnarGodjaev

     

    Thanks for your reply

     

    kindly advice me that how to apply this bug fix,i don't have meta link access to create SR

    i have created this rac setup for learning purpose

    I have a patch set p5337014_10203_LINUX.zip is this enough if i apply. please suggest me .

     

    Regards,

    Raja

    You say that this is for learning purposes. In that case, the best advice anyone can give is to forget it, and start again with release 12.1.0.1. Release 10.2 is already in sustaining support, and the architecture of clusterware has changed hugely since then. There really is little point in studying the old version.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points