ORA-15063: ASM discovered an insufficient number of disks for diskgroup

 

When Start the Database getting error.

 

 

 

SQL> startup

ASM instance started

...

ORA-15032: not all alterations performed

ORA-15063: ASM discovered an insufficient number of disks for diskgroup "RECO"

ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA"

 

 

 

 

Action:


 Check that the disks in the diskgroup are present and functioning, that the owner of the ORACLE binary has read/write permission to the disks, and that the ASM_DISKSTRING initialization parameter has been set correctly. Verify that ASM discovers the appropriate disks by querying V$ASM_DISK from the ASM instance

 

 

Solution:

 

 #/etc/init.d/oracleasm scandisks

Scanning the system for Oracle ASMLib disks: DISK1

                                                           [  OK  ]

 

 

 

There are two disk for ASM but it showing one disk.

 

 

$ /etc/init.d/oracleasm init

 

 

$ /etc/init.d/oracleasm listdisks

 

DISK1

DISK2

 

 

$ ls -ltr /dev/oracleasm/disk/*

 

/dev/oracleasm/disks/DISK2

/dev/oracleasm/disks/DISK1

 

 

 

 

$ cd /grid/bin

 

$ ./crsctl stop resource -all

 

$ ./crsctl start resource -all

 

 

 

 $ crsctl stat res -t

--------------------------------------------------------------------------------

NAME           TARGET  STATE        SERVER                   STATE_DETAILS

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.DATA.dg

               ONLINE  ONLINE       localhost

ora.LISTENER.lsnr

               ONLINE  ONLINE       localhost

ora.LISTENER_GRID.lsnr

               ONLINE  ONLINE       localhost

ora.asm

               ONLINE  ONLINE       localhost                Started

ora.eons

               OFFLINE OFFLINE      localhost

ora.ons

               OFFLINE OFFLINE      localhost

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.cssd

      1        ONLINE  ONLINE       localhost

ora.diskmon

      1        ONLINE  ONLINE       localhost

ora.migrate.db

      1        ONLINE  OFFLINE                               Instance Shutdown

ora.orcl.db

      1        OFFLINE OFFLINE

ora.orcl.test.svc

      1        OFFLINE OFFLINE

ora.stby.db

      1        OFFLINE OFFLINE