ORA-15001: diskgroup " " does not exist or is not mounted

Issue:
====
SQL> drop diskgroup TESTDAT;
drop diskgroup TESTDAT
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15001: diskgroup "TESTDAT" does not exist or is not mounted


SQL> select name from v$asm_diskgroup;

NAME
------------------------------
TESTDAT


Fix:-
====
SQL> drop diskgroup TESTDAT force including contents;

Diskgroup dropped.

ORA-15306: ASM password file update failed on at least one node

Error:
ORA-15306: ASM password file update failed on at least one node

Error by itself is very misleading someone would think the password might have messed up or got corrupted or missing.

In my case none of the above were true.

When I tried this sql i.e trying to alter the password of a user on the ASM instance.

SQL> alter user dbsnmp identified by test;
alter user dbsnmp identified by test.
                                *
ERROR at line 1:
ORA-15306: ASM password file update failed on at least one node




SQL> show parameter remote_login_passwordfile

NAME                                 VALUE
-------------------------         ------------
remote_login_passwordfile            EXCLUSIVE


password file parameter is set properly

My password file exists on all nodes and in fact I can connect  as sysasm to the instance so I know it is not the password file issue then what?

Here my problem was the user doesn't exists in the ASM to begin with..
SQL> select * from v$pwfile_users;

USERNAME      SYSDBA          SYSOPER         SYSASM
--------------------------------------------------------------------------------
SYS              TRUE            TRUE            FALSE

I don't have the user in the database for which  I am trying to change the password for.

Now go ahead and create the user in the ASM database.


SQL> create user dbsnmp identified by test;

User created.


SQL>grant sysdba to dbsnmp;



SQL> select * from v$pwfile_users;

USERNAME      SYSDBA          SYSOPER         SYSASM
--------------------------------------------------------------------------------
SYS                  TRUE            TRUE            FALSE
DBSNMP           TRUE            TRUE            TRUE

drop bad disk from the ASM

1>Please check with your system/Storage administrator on this disk level issue ,make sure not a single block get overwritten.

2>If you have enough space on other disks to hold data of this effected disk,drop that disk ,seems there is some OS level corruption at this disk level ,so it is not able to read that block.

sql> alter diskgroup PROD_DATA_01 drop disk PROD_DATA_01_0045 rebalance power 5;

Wait for rebalance to complete .

from ASM sqlplus till below query returns "no rows selected"

sql> select * from v$asm_operation ;

If you does not have enough space then add a new disk to this diskgroup and the drop this disk ,

Remember ,both separate operation will cause rebalance operation to kick-off,so you have to allow both of them complete.


3> Then start the database on mount stage,

sql> startup mount;

Then check any datafile needs recovery or not,

select * from v$recover_file;

4> If required recovery then ,do recovery of those specific datafiles.

5> Then open the database .


Note:: If after dropping you face any issue related to spfile ,then please recreate the spfile (As it is in same effected diskgroup).
Then refer to below document ,

Recreating the Spfile for RAC Instances Where the Spfile is Stored in ASM (Doc ID 554120.1)

How to add disks to existing ASM disk group in 11gR2

Here I am going to show you how to add new disks( or extra space/storage) to the existing ASM diskgroups.

Given:

Unix SA has provided/presented the new raw devices with the same size as the existing disks in our ASM disk group.


here my asm discovery path or the location where the new disks have been presented is
"/dev/oracle/"

given/need to add the six new disks:
crw------- 1 oracle oinstall 302, 42061 Dec 8 14:59 disk64g_t1_0028
crw------- 1 oracle oinstall 302, 42062 Dec 8 14:59 disk64g_t1_0029
crw------- 1 oracle oinstall 302, 42063 Dec 8 14:59 disk64g_t1_0030
crw------- 1 oracle oinstall 302, 42064 Dec 8 14:59 disk64g_t1_0031
crw------- 1 oracle oinstall 302, 42065 Dec 8 14:59 disk64g_t1_0032
crw------- 1 oracle oinstall 302, 42066 Dec 8 14:59 disk64g_t1_0033


current disk group info:

ASM Diskgroup information ..


DiskGroup Name %Used TOTAL_MB FREE_MB
-------------------- ----- ------------ ------------
ICMQA_DATA_01 95 1,768,532 85,547


To the above disk group we are going to add new disks.


Invoke asmca after setting the X11 and display settings.


my unix host(+ASM1) /export/home/oracle
>asmca


then follow the screen shots.




now click on disk groups.



right click on the disk group where you want to add new disks to.




click on add disks.




now select the disks that you want to add to and click ok.





disks have added now.

After adding the disks.





ASM Diskgroup information ..


DiskGroup Name %Used TOTAL_MB FREE_MB
-------------------- ----- ------------ ------------
ICMQA_DATA_01 78 2,161,538 478,541