Take the 2-minute tour ×
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. It's 100% free, no registration required.

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;

DB_NAME  INSTANCE_N STATUS
-------- ---------- ------------
+ASM     +ASM2      CONNECTED
+ASM     +ASM2      CONNECTED

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 at 20:50
    
I think the ORA-15321 is telling you that –  Phil Feb 25 at 22:02

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.