This discussion is archived
2 Replies Latest reply: Nov 8, 2012 12:37 PM by Shivananda Rao RSS

ORA-15063:

925887 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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

Legend

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