Wednesday, August 3, 2011

ORA-15063: ASM discovered an insufficient number of disks

While mounting diskgroups in asm DBA face issue where is there disks are not mounted properly in all nodes. System admin team need to rediscover disks to fix issue.

srvctl start diskgroup -g DG_TESTPARAM_DT01 -n test-poc-213
srvctl start diskgroup -g DG_TESTPARAM_DT02 -n test-poc-213
srvctl start diskgroup -g DG_TESTPARAM_DT03 -n test-poc-213
srvctl start diskgroup -g DG_TESTPARAM_RC -n test-poc-213



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



/opt/oracle > srvctl start diskgroup -g DG_TESTPARAM_DT03 -n test-poc-213PRCR-1013 : Failed to start resource ora.DG_TESTPARAM_DT03.dg
PRCR-1064 : Failed to start resource ora.DG_TESTPARAM_DT03.dg on node test-poc-213
CRS-5017: The resource action "ora.DG_TESTPARAM_DT03.dg start" encountered the following error:
ORA-15032: not all alterations performed
ORA-15017: diskgroup "DG_TESTPARAM_DT03" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DG_TESTPARAM_DT03"

Solution
=========
/usr/sbin > ./oracleasm listdisks
/usr/sbin > ./oracleasm scandisks


SA team need to mount all disks properly in all nodes.

No comments:

Post a Comment