7 Replies Latest reply: Oct 23, 2013 3:28 AM by JohnWatson RSS

    RAC

    Rajasekaran_DBA

      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

          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

            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

              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

                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

                  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

                    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

                      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.