3 Replies Latest reply: May 17, 2013 6:57 AM by muba_zak RSS

    11g Rac Cluster Status

    muba_zak
      Daer All,

      we have 2 node 11g Rac with ASM, please see the status, proddb2 ASM & DATABASE running but here it not showing, ora.asm should show STARTED, ora.proddb.db should show OPEN, please let me know how to troubleshoot.


      -bash-3.00$ crsctl stat res -t
      --------------------------------------------------------------------------------
      NAME TARGET STATE SERVER STATE_DETAILS
      --------------------------------------------------------------------------------
      Local Resources
      --------------------------------------------------------------------------------
      ora.DATA.dg
      ONLINE ONLINE proddb1
      ONLINE ONLINE proddb2
      ora.DATAOV.dg
      ONLINE ONLINE proddb1
      ONLINE ONLINE proddb2
      ora.FLASH.dg
      ONLINE ONLINE proddb1
      ONLINE ONLINE proddb2
      ora.LISTENER.lsnr
      ONLINE ONLINE proddb1
      ONLINE ONLINE proddb2
      ora.asm
      ONLINE ONLINE proddb1 Started
      ONLINE ONLINE proddb2
      ora.eons
      ONLINE ONLINE proddb1
      ONLINE ONLINE proddb2
      ora.gsd
      OFFLINE OFFLINE proddb1
      OFFLINE OFFLINE proddb2
      ora.net1.network
      ONLINE ONLINE proddb1
      ONLINE ONLINE proddb2
      ora.ons
      ONLINE ONLINE proddb1
      ONLINE ONLINE proddb2
      --------------------------------------------------------------------------------
      Cluster Resources
      --------------------------------------------------------------------------------
      ora.LISTENER_SCAN1.lsnr
      1 ONLINE ONLINE proddb1
      ora.LISTENER_SCAN2.lsnr
      1 ONLINE ONLINE proddb2
      ora.LISTENER_SCAN3.lsnr
      1 ONLINE ONLINE proddb2
      ora.oc4j
      1 OFFLINE OFFLINE
      ora.proddb.db
      1 ONLINE ONLINE proddb1 Open
      2 ONLINE ONLINE proddb2 Instance Shutdown
      ora.proddb1.vip
      1 ONLINE ONLINE proddb1
      ora.proddb2.vip
      1 ONLINE ONLINE proddb2
      ora.scan1.vip
      1 ONLINE ONLINE proddb1
      ora.scan2.vip
      1 ONLINE ONLINE proddb2
      ora.scan3.vip
      1 ONLINE ONLINE proddb2
      -bash-3.00$

      Thanks.
        • 1. Re: 11g Rac Cluster Status
          986120
          Hi,

          Shutdown and Start database using srvctl utility.

          --
          Bala:)
          • 2. Re: 11g Rac Cluster Status
            J.A.
            Check the DB alert, ASM alert, CRS alert, ...etc

            Restart the DB instance in both nodes:

            ./srvctl stop database -d NAME

            or

            Restart everything on each node:

            ./crsctl stop crs

            I hoppe it helps

            After restart, check status : ./crs_stat -t


            J.A.
            • 3. Re: 11g Rac Cluster Status
              muba_zak
              Dear All

              Thanks
              As you suggested i restarted cluster services database instance and both servers , now status is

              ora.proddb.db
              1 ONLINE ONLINE proddb1 Open
              2 ONLINE ONLINE proddb2 Open

              but

              ora.asm

              1 ONLINE ONLINE proddb1
              2 ONLINE ONLINE proddb2 started

              after restarted the ora.asm started switched from proddb1 to proddb2, why its not showing STARTED for both.


              but bot asm instances started, both instances are working fine. when i connect OEM the asm agents unavailable

              please advise me

              Thanks