4 Replies Latest reply: Sep 19, 2012 8:24 AM by dataseven RSS

    ASM disk group not mount

    928704
      hi,
      we are using oracle 11.2.0.3.0 on solaris 10, using two diskgroup Data1 and Data2 for asm from which a disk group Data1 cant be mounted my database is down and show below message when try to startup facing this issue after installing oracle 10g on same server which uses new10g diskgroup.

      ORA-01078: failure in processing system parameters
      ORA-01565: error in identifying file '+DATA1/zidw/spfilezidw.ora'
      ORA-17503: ksfdopn:2 Failed to open file +DATA1/zidw/spfilezidw.ora
      ORA-15056: additional error message
      ORA-17503: ksfdopn:2 Failed to open file +DATA1/zidw/spfilezidw.ora
      ORA-15001: diskgroup "DATA1" does not exist or is not mounted

      ASM error
      ********
      SQL> select name,state from v$asm_diskgroup;

      NAME STATE
      ------------------------------ -----------
      DATA1 DISMOUNTED
      DATA2 MOUNTED
      NEW10G DISMOUNTED

      SQL> alter diskgroup DATA1 mount;
      alter diskgroup DATA1 mount
      *
      ERROR at line 1:
      ORA-15032: not all alterations performed
      ORA-15017: diskgroup "DATA1" cannot be mounted
      ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA1"
        • 1. Re: ASM disk group not mount
          kuljeet singh -
          ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA1"
          all disk are not available which required for DATA1 DG.
          Is this parameter properly set at asm level? check alert log to crosscheck parameters when asm was running fine.
          asm_diskstring
          error in identifying file '+DATA1/zidw/spfilezidw.ora'
          try to bringup the asm with correct spfile.
          • 2. Re: ASM disk group not mount
            Billy~Verreynne
            An ASM diskgroup consists of 1 or more disks (raw devices, SAN LUNs, etc).

            An externally redundant diskgroup needs all the disks of that diskgroup to be available for use. Data is stripped across all disks. So if any 1 disk is not available, that diskgroup cannot be used.

            A normal or high redundant diskgroup is mirrored. In this case, all the disks in a single failgroup needs to be available for that diskgroup to mount. Such a diskgroup can run on a single failgroup (one part of the mirror).

            If your DATA1 is normal or high redundancy, and all the disks of a failgroup is available, you can force DATA1 to mount.

            If you do not have an intact failgroup, or intact externally redundant diskgroup, the diskgroup cannot be mounted.

            Reasons for why specific disks for a diskgroup are not available, varies. It could be a permission issue. It could be that the device's name has changed. It could be a SAN or storage array issue. Etc.

            You need to determine:
            a) the name(s) of the missing disk(s) that ASM needs for that diskgroup
            b) why those disks are not being made available by the kernel (looking at +/var/log/messages+ for example for device errors)
            • 3. Re: ASM disk group not mount
              Pinela
              hi,

              check the asm_disk_string parameter,
              and check as well the permissions on your disks.

              either the permissions where changed (like after a reboot), or the devices changed names.
              also you should have an init file, startup the asm instance with the pfile.

              br,
              pinela.
              • 4. Re: ASM disk group not mount
                dataseven
                hi,

                pls take a look this doc

                http://askdba.org/weblog/2008/05/ora-15063-asm-discovered-insufficient-amount-of-disks-2/

                regards,