select * from v$asm_disk;
select * from v$asm_diskgroup;
alter diskgroup DATA01 resize disk ORA_MAIN size 360G;
ORA-15260: permission denied on ASM disk group
When I login 11gR2 ASM instance as sysdba to mount diskgroup, it showed permission denied on ASM disk group. After I login the ASM instance as sysasm, it is fixed.
SQL> alter diskgroup DATA1 mount;
alter diskgroup DATA1 mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group
SQL> connect / as sysasm <– as sysasm
Connected.
SQL> alter diskgroup data1 mount;
Diskgroup altered.
alter diskgroup DATA01 resize disk ORA_MAIN size 360G;
[grid@MDS-ORA-RAC-03 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Feb 26 15:40:38 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> connect / as sysasm
Connected.
SQL> alter diskgroup DATA01 resize disk ORA_MAIN size 360G;
Diskgroup altered.
I rattling delighted to find this internet site on bing, just what I was looking for :D besides bookmarked.
ReplyDeletemaillot de football...
ReplyDeletewow, awesome blog article.Really looking forward to read more. Awesome....
Quite good and it fixed my problem.
ReplyDeletethanks for it.
I am really happy to read this webpage posts which contains plenty of
ReplyDeleteuseful data, thanks for providing such information.