Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to set an attribute on my ZFS Storage Appliance. I have shutdown all attached databases but still I get this message:

SQL> alter diskgroup DATA_ZFS02 set attribute 'storage.type'='ZFSSA';
alter diskgroup DATA_ZFS02 set attribute 'storage.type'='ZFSSA'

ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15242: could not set attribute storage.type
ORA-15321: cannot set attribute with connected clients

SQL> col instance_name format a10
SQL> select db_name, instance_name, status from v$asm_client;

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

Do I shutdown my ASM2 instance as well? Can I set the attribute if asm instance is down?

Thank you,

Bjarte Brandt

share|improve this question
Do really need to take down the cluster to do this? Looks like I have to startup one cluster node in exclusive mode. .. or recreate the diskgroup with proper attributes. – Bjarte Brandt Feb 25 '14 at 20:50
I think the ORA-15321 is telling you that – Phil Feb 25 '14 at 22:02

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.