Visit Counter

Tuesday, December 15, 2015

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