2 Replies Latest reply: Nov 8, 2012 2:37 PM by Shivananda Rao RSS

    ORA-15063:

    925887
      Hi,


      Version :11
      Os :Aix6

      We getting the error while startup the asm in test database.


      +ASM-SQL> select name,path from v$asm_disk;

      no rows selected



      +ASM-SQL> alter diskgroup all mount;

      alter diskgroup all mount
      *
      ERROR at line 1:
      ORA-15032: not all alterations performed
      ORA-15017: diskgroup "II368_REDOGROUP01" cannot be mounted
      ORA-15063: ASM discovered an insufficient number of disks for diskgroup
      "II368_REDOGROUP01"
      ORA-15017: diskgroup "II368_ARCHGROUP01" cannot be mounted
      ORA-15063: ASM discovered an insufficient number of disks for diskgroup
      "II368_ARCHGROUP01"

      Acutally we don't have any diskgroup in the name of II368_REDOGROUP01,II368_ARCHGROUP01.
      These two groups related to production.Every month we refresh the db from production to Test.

      Any suggestions.

      Thanks

      Edited by: 922884 on Nov 8, 2012 12:11 PM
        • 1. Re: ORA-15063:
          mseberg
          Yes


          When this :
           select name,path from v$asm_disk;
          Returns 0 rows you have nothing to Mount.

          You have a cause and effect problem.

          Post

          #mount

          ORA-015039, ORA-15063: ASM Discovered An Insufficient Number Of Disks For Diskgroup [ID 1478128.1]


          Best Regards

          mseberg
          • 2. Re: ORA-15063:
            Shivananda Rao
            Can you check what is the value set for the parameter "asm_diskstring"

            Post the outcome of
            sql>show parameter asm_disk
            Normally, if the disks were created using ASMLIB, then check out the location of the ASM disks at the location "/dev/oracleasm/disks" and if the disks are present at this location, then set the parameter "asm_diskstring" to the above path. The default value of this parameter is "ORCL:*"
            asm_diskstring=/dev/oracleasm/disks